1 of 1 people found this helpful
So kind of a loaded question, and the term "patches" is very open ended. Are you referring to Microsoft Patches, Application Patches, etc... Ones that were installed by Patch Manager or all updates?
If you are are just worrying about Microsoft updates in 9.0 then OS. Updates.Update
Patch and Compliance Definitions branch will show all vulns installed
Detected Patch and Compliance Defintions shows all vulns that are detected.
8.8 all located under Security and Patch definitions.
What version are you running. There are alos some Security reports that may help. What specifically do you want to show?
The problem is that a LDMS 9 SP2 query is not bringing back all of the MS patches applied on a particular server.
Running gather patch historical information did not help.
Wrote some SQL to find the patch history information, this is good enough for now.
Thanks for your help
Might want to post the SQL here it may help others. Also if you are ok please close the discussion.
What were you missing and where did you find it in the database? Frank - Axle-IT
The LD queries did not return all of the results.
I have attached a powershell script which displays/ writes to a file all hotfixes
applied to the input server greater than the input date. This is a lot easier
than writing SQL for the LDMS tables.
get-patch.ps1.zip 601 bytes