runcat & last 'accessed' Analysis

Hesh

Hi,

OBIEE 12.2.1.0.0

I am exploring runcat.sh to build some automation scripts to manage Catalog objects in Linux environment.

I can find Created & Modified using 'fields' which I believe can provide the information about when was the object created and last modified...

What I am looking for is when was the last time the OBIEE object (Eg. Analysis ) was 'accessed' ...

This can help me to list the catalog objects which are not in use for some X time.. and I can report the same for further actions..

Regards

Hesh

Gianni Ceresa

Hi,

For that info you better setup (if not already done) and use usage tracking. In the past I found the created and last modifier info to be a bit weird, while usage tracking is more reliable.

Hesh

Thanks Gianni Ceresa,

Good thought! usage tracking should be perfect fit to know what are the Analysis in use.. I will try to integrate runcat along with usage tracking..

Regards

Hesh

Gianni Ceresa

You can easily script things, doing queries on the usage tracking table and loading the runcat results with a list of all the objects etc.

I also have the impression the create and modified date you get from runcat are ... a bit random (I had some weird results in the past on those fields).

Hesh

Thanks Gianni Ceresa!