Finding User who Changed Over Ride Dependencies

[Paul.Carl]

Is there a way to find out who it was that enabled override dependecies for a specific job?

[Derrick Au · Accepted solution]

Hi Paul,

The information you are looking for can be found within the msglog table, so try this query below:

SELECT jobmst.jobmst_prntname, jobmst.jobmst_name, msglog.* FROM msglog

JOIN jobmst ON jobmst.jobmst_id = msglog.jobmst_id

WHERE

msglog.msglog_text LIKE '%sent request to override%'

and msglog.msglog_crtdt >= getdate() - 7        -- this looks back the past 7 days

order by msglog.msglog_crtdt

BR,

Derrick Au

[Paul.Carl]

Thanks for the query. This gives me almost everything I need. Except the usrmst_id is always 0. At least I know when the dependencies were changed, and I can find them in the log, which does have userid's.

[Derrick Au]

Hi Paul,

The usrmst id shouldn't always be 0. But if you could test this by throwing additional fields (userid, user fullname) into this query:

SELECT jobmst.jobmst_prntname, jobmst.jobmst_name, usrmst.usrmst_name, usrmst.usrmst_fullname, msglog.* FROM msglog

JOIN jobmst ON jobmst.jobmst_id = msglog.jobmst_id

JOIN usrmst ON msglog.usrmst_id = usrmst.usrmst_id

WHERE

msglog.msglog_text LIKE '%sent request to override%' -- search using LIKE wildcard string wildcard

and msglog.msglog_crtdt >= getdate() - 7       -- this looks back the past 7 days

order by msglog.msglog_crtdt

BR,

Derrick Au

[Warren Tolentino]

thru the apps sometimes this help. use the Log on the left panel. this will open the Log Filter window. enter your info and click on the OK button. this will give us some of the jobs that were run or updated. you will have to open each one of the item from the list to see what changes/updates occurred in the job.

[Paul.Carl]

Thanks. This does work. I was wondering if I could get them all in a query for a job or date. Some of the jobs get run a lot.