Sophos NAC Advanced: overview of SQL Views
Sophos NAC collects data for the reports available for viewing using the Sophos NAC Web interface. The Report Extraction Guide provides a documented set of SQL Views written against the Sophos NAC SQL databases.
Sophos has defined 18 SQL Views that provide enforcement, compliance, and Agent reporting data. The data retrieved using SQL Views comes from the Sophos NAC Report Warehouse, a database that contains only archived report data. By default, data is archived to the Report Warehouse every 24 hours at 2:30 A.M.; however, you can configure the frequency and the time that data is archived.
For more information about report settings, see the Sophos NAC Installation Guide.
If you need more information or guidance, then please contact technical support.
- Article ID: 24699
- Created: 19 Apr 2007
- Last updated: 18 Jan 2008
