log to see a tcode used in last 15 days

[Former Member]

hi pros

i need to see a how many times a tcode used in last 1 month. is there any report? i used stat but didnt give anything. please reply!

[Former Member]

Do you have the security audit log turned on? If so you can run transaction SM19 to see this information.

Cheers,

Ben

[Former Member]

Sadiq,

Actually SM20 to view the log.

You can also use STAD (or STAT depending on version) for more recent events.

Cheers,

Ben

[Former Member]

benjamin,

it only gives me for last 4 hours, thats when the log was turned on by basis team. actually i have a list on tcodes to eleminate the least used ones in last one month.

any suggestions

thanks

[Former Member]

Turn on the security audit log. Transaction SM19. This will only capture new activity.

STAT/STAD is short term only and the actual amount of data is dependent on how it's setup.

Cheers,

Ben

[Former Member]

Hi Sadiq,

Use the table CDHDR/ CDPOS - you can get it

Thanks

Anands

[Former Member]

Try ST03N in Expert Mode, you will see the data group by day, week, month. The data is by apps server, you need to use the "total" for all app server. You can get the "dialog steps" per transaction under Memory Use Stat.

Good luck.

Thanks,

Lye

[Former Member]

hi

Try STAT,STO3,SM19,SM20,STAD,SPAU/SPAD.

chk this table FRUN .

For writer/painter reports you can view stats via SE16 in table T803J. For all reports and transactions execution info is stored in table MONI. This is the same info available via ST03 and to some extent STAT. Info for MONI is collected from the UNIX servers and totalled on MONI by day, week, month, year. Retention periods are set by the Basis group. We have a custom table where this information is stored by period for historical and licensing purposes. Be sure to use the SAP function modules to retrieve data from MONI.

Also check this sample code from other thread.

• internal tables for use counterdata:

begin of list occurs 5.

include structure sapwlserv.

data: end of list.

data: begin of applicat occurs 0.

include structure sapwlustcx.

data: end of applicat.

data: begin of applica_ occurs 0.

include structure sapwlustcx.

data: end of applica_.

data: begin of applicau occurs 0,

entry_id like sapwlustcx-entry_id,

account like sapwlustcx-account,

count like sapwlustcx-count,

: end of applicau.

data: wa_applicau like applicau.

&----

---

*& Form MONI

&----

---

form moni.

data: l_host like sapwlserv-hostshort.

m_start = p_usedt.

• get server

call function 'SAPWL_SERVLIST_GET_LIST'

tables

list = list.

do.

loop at list.

• loop on server

check not list-instshort is initial.

l_host = list-instshort.

• get statistics per month and server

perform workload using m_start l_host.

endloop.

add 31 to m_start.

if m_start > sy-datum.

exit.

endif.

enddo.

sort applica_ by entry_id.

sort applicau by entry_id count descending.

endform. " MONI

&----

---

*& Form WORKLOAD

&----

---

form workload using p_start like sy-datum

p_host like sapwlserv-hostshort.

refresh: applica_.

• read application statistic from MONI

call function 'SAPWL_WORKLOAD_GET_STATISTIC'

exporting

periodtype = 'M'

hostid = p_host

startdate = p_start

only_application_statistic = 'X'

tables

application_statistic = applica_

exceptions

unknown_periodtype = 1

no_data_found = 2

others = 3.

sort applica_ by entry_id account.

loop at applica_ where entry_id(1) ge 'Y'. "#EC PORTABLE

clear wa_applicau-entry_id.

wa_applicau-entry_id(25) = applica_-entry_id.

wa_applicau-account = applica_-account.

wa_applicau-count = applica_-count.

collect wa_applicau into applicau.

endloop.

sort applicau by entry_id count descending.

applica_-ttype = space.

applica_-account = space.

modify applica_ transporting ttype account where ttype ne space.

• collect only enhancements statistic

if p_temp = 'X'.

loop at applica_.

applica_-entry_id+25(48) = space.

collect applica_ into applicat.

endloop.

else.

loop at applica_ where entry_id(1) ge 'Y'. "#EC PORTABLE

applica_-entry_id+25(48) = space.

collect applica_ into applicat.

endloop.

endif.

endform. " WORKLOAD

Hope this will help.

[former_member190272]

Hi

Please check T Code ST03.It show user history.

Rewards point if helpful

Thanks

Pankaj Kumar

[Former Member]

Hi,

Transaction ST03 is good, but you should also check ST03N, and ST03G.

ST03N is "new" and ST03G is "global version"

It all depends on what kind of SAP system you are running.

best regards,

Karl Yngve

[Former Member]

i tried all the suggestions made so far but it does not give me anything older than yesterday

[Former Member]

Sadiq - Did you try looking in to table CDHDR and CDPOS - you should see all the TCodes accessed in here - because this takes the data to RBE