I'm reviewing the PDF for all of the custom reporting and am taking a look to see what would apply to me. I'm not a SQL genius though, so anything input would be great!
At my company we have many controls that need to be run to verify information for auditors. We need to make sure each computer is scanned every 6 months. Here is the report we need:
Machine name of all computers in inventory
The date they were last scanned
The status of each computer if they need patches. This should be able to be missing patch count.
Our goal is to have the date of each computer scanned, and for missing patch count to display 0 so that the computers don't need any missing patches. If patches are missing and can't be patched, we need to explain why.
Sorry, we don't have a script written for this specific report. The way this usually works is a customer attempts to create the reports, Support with then chime in with our thoughts on changes needed. We can also answer specific questions you have on the script you are working on.