Table 1-1 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 current 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 |
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_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.site_drives |
List of discovered MS365 drives |
|
ms365.sites |
List of discovered MS365 SharePoint sites |
|
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 |