AndrewBaines
Technical User
I'm querying the CMS to try and find out when an rpt was last modified.Doesn't appear to be possible.
I can get:
1) SI_CREATION_TIME - the time the object was created. (not modified)
2) SI_LAST_RUN_TIME - time last run - obviously wrong.
3) SI_UPDATE_TS - looked promising, but it's only when ANYTHING was modified. Scheduling the report changes this to the schedule time.
I could theoretically query the file via the FRS, but I'm loading information from all reports so that would potentially be a huge overhead.
Any ideas?
Thanks
Andrew
Andrew Baines
I can get:
1) SI_CREATION_TIME - the time the object was created. (not modified)
2) SI_LAST_RUN_TIME - time last run - obviously wrong.
3) SI_UPDATE_TS - looked promising, but it's only when ANYTHING was modified. Scheduling the report changes this to the schedule time.
I could theoretically query the file via the FRS, but I'm loading information from all reports so that would potentially be a huge overhead.
Any ideas?
Thanks
Andrew
Andrew Baines