10-15-2008 8:32 AM
hi,
I want to get the last run details of all the program
I would like to give the date as a selection parameter.
It should give tha program names which are all acessed on that date.
where the details like when the program is run at last will be saved.
Is there any file/standard tables contain such details?
Thanks,
Mythili
10-15-2008 8:33 AM
10-15-2008 8:34 AM
This is about to become the most frequently asked question around here.
Just search a little bit and find out.
Thomas
10-15-2008 8:40 AM
hi,
thanks!
I want to get the programs accesed on the date given.
How to get the details in my report program from thaat transaction.?
Regards,
Mythili
10-15-2008 10:12 AM
10-15-2008 10:16 AM
hi,
Did you see thomas reply.
You have lot of similar posts in SCN.
you can get these details from STAD transaction but you will not get all the details .only those details related to last 1 week may be.
10-15-2008 10:20 AM
HI Gautham,
I got the posts only abt last run of a program.
can u pls send the link.
And also I want to get the details based on date duration.
Regards,
Mythili
10-15-2008 10:27 AM
hi,
goto STAD transaction.
give start time,start date,read time.
for ex:
start date: 14.10.2008
start time : 10:20:00
read time or length : 24:00:00
user : *
from here you can get only last24 hr before triggered transactions only.
10-15-2008 10:40 AM
Hi Gautham,
Yes, i have gone through that.
Is there any option to display all the reports that has been accessed by different users in a report program?
Like we have the fields CNAM,CDAT,UNAM,UDAT in TRDIR table...Similarly can i get the details of the last execution time and user in my report program as a list?
Hope u get my question.
Thanks,
Mythili
10-15-2008 10:43 AM
hi,
you cannot get that details in a list.
you can get only last executed details only from that table.
hope this helps.
10-15-2008 10:47 AM
>
> HI Gautham,
>
> I got the posts only abt last run of a program.
That is what you asked in your first post.
if you forgot just find below line from your post:
I want to get the last run details of all the program
10-15-2008 1:17 PM
Yes Amit.I do.
I want to get the program details run after that date.
Not the last date run of a particular program.
My scenario is to get the programs have been run after the specified date.
10-15-2008 1:35 PM
My guess there is no chance to get these details beyond a week or so.
Edit:Yes may be possible from SM20 audit log analysis.but i have never done this.
Edited by: Ámit Güjärgoüd on Oct 15, 2008 3:01 PM
10-15-2008 2:00 PM
check out program RSAU_SELECT_EVENTS.
Audit log needs to be active, plus you need to have the necessary authorizations. These records are usually kept for a year or longer (again, it must be active at all for this to be useful).
Thomas