SQL report for computer count and patches completed and not
I saw a bunch of reports of how to make a list of servers and how to get data on each one whether they were patched or not. I was wondering if there is a way to make it one step high level. I was wondering if anybody has come across making a SQL report on the count of computers in a label and count or % of how they are patched as a whole group.
instead of seeing 30 servers i just wanted it to be like this
Total patches applied in the last 90 days
Total patches not applied in the last 90 days
Percentage of patches not applied in the last 90 days.
any help or insight would be awesome. I am not the best at SQL writing.
Please log in to answer
Be the first to answer this question