Report - Used by user

[Former Member]

Hello all,

Is there any table from i can check

1. Report is executed by how many users

2. Report not used for how long etc.

Thanks

[Former Member · Accepted solution]

Hi Samit,

You can use Technical Content cubes to get this information.

Create a simple reports on the multiprovider 0TCT_MC* based on your requirement and you can have a very detailed information about query runtime, list of users using the report, when it was last executed etc.

Hope this resolves your query.

Thanks,

Sachin

[Former Member · Accepted solution]

is there any table for that

[Former Member · Accepted solution]

Check the view RSDDSTAT_OLAP. It will give you the information about User ID, Session ID, when it was last run etc.