|O.Marin||New CSI 5.0 feature - Custom SQL queries|
|4th Aug, 2011 13:26|
User Since: 4th Aug, 2011
System Score: N/A
Location: Copenhagen, DK
Last edited on 8th Aug, 2011 12:03
Hi Secunia CSI Community,
This is a thread for all of you who are excited with the new CSI Local Database Console feature now available in the Secunia CSI 5.0 The Local Database Console allows you to run SQL queries against the local database.
You can easily access all the information that is currently stored in the local database of the Secunia CSI and use it in many different ways, such as creating custom reports or feeding it into other applications.
Let's say you would like to extract a list with the missing Microsoft KBs that were detected by the Secunia CSI.
This can be easily done if you run the bellow query in the Local Database Console:
SELECT host AS Host,
langroup AS Site,
product_name AS Program,
version AS Version,
missing_ms_kb AS 'Missing KB',
WHEN secure = 0
END AS 'State',
|| vuln_id AS 'SAID',
vuln_criticality AS Criticality,
vuln_create_date AS 'SA Issued',
vuln_count AS vulnerabilities
WHERE nsi_devices.nsi_device_id = nsi_device_software.nsi_device_id
AND LENGTH(missing_ms_kb) > 0
ORDER BY product_name,
Once you have executed the query, you can export the output into a file so it's easy to process the information or share it.
We invite all Community members to participate in this thread, either with questions or by sharing your SQL queries.
Junior Solution Specialist
Not a customer already?