1.5 Supported Database Views

Table 1-3 Supported Database Views

Category

View Name

Notes

Scan Info

srs.current_fs_scans

List of Current file system scans

 

srs.current_permissions_scans

List of Current permissions scans

 

srs.previous_fs_scans

List of Previous file system scans

 

srs.previous_permissions_scans

List of Previous permissions scans

 

srs.baseline_fs_scans

List of Baseline file system scans

 

srs.baseline_permissions_scans

List of Baseline permissions scans

File System Metadata

srs.current_fs_scandata_ad

All file system scan data from Current scans in Active Directory environments

 

srs.current_fs_scandata_edir

All file system scan data from Current scans in eDirectory environments

 

srs.current_fs_scandata

Combined list of all Current file system scan data

 

srs.previous_fs_scandata_ad

All file system scan data from Previous scans in Active Directory environments

 

srs.previous_fs_scandata_edir

All file system scan data from Previous scans in eDirectory environments

 

srs.previous_fs_scandata

Combined list of all Previous file system scan data

 

srs.baseline_fs_scandata_ad

All file system scan data from Baseline scans in Active Directory environments

 

srs.baseline_fs_scandata_edir

All file system scan data from Baseline scans in eDirectory environments

 

srs.baseline_fs_scandata

Combined list of all Baseline file system scan data

File System Permissions Data

srs.current_ncp_trustees

All Current permissions scan data in eDirectory environments

 

srs.current_ntfs_aces

All Current permissions scan data in Active Directory environments

 

srs.previous_ncp_trustees

All Previous permissions scan data in eDirectory environments

 

srs.previous_ntfs_aces

All Previous permissions scan data in Active Directory environments

 

srs.baseline_ncp_trustees

All Baseline permissions scan data in eDirectory environments

 

srs.baseline_ntfs_aces

All Baseline permissions scan data in Active Directory environments

IMPORTANT:The generalized view srs.current_fs_scandata is a combination of the srs.current_fs_scandata_edir and srs.current_fs_scandata_ad views. This view is provided as a convenience, but its use might be significantly slower in some cases as opposed to getting the results on the more specific *_ad and *_edir views.

The same applies to the views srs.previous_fs_scandata and srs.baseline_fs_scandata.