cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
566
Views
0
Helpful
1
Replies

How to get some auditing so we can see who's deleting jobs

chris.mathews1
Level 1
Level 1

We have some jobs that are being deleted by a user. But we have no idea who's doing it since we hvae more than 5oo users and most of them have admin rights. Is there any audutuing in place that shows us who's deleting jobs..

1 Reply 1

BTS OPERATIONS
Level 1
Level 1

You will need to query your Tidal Master(Admiral) database.  Here is how I write it in MSSQL:

select um.usrmst_name, ml.msglog_crtdt, ml.msglog_text
 from msglog ml join usrmst um on
 ml.usrmst_id = um.usrmst_id
 where left(msglog_text,11) = 'Deleted Job'

This shows you when the job was deleted.  The job name is in the text and gives you the username.

If the jobs are deleted at the parent level, you may not see the child jobs listed.