Skip to Content
0
Mar 17, 2009 at 04:51 PM

Query last run - Technical Content

31 Views

Hello everybody,

we've upgraded to BI 7.1 and i've got a problem with Technical Content.

Beofre I fix TC, I need to quick find out which queries were not used in the last 3 months. (generally, which query was not used since a certain date). In BW 3.5 was easy to look in the table RSDDSTAT. Obviously RSDDSTAT doesn't contain current information anymore: the last records have the date 20090116 - which is the date we've upgraded, i.e. new information is written in other tables.

Does anybody know where I can find the date of tha last run for a query?

thanks in advance

Alexander