I need to create a report to count the number of critical and security patches are needed for servers only. I created a report, but only a very small portion of my servers showed up and I know there are several that are not patched.
I need to create a report to count the number of critical and security patches are needed for servers only. I created a report, but only a very small portion of my servers showed up and I know there are several that are not patched.
Knowing how you defined the report would help in assisting you to troubleshoot the report, but I think the easiest way to get a report showing number of Critical Updates and Security Updates needed by machine type {Server | Workstation | Domain Controller } is to do the following:
Once you're there, and are satisfied that the report is returning the correct raw data necessary to do the count() aggregation, you can now apply the count functionality:
The report should now show you one line for each computer/update classification title { Critical Updates; Security Updates }.
If you want a composite count for both classifications, simply delete the "Update Classification Title" column, which will then aggregate by Computer Name only, rather than Computer Name + Update Classification Title.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.