cancel
Showing results for 
Search instead for 
Did you mean: 

Query last used date

Former Member
0 Kudos

Hi all

How can I access the info of the date a query was last used.

Meir

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Used the trasaction to view table RSZCOMPDIR. In table RSZCOMPDIR there is a field Lastused which shows date & time stamp (yyyymmddhhmmss) format. this will help u to get date of last used & COMPID filed will show u tachnical name of query.

Hope it will work

Assign points if u find it suitable

Sangita

Former Member
0 Kudos

Table RSZCOMPDIR, field COMPID shows query technical name and field LASTUSED shows timestamp the last time query executed. If in this field there is no timestamp given and it shows 0 it's never been used.

Hope it helps.

Thanks

Mona