Determining job 'ownership' in a project..

Cowmix · Post by **Cowmix** » Thu Jun 01, 2006 12:00 pm

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!

kcbland · Post by **kcbland** » Thu Jun 01, 2006 12:08 pm

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....

DSguru2B · Post by **DSguru2B** » Thu Jun 01, 2006 12:16 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 01, 2006 4:15 pm

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.

kcbland · Post by **kcbland** » Thu Jun 01, 2006 4:59 pm

What typo?