Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
report_id |
integer |
integer |
Reference to primary key of associated srs.report_definitions entry |
scan_id |
integer |
integer |
Reference to primary key of associated srs.scans entry |
scan_type |
integer |
integer |
|
progress_status |
integer |
integer |
|
scan_start_time |
datetime3(2) |
timestamp |
Start time when agent begins physical scan |
scan_target_id |
integer |
integer |
Reference to primary key of associated srs.scan_targets entry |
target_path |
nvarchar(max) |
text |
Selected path for this report |
target_path_hash |
binary(20) |
bytea |
SHA-1 hash of normalized target path |
path_index |
integer |
integer |
Used for hierarchical relation processing |
ns_left |
integer |
integer |
Nested-set Left index – used for hierarchical relation processing |
ns_right |
integer |
integer |
Nested-set Right index – used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
path_type |
integer |
integer |
|
is_permission_scan |
bit |
boolean |
Flag indicating whether this entry is for a file system permissions scan Can be used in place of scan_type |
is_filesystem_scan |
bit |
boolean |
Flag indicating whether this entry is for a file system metadata scan Can be used in place of scan_type |
is_current |
bit |
boolean |
Flag indicating whether this entry is for the current scan Can be used in place of progress_status |
is_previous |
bit |
boolean |
Flag indicating whether this entry is for a previous scan Can be used in place of progress_status |
is_baseline |
bit |
boolean |
Flag indicating whether this entry is for a baseline scan Can be used in place of progress_status |