Xmeta query to get list of all assets changed or modifed

dsdoubt · Post by **dsdoubt** » Mon May 16, 2016 12:28 pm

Greetings DSxcians!

I wanted to collect the list of all components including (*.pjb, *.qjb, *.sjb, *.prt, *. srt, *.tbd etc) which got Created or Modified within the last 24 hours.
I am able to see few options here but all provide for only Jobs. I would like to get it for all the components, including Jobs, routines, Transforms etc.

Along with the path and extensions of the component.

Any pointers? There is an ITEMS table which gives the complete list, but wouldn't give me the path or extensions. Do I need to join? Has anyone worked it out yet?

ray.wurlod · Post by **ray.wurlod** » Mon May 16, 2016 4:39 pm

Why not just get Metadata Workbench to effect a search filtered on date/time modified? You can turn the result of this search into a report.

DrackThor · Post by **DrackThor** » Mon May 16, 2016 11:21 pm

Hi - yeah just use some MWB queries to get all changed objects.
You can use the asset hierarchy at this point.
E.g. you don't have to get jobs, stages, projects separately, just query the assets with lowest granularity, e.g. link and get the job, project,.. information of this asset.
Same for database, table, column..
This way you won't need that many queries

For objects like tableDefs, Routines, etc. I'm afraid you will need a query for each.
Before you start to build all the queries, you should ask yourself if you really need "all" changed objects..