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
Audit DS jobs
Moderators: chulett, rschirm, roy
The syntax is SQL, but there was a thread here earlier today which will answer your question.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
Try thisshrey3a wrote: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
SELECT * FROM DS_AUDIT WHERE DTM > '2006-01-14 00:00:00'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Minish,
regards
kcs
use CLASS ='2' to get only the status of the jobs.For Audit purpose I need to know the jobs changed for todays date.
I'm running the command
Code: Select all
SELECT * FROM DS_AUDIT WHERE DTM > '2006-02-01 00:00:00' AND CLASS = '2'
regards
kcs