Table 2-2 Supported Database Tables
|
Category |
Table Name |
Notes |
|---|---|---|
|
Windows File System |
srs.identity_systems |
List of all identity systems. |
|
srs.ad_objects |
List of all scanned Active Directory security principals |
|
srs.ad_memberships |
Active Directory group memberships |
|
srs.scan_targets |
List of all configured scan targets (volumes, shares, etc.) |
|
|
srs.scans |
List of all available scans |
|
srs.scan_history |
Historical scan summary records |
|
srs.scan_data |
All scan data – includes all path and file-specific metadata info |
|
|
srs.scan_directory_data |
All directory-specific scan data |
|
srs.trend_volume_freespace |
List of all volume free space records |
|
srs.ntfs_aces |
Scanned NTFS ACEs |
|
srs.security_descriptors |
Scanned NTFS security descriptors |
|
Active Directory |
ad.domain |
List of scanned Active Directory domains in the forest |
|
ad.ds_objects |
List of scanned security principals in the Active Directory forest |
|
File Content Analysis |
analysis.file_scan_entries |
Summary classification data for file content analysis entries |
|
Microsoft 365 |
ms365.drive_items |
Files and folders in drives, document libraries |
|
ms365.drive_item_types |
Enumeration table of drive item types |
|
ms365.drive_scans |
List of scans against MS365 drives |
|
ms365.drive_scans_history |
Historical summary of drive scans |
|
ms365.drives |
List of MS365 drives (document libraries, OneDrive for Business drives) |
|
ms365.group_drives |
Mapping of MS365 groups (teams) to associated drives |
|
ms365.group_member_types |
Enumeration table of group member types |
|
ms365.group_members |
MS365 group membership associations |
|
ms365.group_owners |
MS365 group owner associations |
|
ms365.group_sites |
Mapping of MS365 groups (teams) to associated sites |
|
ms365.groups |
List of discovered MS365 groups |
|
ms365.identity_types |
Enumeration table of identity types |
|
ms365.jobs |
List of jobs to enumerate MS365 tenant objects (teams, sites, groups, users, drives, etc.) |
|
ms365.jobs_history |
Historical summary of tenant scans |
|
ms365.permissions |
Sharing links and direct access permissions for drive items |
|
ms365.sharing_link_members |
List of security principals associated with a specific sharing link |
|
ms365.sites |
List of discovered MS365 SharePoint sites |
|
ms365.sp_base_permissions |
Lookup table for SharePoint permission levels / roles. |
|
ms365.sp_group_members |
SharePoint group member associations |
|
ms365.sp_groups |
List of SharePoint groups |
|
ms365.sp_permission_levels |
List of SharePoint permission levels / roles |
|
ms365.sp_permissions |
List of SharePoint permissions (assigned permission levels) |
|
ms365.sp_site_permissions |
List of SharePoint site permissions |
|
ms365.sp_users |
List of SharePoint users |
|
ms365.team_channels |
List of discovered Teams Channels |
|
ms365.teams |
List of discovered MS365 Teams |
|
ms365.tenants |
Configured MS365 tenants for scan |
|
ms365.user_drives |
Mapping of MS365 users to drives (OneDrive for Business drives) |
|
ms365.users |
List of discovered MS365 users |
|
Session Specific |
tmp_cq_fs_paths |
Temporary table injected into custom query sessions for report-defined target paths |