reporting from DS repository

[kh]

I'd like to produce a file daily that includes information such as object name, object type and last modified date for all the jobs, job sequences, shared containers, routines and transforms in our production project(s). (The purpose of this is to provide an audit mechanism so someone can see that something changed on a given date and then verify that it went through all the proper channels in terms of change management, configuration management, etc.)

The Reporting Assistant would allow me to do this, but it excludes job sequences and shared containers. I've thought about automating some combination of dsjob and dsexport scripting, but there seem to be ~a lot~ of problems with this approach. I guess I think it would just be extremely complicated for a scripting novice.

Does anyone have any ideas? Is the repository accessible via DataStage jobs?

[ray.wurlod]

In the repository there is a table called DS_AUDIT that records the date/time and by whom each object was created, modified and deleted.
Column names are case sensitive:

• KEY
  DTC
  CREATOR
  PREVDTD -- date/time deleted
  PREVDELETOR
  DTM (multi-valued)
  MODIFIER (multi-valued)
  REASON (multi-valued)

In addition there are two virtual columns for decomposing the KEY:

• CLASS (ennumerated, e.g. job sequence is class '22')
  INSTANCE

[Teej]

Does PX jobs utilize this DS_AUDIT table?

-T.J.

[kcbland]

Yup.