DS Reporting in NS (6-Pack of Reports)

As we all know, there is a fairly large lack of reporting related to DS, so I took some time and created a few NS reports that show me some useful DS information. I figured that they may be useful to others as well, so I am posting them here to share. Using these reports, I was able to see a much clearer picture of things.

Have you ever wondered how many computers still had pending jobs?

Have you ever wanted to email someone a list of computers that haven't run a job yet, but hate excessive amounts of typing for no reason?

Anyone ever ask you for a list of computers that successfully ran Job X, not just a count of them?

Now you can answer these without any effort, just simply run the report and email them the results, or better yet, tell them where the report is so that they don't have to annoy you next time.

I noticed the script that dallasr posted on Juice recently and took some SQL from there when I started this.

Reports:

1. Shows a listing of all DS jobs that are currently (actively) deploying.
2. Count of all computers with pending DS jobs. Right-click option will list the jobs pending for the selected computer.
3. List of scheduled DS jobs that have been scheduled for more than X amount of days, with 30 as the default.
4. List of all scheduled DS jobs, but you have the option of entering full/partial computer name and DS Job name to filter your results. The default is a full list of all scheduled DS jobs for all computers.
5. Like report #2, but this is for Completed jobs, rather than pending.
6. Like report #4, but this is for Completed Jobs, rather than pending.

It would also be very simple to tie in the Primary User from NS into these reports. These are straight exports from NS, so just import them and run them.

Thanks,
Jason