This article provides an attached PDF document that gives a detailed overview and description of the ScanResults database stored in SQL. It also provides further insight into the queries found in the logs, reporting functionality, or confirmation of scan information via the database. This will aid you in writing your own queries to gather information from the database directly rather than the Default Reports bundled within LanGuard and the Central Management Server.
The product’s security scanner results, deployment results, computer information, agent information, etc. are stored in a database. The scan data may be stored in an MS SQL Server database or an MS SQL Express database as detailed in Versions of Microsoft SQL Server Supported by GFI Software Products.
The database to use (MSSQL server instance, MSSQL DB name) can be set or changed during the installation wizard, or in the product, from Database Maintenance Options.
- We use the same database structure for the Agent, Main Console, or Central Management Server.
The database is used for multiple reasons:
- The communication between operational modules (modules that gather data: opened ports, list of users, etc.) and the user interface is made through the database. This is necessary considering the large amount of data that the operational modules may gather during scans performed on a large number of machines.
- The saved scan data can be used to create reports at a later time.
- Configurations and overviews (which are per computer or computer group).