‎2009 Mar 16 12:34 PM
Dear Experts,
We had a requirement to find out the recently used Zprograms(Customer Programs). For example we had around 3000 customer programs in our production server in that we want to find out last six months used programs and the last execution date of all the programs. IF any t.code or programs please inform me...
Regards
Senthil Kumar.S
‎2009 Mar 16 12:54 PM
hi senthil , for your requirement ,
Tcode - st03n - work load analysis , in that change the user mode to expert mode .
in workload tree ,click the total and double click on the month and in the analysis view click the transaction profile .and choose either standard or early watch. it will display all the programs executed .
download that to excel and separate the zprogram list from the excel .
regards
chinnaiya
‎2009 Mar 16 12:37 PM
Hi,
Try with SM20 Tcode it will display following details and click on Read audit log button
Program name
user name
Tcode
Date time also
Thanks
Ramakrishna Pathi
‎2009 Mar 16 12:37 PM
‎2009 Mar 16 1:59 PM
Dear all,
How to find out Last 6 months used program.
Regards
Senthil Kumar
‎2009 Mar 16 12:38 PM
Hi,
Check the transaction STAD . it will give you the required info.
But I dont think it tracks activities for more than a couple of days.
I believe you will need to devise a custom solution for this.
-RJ
‎2009 Mar 16 12:41 PM
Pls follow this,
1) Tcode SE11
2) table TRDIR
3) Field: Udate: value: GT EQ 14.07.2007(as per ur requirement)
4) check objects: Field Name: value: z,y,lz,ly,saplz,saply
5)execute
It will meet ur requirement
Regards
Arani Bhaskar
‎2009 Mar 16 12:41 PM
‎2009 Mar 16 12:46 PM
>
> Last execution details you can get from TRDIR view.
Which TRDIR field holds this information?
‎2009 Mar 16 12:50 PM
Hi Thomas,
"NAME" field displays the program(object) names for the selected duration with specific Z*, it will displays all programs which are availble inthat duration.
Regards
Arani Bhaskar
‎2009 Mar 16 12:51 PM
‎2009 Mar 16 12:53 PM
‎2009 Mar 16 12:59 PM
>
> Check these fields.
>
> IDATE
> ITIME
> SDATE
> STIME.
Hi Gautham, these are timestamps of the last selection screen generation, not the last program execution (the screen is not being generated at each execution).
This question has been asked so many times before, I think the essence is that for long term analysis maybe SM20 can be used (if activated and kept for long term), otherwise a custom Z-table is the way to go, but this cannot be filled retrospectively. The other answers I have seen don't work correctly or not at all. As always, I'm happy to be proven wrong and learn more.
Thomas
‎2009 Mar 16 1:05 PM
None of these field would give you this information.
These field store the information of last Activation of Program and selection screen.
P.S.Sorry Thomas i should have to reply Gautham but By mistake i replied you, never Mind
Weekend hangover ;-(
Gautham:I guess a while ago who gave the solution of other question but based on same fields!
I'm sure you must know but i guess you missed the question in hurry.
Edited by: Amit Gujargoud on Mar 16, 2009 2:07 PM
‎2009 Mar 16 12:54 PM
hi senthil , for your requirement ,
Tcode - st03n - work load analysis , in that change the user mode to expert mode .
in workload tree ,click the total and double click on the month and in the analysis view click the transaction profile .and choose either standard or early watch. it will display all the programs executed .
download that to excel and separate the zprogram list from the excel .
regards
chinnaiya
‎2009 Mar 16 1:03 PM
‎2009 Mar 16 1:26 PM
‎2009 Mar 16 2:01 PM
Not being rude...This same question has been asked for about 10,000 times..i have asked this myself once.Just use search button before placing a question.