The default NCM Firmware Vulnerabilities widget seems to be showing all vulnerabilities even the ones that I've marked as non-applicable. I was showing a total of 10,031 total vulnerabilities on the widget with 3928 as high, 3348 as medium, and 2755 as low. When I went through my list of vulnerabilities and cleared out a bunch affecting multiple nodes as non-applicable the numbers never change. How can I can the SWQL to filter out entries I have deemed don't affect me?
SELECT 'High' as Severity, '#dd2c00' as Color, COUNT (1) as theCount, '/Orion/Report.aspx?Report=Vulnerabilities+for+each+Node' as Link
FROM NCM.VulnerabilitiesAnnouncements as Announcements
JOIN NCM.VulnerabilitiesAnnouncementsNodes as Nodes
ON Announcements.EntryId= NODES.EntryId
WHERE Announcements.Score >= 7.0
UNION ALL
(SELECT 'Medium' as Severity, '#fec406' as Color, COUNT (1) as theCount, '/Orion/Report.aspx?Report=Vulnerabilities+for+each+Node' as Link
FROM NCM.VulnerabilitiesAnnouncements as Announcements
JOIN NCM.VulnerabilitiesAnnouncementsNodes as Nodes
ON Announcements.EntryId= NODES.EntryId
WHERE Announcements.Score >= 4.0 AND Announcements.Score < 7.0)
UNION ALL
(SELECT 'Low' as Severity, '#1d8fb2' as Color, COUNT (1) as theCount, '/Orion/Report.aspx?Report=Vulnerabilities+for+each+Node' as Link
FROM NCM.VulnerabilitiesAnnouncements as Announcements
JOIN NCM.VulnerabilitiesAnnouncementsNodes as Nodes
ON Announcements.EntryId= NODES.EntryId
WHERE Announcements.Score < 4.0 )
