The supported database schema objects are divided into the following categories:
Identity Systems
Scan Info
File System Metadata
File System Permissions Data
Although any tables, views, stored procedures and functions in the database may be accessed via custom queries, only the tables, views and functions listed here are supported.
IMPORTANT:For users who are new to SQL, the supported views might be 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 latest Current scan data.
More experienced administrators however, will find that performance benefits can arise from making direct inline queries against the tables themselves, especially for complex scenarios.