Page 1 of 1

Determining job 'ownership' in a project..

Posted: Thu Jun 01, 2006 12:00 pm
by Cowmix
I have a folder with 1500 jobs and about 45 developers.. Is there any way to figure out (besides the obvious thing like asking my developers) who was the last person (or user ID) to modify or create a job?

thanks!

Posted: Thu Jun 01, 2006 12:08 pm
by kcbland
For DS 6.0+ the DS_AUDIT hashed file tracks changes done via the Designer or Manager. That will tell you a lot about who touched a job last. Search the forum for this undocumented internal repostory file....

Posted: Thu Jun 01, 2006 12:16 pm
by DSguru2B
You can also use the DS_AUDIT table. Connect to it using the Universe stage with dsn localuv. You can get all the information you require from there.

Posted: Thu Jun 01, 2006 4:15 pm
by ray.wurlod
It is DS_AUDIT. "DS.AUDIT" was a typo, which has since been corrected via the edit facility. Clearly this is an example of a Type 1 SCD. These things happen occasionally. "Table" and "hashed file" are interchangeable terms in this particular context.

Posted: Thu Jun 01, 2006 4:59 pm
by kcbland
What typo? :wink: