runcat & last 'accessed' Analysis

Question

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

Hesh · Answer

Thanks Gianni Ceresa!

Gianni Ceresa · Answer

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 · Answer

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