Skip to Content
0
Former Member
Jan 18, 2011 at 01:50 PM

How to find out Query last used by whom

2289 Views

Dear All,

Can any one tell me that "How to find out the Query last used by whom. I have already searched in SDN but no luck. In my system BW Stats are not installed and I have already checked the below tables.

RSZELTDIR - Directory of the reporting component elements

RSZELTTXT - Texts of reporting component elements

RSZELTXREF - Directory of query element references

RSRREPDIR - Directory of all reports (Query GENUNIID)

RSZCOMPDIR - Directory of reporting components

RSZRANGE - Selection specification for an element

RSZSELECT - Selection properties of an element

RSZELTDIR - Directory of the reporting component elements

RSZCOMPIC - Assignment reuseable component <-> InfoCube

RSZELTPRIO - Priorities with element collisions

RSZELTPROP - Element properties (settings)

RSZELTATTR - Attribute selection per dimension element

RSZCALC - Definition of a formula element

RSZCEL - Query Designer: Directory of Cells

RSZGLOBV - Global Variables in Reporting

RSZCHANGES Change history of reporting components

I am able to find out the Date and time but not the user name. So could you please help on this.

Regards

Sankar