It may be necessary to look up a patch based on its name.
- Is this patch in the LDMS content?
- I have a problem with this patch...
If provided with only the patch name, this document outlines how to find the Vulnerability ID that corresponds to it.
Vulnerabilities may utilize a unique ID that is different from the patches actual name:
Vulnerability - 2701664 Patch Name - lync-x64.3.msp
Solution / Workaround
The following query can be ran against the LDMS SQL Database to find a Vulnerability ID that corresponds to the Name of the patch.
SELECT Vulnerability.Vul_ID, Vulnerability.Guid, patch.UniqueFilename FROM Vulnerability INNER JOIN Patch ON Vulnerability.Vulnerability_Idn = patch.Vulnerability_Idn WHERE patch.Name LIKE '%PATCH_NAME%';