Skip to main content

SQL Data Collector Schema

Overview​

This is a comprehensive schema documentation for the NAA 12.0 SQL Server Data Collector. The SQL Server Data Collector is a component of the NAA 12.0 platform that discovers, audits, and reports on SQL Server instances, databases, principals, permissions, audit events, and sensitive data across the enterprise.

Schema Categories​

The tables fall into two categories:

  1. Core Data Collection Tables (44 tables) — Normalized tables populated directly by data collectors. These contain raw audit data with full foreign key relationships. Includes shared infrastructure tables (SA_SQL_Instances, SA_SQL_Patches) used across all database collector modules.

  2. Reporting / Summary Tables (59 tables) — Denormalized, report-ready tables populated by analysis jobs. These use human-readable column names (e.g., "Instance", "Database", "Permission").

Core Data Collection Tables​

Reporting Tables​

Activity​

Authentication​

Control Server​

Database Principals​

Database Size​

Direct Permissions​

Domain User Permissions​

Effective Role Members​

Instance Summary​

Logons​

Password Issues​

Permission Changes​

Public Permissions​

Role Members​

Security Assessment​

Sensitive Data​

Sensitive Data Activity​

Sensitive Data Permissions​

Server Permissions​

Server Principals​

SysAdmins​

Unusual Activity​

User Logins​

Best Practices​

CMD Shell​

Linked Servers​

Views​

Enumeration & Lookup Values Reference​

Table Relationship Diagrams (ERD)​

Index Reference​

Scalar Functions & Stored Procedures​