Signiant Support

How can I gather audit information about a specific job? Print


Question

I would like to know what the last few actions taken on a job were, as well as who made the last change.  How can I do this?
 

Discussion

If your manager is not running a large number of jobs, you can view the Web Logs audit log from the manager's GUI (Administration / Manager / Web Logs).
For managers running a large number of jobs, it may be difficult to find the information you need.  In this case you can try a SQL query.  On the manager, in the db/pgsql/bin subdirectory of the Signiant directory, run the following command:

psql DTM_DB -U postgres

This will bring you to a PSQL prompt.  At this prompt, enter a command similar to the following:

select wu.username,logged_on,log_desc,log_action from web_user wu,web_log wl where wu.web_user_id = wl.web_user_id and log_desc = 'Job Group = MyjobGroup; Job = MyJob' order by logged_on desc limit 10;

Where MyJobGroup is the name of the group where the job in question resides and MyJob is the job you are interested in.  This will list the last 10 actions taken on this job, as well as the user who performed the action and at what time the action was performed.

To find out who last edited the job parameters, enter a query similar to the following:

select wu.username,sj.changed_on,sj.job_name ,c.contract_name as job_group from web_user wu,scheduled_job sj,contract c where wu.web_user_id = sj.changed_by and c.contract_id = sj.contract_id and sj.job_name = 'MyJob' and contract_name = 'MyJobGroup';

Where MyJobGroup is the name of the group where the job in question resides and MyJob is the job you are interested in.   This will list the time of the last change as well as the user who made it.  Unfortunately, only the last edit of a job is stored.

Copyright © 2014 Signiant Inc, all rights reserved.