The supported database schema objects include entries in the following categories:
Identity Systems – system name, users, groups, other security principals
Windows File System – file system meta data, permissions
File Content Analysis Data – data related to discovery of search expressions over file content
Microsoft 365 Data – data related to drives, drive items and supporting meta data and permissions as well as basic teams and sites info in Microsoft 365
Although any tables, views, stored procedures and functions in the database can be accessed via custom queries, only the tables, views, and functions listed here are supported for use with Custom Query development.
IMPORTANT:Users who are new to SQL may find the supported views easier to start with as each view provides a simple presentation of several key tables. In addition, the current_* views are pre-filtered for only the most recent scan data.
More experienced users may find performance benefits from making direct inline queries against the tables themselves, especially for complex queries.