Is it possible to extract custom made reports from Secunia CSI?
It is possible to pull custom data and reports from the local Secunia CSI database, containing the scan results generated by your Secunia CSI setup. The local database is in SQLite, you can download a free SQLite console from SQLite.org (or use your favourite sqlite tool). This allows you to connect to the actual database file and run queries directly against the results. After downloading the console, you need to locate the database file. The database file is placed in the %APPDATA%\Secunia CSI folder of the user running the CSI. The largest file with a random name in this folder should be your local database. The following scenario is just one example how to use the local database of Secunia CSI, but can of course be customised to meet other needs. First download and unzip the ‘sqlite’ console from sqlite.org If ‘sqlite3.exe’ is placed on your desktop, the following command should work on a Windows XP system.