Audit DS jobs

[shrey3a]

Hi,

For Audit purpose I need to know the jobs changed for todays date.

I'm running the command

SELECT DTM, MODFIFIER FROM DS_AUDITS
0r

SELECT * FROM DS_AUDITS
or

SELECT MODIFIER, DTM
FROM UNNEST DS_AUDIT ON MODS

but it gives me name of all the jobs been modified I need to add the where clause for todays date and I'm not sure of the syntax.


-Thanks
Munish

[ArndW]

The syntax is SQL, but there was a thread here earlier today which will answer your question.

[shrey3a]

Hi ,

IS there is any DS component in DS_AUDIT for mod date as I want to select all the jobs modifief for today only like

SELECT MODIFIER, DTM FROM DS_AUDIT WHERE DS_JOBS.MODIFIED_ON >= 2004-10-04 00:00:00

the above SQL do not work for where clause.

Thanks
- Munish

[vcannadevula]

Hi ,

IS there is any DS component in DS_AUDIT for mod date as I want to select all the jobs modifief for today only like

SELECT MODIFIER, DTM FROM DS_AUDIT WHERE DS_JOBS.MODIFIED_ON >= 2004-10-04 00:00:00

the above SQL do not work for where clause.

Thanks
- Munish

Try this

SELECT * FROM DS_AUDIT WHERE DTM > '2006-01-14 00:00:00'

[kduke]

Code: Select all

SELECT * FROM DS_AUDIT WHERE DTM > EVAL "OCONV(@DATE-1, 'D/MDY[2,2,4]')"

[ray.wurlod]

I thought the column name was DTM, not MODIFIED_ON. There is no SQL - anywhere - that allows you to query successfully with made-up column names.

[kcshankar]

Hi Minish,

For Audit purpose I need to know the jobs changed for todays date.

I'm running the command

use CLASS ='2' to get only the status of the jobs.

Code: Select all

SELECT * FROM DS_AUDIT WHERE DTM > '2006-02-01 00:00:00' AND CLASS = '2'

regards
kcs