Get a list of the report seen by teh users

[Former Member]

Hi expert,

I need to know what report has been seen the users, and what report has been changed.

I'd like to know about any transaction that can help me get this information.

Can you help me please?

Thanks.

[chemicala_srimallikarjuna]

Hi,

Pls Check the table RSDDSTAT .

You can only get this information if the query/ workbook is enabled for statistics logging in transaction RSDDSTAT.

If it is enabled you can goto table RSDDSTAT ( BW 3.5) or RSDDSTAT_OLAP( BI 7.0 ) to see the users who executed the query . These tables store all the information per query session and you will find more than one rows per session but you can find the information you want i.e. users executing a particular query / workbook.

Also Tcode: SU01 will give you all the user lists in the server.

Regards

CSM Reddy