1.2 Supported Schema Objects

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 may 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.