Need to find out the queries which did not executed in 2014

[former_member558460]

Hi All,

I need to find out the queries which start from YY  and did not executed in 2014, earlier we used to find out by looking into the technical content cube 0TCT_C02 but now its giving dump as number of queries increases. I tried to find out using table RSZCOMPDIR but not able to trace it exactly. Please suggest some alternative solution to find out the queries which did not execute in 2014 so that we can delete it.

Thanks,

Asim.

[Former Member]

Hi Asmin,

I build a query on 0TCT_MC01. Here you can see if a user executes a query/webtemplate in a defined time frame.

Hope it helps.

Stephan

[KulDeepJain]

Hi Asim,

You can get this informations from Statistical tables from BI.

If you have BI Statistics (0TCT*) implemented then you can look for 0TCT_C02 cube data, else you have to go RSDDSTAT_OLAP table .

Thanks,

KDJ

[former_member558460]

Hi All ,

Thanks for the reply, I will try to trace out using those tables.

@ Marco Lamers : I was getting connection time out error. As there are lot of queries.

Regards,

Asim

[sriramvijay_ravidoss]

Hi,

RSDDSTAT_OLAP : This is the table which contains query execution details

CALDAY field in that table gives you query execution date

OBJNAM gives the query name

As you said RSZCOMPDIR gives list of all queries. doing a lookup between these tables will identify the queris which are not executed in particular period.

-Sriram

[Former Member]

please explain something more about the dump you are getting?

What are the errors? timeouts perhaps?

if you analyse 0TCT_C02 by calyear you should get results i expects.

So please provide some more info.