03-08-2017 06:10 AM - edited 03-01-2019 09:25 AM
Hi All,
I am trying to find out what user ran a job on a specific day. I have the job number. From the client I can only tell who the runtime user was. After reading some of the similar discussions, am I correct in assuming I need to run a query on the Tidal Database?
Solved! Go to Solution.
03-08-2017 09:42 AM
'Audit Log' tab of inserted job run will show the run time user name and 'Status' tab will show the owner of that job. If this job is inserted by someone else like 'Super User' other than actual owner of that job, that user name will be shown in the Operations Log (Operations -> Logs) under User Name column with the message like "Your request to insert job <job_name> was processed successfully" . Please refer the attached screenshot.
03-08-2017 07:28 AM
If you know the specific job run involved, the Audit tab will show you manual activities taken by someone when you look at that specific job run.
03-08-2017 07:59 AM
The "User" on the Audit tab is listed as the runtime user. Would this mean someone ran this job on the command line as the runtime user and not via the agent?
EDIT: I double clicked on the individual lines, it gives me a user number and an agent number. It seems that if I run a job, it lists the user as the runtime user and not my username. I uploaded screenshots
03-08-2017 07:30 AM
If someone inserted the job into the schedule, the audit log tab for the job should tell you the ID of that person.
03-08-2017 09:42 AM
'Audit Log' tab of inserted job run will show the run time user name and 'Status' tab will show the owner of that job. If this job is inserted by someone else like 'Super User' other than actual owner of that job, that user name will be shown in the Operations Log (Operations -> Logs) under User Name column with the message like "Your request to insert job <job_name> was processed successfully" . Please refer the attached screenshot.
03-08-2017 09:55 AM
Thanks for the clarification! I don't have a "logs" option under operations. I'm going to check with my Sr. Admins to see if they have logging turned on
03-08-2017 10:34 AM
I didn't have rights to see logs. I contacted a sr. admin and we found the user using this method. Thanks!!!!!
03-08-2017 10:37 AM
Okay. Thanks for the update.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide