Issue: Summary Reports are Missing Content

Version 4

    Issue


    Summary Reports are empty, blank, or missing content.

     

    1-missinginfo.png

     

     

    Cause

     

    The tables utilized for these reports have no content available. This typically occurs when not using the System Task Listener with Data Analytics.

    See more info to learn more about the Summary Reports.

     

    Resolution

     

    Enable System Task Listener on the Core to gather data necessary data.

     

    Note: We recommend that you enable this service only when using the patch reports that need data. This service can significantly increase the size of your database and impact performance.

     

    • Click Tools | Data Analytics | Executive Report

     

    2-tools.png

     

     

    • On the toolbar, click Settings (Gear Icon)

     

    3-settings.png

     

     

    • On the Report Settings dialog, click the Task service tab.
    • From the drop-down list, select Yes or No to enable/disable the service.

     

    4-service.png

     

    More Info

     

    When generating a summary report, it opens in a browser with a url such as:

    http://96-core/remote/report/MP_SummaryReport.aspx?cr=94&idn=60

     

    • Core Name:  96-core
    • Machine ID: idn=60
      • This is listed in the machines inventory record as ID
    • Report ID: cr=94
      • This is pulled from the database table [MP_Report] column [MP_Report_Idn]
      • The table [MP_Report] column [Data] contains the xml and sql queries used to generate the report

    Example: ID=94 | Compliance Vulnerabilities Detected but not Patched

     

    <?xml version="1.0"?>
    <report>
        <Name value="Compliance Vulnerabilities Detected but not Patched" />
        <Description value="Compliance Vulnerabilities Detected but not Patched" />
        <URL value="Report_Wrapper_Frame.aspx?cr=[ID]" />
        <SampleURL value="" />
        <Product value="ERP" />
        <Type value="TEXT" />
        <SubGroup value="Patch" />
    
        <SubReport>
            <pageTitle value="Compliance Vulnerabilities Detected but not Patched"/>
            <reportTitle value="Compliance Vulnerabilities Detected but not Patched"/>
    
            <sort value="Computer.&quot;Device Name&quot;"/>
    
            <field value="Computer.&quot;Device Name&quot;"/>
            <field value="Computer.&quot;Detected Patch and Compliance Definitions&quot;.ID"/>
            <field value="Computer.&quot;Device Name&quot;"/>
            <field value="Computer.&quot;Device Name&quot;"/>
            <field value="Computer.&quot;Device Name&quot;"/>
            <field value="Computer.&quot;Device Name&quot;"/>
            <field value="Computer.&quot;Device Name&quot;"/>
            <field value="Computer.&quot;Device Name&quot;"/>
            <field value="Computer.&quot;Device Name&quot;"/>
    
            <columnHdr value="Device Name"/>
            <columnHdr value="Vulnerability"/>
            <columnHdr value="Title"/>
            <columnHdr value="Published Date"/>
            <columnHdr value="Severity"/>
            <columnHdr value="Vendor"/>
            <columnHdr value="Category"/>
            <columnHdr value="Compliance"/>
            <columnHdr value="Autofix"/>
    
            <fieldtype value="" mask="STRING" />
            <fieldtype value="" mask="STRING" />
            <fieldtype value="" mask="STRING" />
            <fieldtype value="" mask="DATE" />
            <fieldtype value="" mask="STRING" />
            <fieldtype value="" mask="STRING" />
            <fieldtype value="" mask="STRING" />
            <fieldtype value="" mask="INT" />
            <fieldtype value="" mask="INT" />
    
            <LSIAttrib value="Vulnerability.ID"/>
            <LSITable value="Vulnerability"/>
            <LSIColumn value="Vul_ID"/>
    
            <GroupBy value="Computer.&quot;Device Name&quot;" />
    
            <where value="SELECT DISTINCT A0.DEVICENAME, A1.VUL_ID, B.Title, B.PublishDate, CASE B.Severity WHEN '0' THEN 'Service Pack' WHEN '1' THEN 'Critical' WHEN '2' THEN 'High' WHEN '3' THEN 'Medium' WHEN '4' THEN 'Low' WHEN '5' THEN 'NA' END, B.Vendor, B.Category, B.Compliance, B.Autofix FROM Vulnerability B (nolock) , Computer A0 (nolock) LEFT OUTER JOIN MP_ComputerPatch A1 (nolock) ON A0.Computer_Idn = A1.Computer_Idn WHERE A1.DETECTED = 1 AND B.compliance = 1 AND B.Vul_ID = A1.Vul_ID AND B.Lang = A1.Lang ORDER BY  A0.DEVICENAME"/>
            <NODAL value="YES" />
            <ShowComputerText value="Show Patch Details"/>
        </SubReport>
    
    </report>
    
    
    

     

     

    A list of commonly affected Reports include:

    • Desktop Patch Counts
    • Laptop Patch Counts
    • Patch Dashboard
    • Patch Compliance Details
    • All Vulnerabilities Detected but not Patched Computer Summary
    • All 2008 Vulnerabilities Detected but not Patched
    • All 2009 Vulnerabilities Detected but not Patched
    • All 2010 Vulnerabilities Detected but not Patched
    • All 2011 Vulnerabilities Detected but not Patched
    • Autofix Vulnerabilities By Date Detected but not Patched
    • Autofix Vulnerabilities Detected but not Patched Computer Summary
    • Autofix Vulnerabilities Detected but not Patched
    • Compliance Vulnerabilities By Date Detected but not Patched
    • Compliance Vulnerabilities Detected but not Patched Computer Summary
    • Compliance Vulnerabilities Detected but not Patched
    • Critical And High Vulnerabilities Detected but not Patched Computer Summary
    • Critical And High Vulnerabilities By Date Detected but not Patched
    • Critical And High Vulnerabilities Detected but not Patched
    • Critical Vulnerabilities Detected but not Patched Computer Summary
    • Critical Vulnerabilities Detected but not Patched
    • High Vulnerabilities Detected but not Patched Computer Summary
    • High Vulnerabilities Detected but not Patched
    • All Vulnerabilities Detected but not Patched
    • All Vulnerabilities Detected but not Patched on Servers
    • All Vulnerabilities Detected but not Patched on Servers Ordered
    • Patch Status by Device
    • Patch Status by Device by Patch Type
    • Patch Status by Vulnerability
    • Server Patch Counts
    • SOX Report

     

    This document was generated from the following discussion: The specified item was not found.