How do we know who mades the changes?

[dspxlearn]

Hi all!!

Just curious to know-
If someone opens a job and saves without making any changes, can we by any chance know who has made the 'Save' ?
What in case of a job and in case of a shared container?
Because, in shared container we would not have logs stored

[ArndW]

There is an audit trail loaded into the DataStage hashed file called DS_AUDIT; this does store information including which user saved a given job or container but it doesn't contain any details on what changes were made.

[ray.wurlod]

Modifications are actually in a nested table called DS_AUDIT_MODS. Search the forum for column names you can use to query DS_AUDIT, which you can do using DataStage/SQL, or a Hashed File or UniVerse stage.

[swades]

This will help you. perticularly Ray's post.

Thanks

[dspxlearn]

swades,

Ray's code was-

Code: Select all

SELECT INSTANCE, DTM, MODIFIER, REASON 
FROM DS_AUDIT 
WHERE CLASS = '2'   -- select only jobs 
AND INSTANCE = '<<Job name>>' 
AND DTM >= '<<yyyy-mm-dd>>' 
WHEN DTM >= '<<yyyy-mm-dd>>'

Can it be used for shared containers also?
I was using the below code for shared containers. I couldn't get any result...

Code: Select all

SELECT INSTANCE, DTM, MODIFIER, REASON FROM DS_AUDIT 
WHERE CLASS = '2'AND INSTANCE = 'sharedcont' 
AND DTM >= '2007-05-07' WHEN DTM >= '2007-05-07';

[/code]

[ArndW]

That would only work for objects called "sharedcont". Shared containers are actually in the class 24 so the original SQL wouldn't find them.