Xmeta query to get list of all assets changed or modifed
Posted: 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?
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?