Last used from RSRT

[Former Member]

Can I find the date a query was last used (also if not used) from RSRT? If so how? Thanks

[edwin_harpino · Accepted solution]

yes

[edwin_harpino]

should be last changed

[Former Member]

Thanks had a look at some other queries it seems that OLAP-Relevant Data section will include Last date rows if it has been used, I have compared with table RSZCOMPDIR is that correct?

[Former Member]

Hello Niten,

i checked out the OLAP-relevant data section. but it does not diplay current date and time though i had used the query few minutes before...

it may be the last changed date!!

Hope it helps...

thanks,

[former_member188325]

could you pl check 'LASTUSED' from RSZCOMPDIR and UTC Time Stamp in Short Form (YYYYMMDDhhmmss) in RSRT?both are same?compare both values for all Queries and get it confirmed.

Message was edited by: Murali

[edwin_harpino]

hi,

i just executed a query, and LASTUSED in RSZCOMPDIR

is updated, but nothing change in RSRT, still the date that query last changed, same with TSTPDAT

and TSTPTIM in RSZCOMPDIR(Changed On, Changed at).

so it should be last changed.

hope this helps.

[Former Member]

Thanks for that, therefore the most reliable source for the information would be RSZCOMPDIR?

[edwin_harpino]

hi Niten,

seems no last used,

check button 'technical information'.

hope this helps.

[Former Member]

Thanks had a look there as well, the date at the top

UTC Time Stamp in Short Form (YYYYMMDDhhmmss) would this be created on date or last changed?