Script to View All Currently Running and Scheduled Jobs on Your Deployment Servers
Have you ever wanted to see all of the jobs that are currently running or are scheduled to run on each of your Deployment Servers? How about the status of key services and the last bootup time as well? That's what this hta script offers, all in one interface.
To get started, unzip the attached script. Open the DSConsoleStatus.hta file in notepad or your favorite script editor. Scroll down to about line 324 where it says "Enter list of servers below". You'll want to modify this list of servers to reflect your environment. Enter the names of your Deployment Servers. You may need to specify the SQL named instance, which is what I have specified in the first 2 example servers by using "DS1\sqlexpress", sqlexpress being the named instance on server DS1. After you get all of your servers in the list, then save the file and close it.
Double click the DSConsoleStatus.hta file and select the servers that you want to query from the list. Then hit query jobs to get a list of all of the currently running and scheduled jobs on all of those servers you selected. You can also query the health of servers by clicking Query Health instead of Query Jobs. This takes a lot longer to do, so be patient. It will query the status of the DS Data Manager service, the DS DB management server, express server service, and MS SQL service. It will also let you know the last time the server booted up.
You can automatically refresh your queries every 60 seconds by pressing the Start Refreshing button after performing either a job query or a health query. It will then auto refresh whichever query that you just made. To stop the auto refresh click Stop Refreshing.
| License: | AJSL By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License |
| Support: | User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab. |
Comments
Query "Job deployment status" in an excel file
I have adapted your script to create a query which give the status of one job in excel.
==== Excel Query template (jobname must be replaced) =================================
select
computer.name , event.name , event_schedule.status , event_schedule.status_code
from computer join event_schedule
on computer.computer_id = event_schedule.computer_id
join event
on event_schedule.event_id = event.event_id
where event.name like 'JobName'
=======================================
Then I can sort computers by status to restart deployment, fix the errors or send a readable report.
Thk for your contribution.
Christian
Seeing it!
Nice script!
For those of us that can't see as well as we used to, the Font Size can be adjusted on lines 264, 268, 284, and 288.
I changed "<Font Size=1>" to "<Font Size=3>" and it made a good size for me.
Would you like to reply?
Login or Register to post your comment.