SQL Query - Find Vulnerability ID by Patch Name or KB

Version 2

    Problem

     

    It may be necessary to look up a patch based on its name.

    Examples:

    • 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.

     

     

    Cause

     

    Vulnerabilities may utilize a unique ID that is different from the patches actual name:

    Example:

    Vulnerability - 2701664
    Patch Name - lync-x64.3.msp
    
    

     

    id not match name.png

    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%';
    
    

     

     

    Example:

    QUERY RESULTS.png