DS Job History Query

RHopkins · 08-18-2008, 02:39 PM

I put together a DS job that would scan the Altiris services to make sure they were set correctly, and if not, then run a second job to log the services. Now I'm trying to do a SQL query that will scan each DS server and return a list of systems that ran the second job (that I can then export to Excel). My SQL skills are still pretty weak, so if anyone can help me out that would be great.

TRYDL · 08-18-2008, 07:37 PM

This should work, a little cheesy from a long time ago, but works well. You can see I pass in a variable of a job name in the WHERE clause. It can out of a VB script (I tried to cleanup the formatting before posting) and executed against a connection string.

I also pull out more information, then you may need.

Quote:

SELECT computer.name AS computerName, event_schedule.status AS status, event_schedule.start_time AS starting, event_schedule.end_time AS ending, event_schedule.exit_code AS exitcode, computer_group.name as mygroup FROM event_schedule INNER JOIN event ON event_schedule.event_id = event.event_id INNER JOIN computer ON event_schedule.computer_id = computer.computer_id INNER JOIN computer_group ON computer.group_id = computer_group.group_id WHERE (event.name = '%JobName%')

RHopkins · 08-22-2008, 05:06 PM

That did the trick, thanks!