Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Creating an AdHoc Query for Update Computer Summaries

Hi,

I can view the current status of the installation state of a specific Update by selecting it from the Update Services/WSUS/Updates/xxx/Update....." tree and viewing the "Computer Summary" Tab. Example as a screenshot.

30-01-2015 08-10-05.png

Using this view I can view the most current data. Now I'm searching for a way to create an automatic report. I can get the informations from the WSUS Analytics Tree, but those reports use consolidated non live data collected by the WSUS Inventory Task. This task needs about 4 hours to run.

Any idea how to get such (near live) information in an automatic report? I could even live with a powershell script if it is not possible by using the reporting functions of patchmanager.

Find more posts tagged with

Accepted answers

All comments

LGarvin

This task needs about 4 hours to run.

Would you like to troubleshoot this four-hour runtime in this thread, or in the other one?

Reporting is how you get an "automatic report". It doesn't matter the methodology you use to extract the data in the database if you're only updating it once a week.

As a starting point, I notice that you have over 12,000 updates synchronized to the WSUS server, so reducing the number of updates is a good place to start.

The other consideration, of course, is looking at the system configuration of your WSUS server.

callidus

I would be happy to troubleshoot it within this thread.

This specific report was intended for getting a current report of the deployment (rate) of the current flash update.

LGarvin

I would be happy to troubleshoot it within this thread.

Great!

With respect to my observation of the >12,000 updates in your collection, I would suggest starting with these two tasks:

WSUS Timeout Errors - Too many updates

WSUS Timeout Errors - Removing unneeded update approvals

While I know you're not yet experiencing any timeout errors, you're likely pretty close to that threshold.

Once you've reduced the total number of updates, and the number of approved updates, to a manageable level, then you'll want to do:

WSUS Timeout Errors - Defragment the filesystem

WSUS Timeout Errors - WSUS database maintenance

And the combination of all of the above should significantly reduce the runtime of your WSUS Inventory task.

(Also, just as a side note, double-check that your Inventory task is not conflicting with any other heavy network-usage type tasks, like backups or database ETLs)

LGarvin

This specific report was intended for getting a current report of the deployment (rate) of the current flash update.

The simplest way to achieve this is to use the report Approved Summary with percentages which is available in the "Windows Server Update Services" report collection.

Filter the report by Update Title to get the Flash update of interest.

callidus

Thanks.

Followed all 4 guides, but my Cleanup Task (just selected the first option) runs into a timeout (after only 3 minutes).

[Had blindly thought that the sheduled task mail within PM would indicate a problem...]