How to Generate Reports of your WSUS Server and other Managed Computers?

In a network, ensuring that your systems are up to date and free of any security vulnerabilities takes top priority. With the pace the internet is evolving and developing, the amount of security risks in a network are bound to increase. This is because of the great increase in the cyber world which leads to new exploits being discovered almost daily. That is why, having a secure network is something every network or system administrator prioritizes.

To do this, of course, you will have to deploy updates that are released by Microsoft to ensure your system has all the needed security updates. As the number of computers in a network increases, managing all of this becomes more difficult. However, fortunately, the tasks of a network administrator are way easier than what it used to be. This is because of the tools that have been developed by several tech companies that make the daily networking way easier. Patch Manager is no exception to this and is something that every network administrator needs to deploy in their network. Patch Management software enables you to automate the process of deploying updates to your computers by scheduling the task to run at a specified time period.

Solarwinds Patch Manager

Doing all of this manually in this modern world is a nightmare to say the least considering the sheer amount of devices that are now present in a network. Long story short, networks are now way more complex than they used to be and therefore, sysadmins have to adhere to the requirements of the modern world. When you deploy updates to a list of computers, it is important that you also generate a report of the said task so that you are aware of your updates deployment. This helps in better managing the network overall.

Downloading Solarwinds Patch Manager

From the long list of patch management software available on the internet, choosing the right one might give newcomers a tough time. This is exactly why, we have a best of article available that lists the best solutions available which you can find above. The software that tops the list is developed by none other than Solarwinds, a company known for their products in the network and system management field. Solarwinds Patch Manager (download here) is a software that makes updates deployment way easier and automatic for your computers than it is along with many more features.

Patch Manager also comes with a Vulnerability Management system which scans your computers for any flaws as well as reports any critical updates that are missing from your machines. Other than that, there is a reporting functionality as well which helps you report all the deployed updates as well as stores additional details about your systems and the WSUS server so you can keep an eye on the scheduled deployments.

We will be using the Solarwinds Patch Manager in this guide for the extended functionalities that it offers, so go ahead and download the tool from the link provided. Once you have downloaded the tool, extract the .zip file to any location and then run the installer. During the installation, you will be asked to install the administrator console and the Patch Manager server components. For this, we recommend you install the administrator console only on the systems that you access easily so that you can manage the other computers easily. For the server components, they are to be installed on every computer that you wish to use the Patch Manager on.

Creating a Custom Report

With the help of Patch Manager, you can create your own custom reports along with the pre-defined reports that come in the software. This can be done via the Report Definition Builder feature that comes with the Solarwinds Patch Manager. Using Report Definition Builder, you can create a custom report which includes whatever information you want to include along with any filters that you might want to apply. To create a custom WSUS report, do the following:

  1. First of all, open up the Patch Manager Administrator Console.
  2. After that, in the navigation menu, expand the Administration and Reporting category and then make your way to Reporting > WSUS Reports.
  3. Choose any fitting directory and then in the Actions pane, click on the New Report option. This will take you to the Report Definition Builder.
    Creating New Report
  4. Now, you will have to select the fields that you wish to include in the report. If you wish to add any more fields, click on the + icon provided. You can change the order of the fields as well if you wish to.
  5. After that, apply any filters that you want to your report. Once done, click on the Next button.
  6. Now, give your report a name and specify any scheduling values. Other than that, you can also change the export options along with the email settings where you will be notified.
    Report Options
  7. Finally, once you are done with everything, click the Finish button.

Generating a Report

Now that you know how to create custom reports, you can generate them to get the details. For this, you will have to use the Run Report option found in the Actions pane. Once you run a report, it will open up in the Report Window where you can go through multiple reports at once and not worry about closing the window again and again just to view another report. You will still have to use the Run Report option for every report you wish to generate though. To generate a WSUS report, follow the below instructions:

  1. In the navigation menu, make your way to Administration and Reporting category and then go to Reporting > WSUS Reports.
  2. From there, choose a directory where lies the report you wish to generate.
  3. After that, locate the report from the list of created reports and then select it.
  4. Once you have selected the report, click on the Run Report option on the left-hand side in the Actions pane.
    Generating Report
  5. This will open up the Report Window with the report details. It might take a while so make sure to wait for it a bit.
ABOUT THE AUTHOR

Kamil Anwar


Kamil is a certified MCITP, CCNA (W), CCNA (S) and a former British Computer Society Member with over 9 years of experience Configuring, Deploying and Managing Switches, Firewalls and Domain Controllers also an old-school still active on FreeNode.