...
Custom SQL to get concise and detailed host vulnerability data in CSI local database console (accessible from Menu -> Administration -> Secunia CSI API -> Local Database Console):
SELECT host as Host, langroup as 'Group', no_score as 'Score %', product_name as Program, version as Version, secure_version as 'Secure Version', vuln_title as 'Vulnerability', path as Path, CASE WHEN eol > 0 THEN 'End-of-Life' ELSE (CASE WHEN secure = 0 THEN 'Insecure' ELSE 'Patched' END) END as 'State', CASE WHEN vuln_criticality <= 1 THEN 'Extreme' ELSE (CASE WHEN vuln_criticality <= 2 THEN 'High' ELSE (CASE WHEN vuln_criticality <= 4 THEN 'Medium' ELSE 'Low' END) END) END as Criticality, updated as 'Last Scan', missing_ms_kb as 'Missing MS KB' FROM nsi_devices d, nsi_device_software ds WHERE d.nsi_device_id = ds.nsi_device_id and secure = 0 ORDER BY host, product_name, path; |
|---|