Overview

Advisories

Research

Forums

Create Profile

Our Commitment

All Threads

PSI

PSI API

CSI

OSI

xSI

Vulnerabilities

Programs

Open Discussions

My Threads

Create Thread

Statistics

About

Forum Thread: New CSI 5.0 feature - Custom SQL queries

You are currently viewing a forum thread in the Secunia Community Forum. Please note that opinions expressed here are not of Secunia but solely reflect those of the user who wrote it.

This thread was submitted in the following forum:
CSI

This thread has been marked as locked.

O.Marin	New CSI 5.0 feature - Custom SQL queries
	4th Aug, 2011 13:26
Ranking: 25 Posts: 113 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', CASE WHEN secure = 0 THEN 'Insecure' END AS 'State', 'SA' || vuln_id AS 'SAID', vuln_criticality AS Criticality, vuln_create_date AS 'SA Issued', vuln_count AS vulnerabilities FROM nsi_devices, nsi_device_software WHERE nsi_devices.nsi_device_id = nsi_device_software.nsi_device_id AND LENGTH(missing_ms_kb) > 0 ORDER BY product_name, missing_ms_kb 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. Oana Junior Solution Specialist Stay Secure -- Kind Regards, Oana Marin Solution Specialist

No one has replied to this thread yet - be the first
This thread has been marked as locked.