Query last used by - without installing BI-technical Content

[Former Member]

Hello,

I want to know, which user a query used last time - table RSZCOMPDIR provides the "Owner" and "Last changed by" only.

Do you have any idea, which table contains this information?

I dont want to install the technical content.

Regards,

Thomas

[former_member636500 · Accepted solution]

Hi,

You can find this information in RSDDSTAT_OLAP table.

Enter a query's technical name in OBJNAME field and a date in CALDAY one. It will be returned a list of all users (UNAME field) that executed the query in that day (sort the list by UTIME field to get to know who was the last user).

Regards,

Tiago

[Former Member · Accepted solution]

Hello Tiago,

thanks for your fast answer - it solved my problem.

Regards,

Thomas

[Former Member]

This message was moderated.

[Former Member]

Hello,

the tables do not contain the information, I'm searching.

Thomas

[Former Member]

This message was moderated.