How to know the user name who has updated/develped the job

[datisaq]

Hi DS Experts,
Is there any way to find out the datastage user who has developed a particular job and also how to find out the user who has last modified the datastage job?

Please provide inputs to this...Any help will be greatly appreciated,,,

[ray.wurlod]

This is maintained in a table called DS_AUDIT in the local repository.

A Search for DS_AUDIT will reveal all you need to know and more.

[Sainath.Srinivasan]

But from version 8 onwards, DataStage users are translated to their credentials mapped in WAS. So check you have 1 - 1 correspondence in it.

[JoshGeorge]

Search your XMETA (repository) for columns NAME_XMETA (For the Job Name)& XMETA_MODIFIED_BY_USER_XMETA (For the user) in table name like
DATASTAGEX%*%DSJOBDEFC2E76D84 with where clause for job name(s).

[ray.wurlod]

Note that the final eight characters of the table name will differ in your case; it is tied to your licence, not Joshy's.

[JoshGeorge]

Have a reach here in dsxchange for "C2E76D84" and see. All the sites I'd gone had the same last eight characters, be the repository on DB2 or Oracle. Generic report creation for job design, logs, statistics & project auditing queries I created worked across the sites. According to Ray most of the sites share the same licence?

Note that the final eight characters of the table name will differ in your case; it is tied to your licence, not Joshy's. ...

[ray.wurlod]

DS_AUDIT seems to be being maintained in version 8 also, though recording of CLASS cannot be relied upon.

[chandra.shekhar@tcs.com]

SELECT CONTAINER_RID, XMETA_REPOS_OBJECT_ID_XMETA, XMETA_CREATED_BY_USER_XMETA,(TIMESTAMP('01/01/1970', '00:00:00') + (XMETA_CREATION_TIMESTAMP_XMETA / 1000) SECONDS) - 8 HOURS AS XMETA_CREATION_TIMESTAMP_XMETA ,XMETA_MODIFIED_BY_USER_XMETA, (TIMESTAMP('01/01/1970', '00:00:00') + (XMETAMODIFICATIONTIMESTAMPXMET / 1000) SECONDS) - 8 HOURS AS XMETAMODIFICATIONTIMESTAMPXMET,NAME_XMETA,SHORTDESCRIPTION_XMETA,JOBTYPE_XMETA,CATEGORY_XMETA,DSNAMESPACE_XMETA FROM DATASTAGEX_XMETAGEN_DSJOBDEFC2E76D84

[ray.wurlod]

Why " - 8 HOURS " ?

And why 15 months after the question was posed?