Job access log

techiexavier · Post by **techiexavier** » Fri Aug 17, 2012 1:05 am

Hi All,

I want to get the list of users who has modified particular job and which date it has been modified, since it is created.

I am able to get last user modifed, created date and last modified date in Designer.

Please help me if it is possible in DS 8.5 with UNIX script or in Designer.

TIA.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 17, 2012 1:11 am

Welcome aboard.

This information can be found in the DS_AUDIT table, MODS association.

Search DSXchange for examples.

ArndW · Post by **ArndW** » Fri Aug 17, 2012 1:12 am

Welcome to DSXChange,

There is a hashed file called "DS_AUDIT" in each project with contains some information about the job creation and modification dates. This file is not documented, but can be read from a DataStage server job.
Unfortunately the information about the actual user doing the changes isn't visible in this file - it always shows as "dsadm" or whatever user you have chosen at installation time for the engine.
I haven't been keeping up with the repository changes at 8.7 (or 8.5, for that matter) and there might be a way to get this information in another manner.

techiexavier · Post by **techiexavier** » Tue Aug 21, 2012 11:54 pm

Thanks for your replies... i am not able to get exactly what i require. But helps me to work with DS_AUDIT...