srs.scan_history
|
Column Name |
SQL Server |
PostgreSQL |
Notes |
|---|---|---|---|
|
id |
integer |
integer |
Primary key |
|
identity_system |
nvarchar(256) |
text |
Identity system associated with this scan target |
|
scan_target |
nvarchar(1024) |
text |
UNC path of scan target |
|
file_size |
bigint |
bigint |
Total aggregate size of all files |
|
file_count |
integer |
integer |
Total count of all files |
|
directory_count |
integer |
integer |
Total count of all directories |
|
scan_policy_name |
nvarchar(64) |
varchar(64) |
Scan policy associated with this scan |
|
agent_name |
nvarchar(256) |
text |
|
|
scan_id |
integer |
integer |
Scan ID |
|
scan_type |
integer |
integer |
0 = None 1 = File System Data 2 = Permissions 4 = Volume Free Space |
|
triggered_start_time |
datetime2(3) |
timestamp |
Initial time scan delegation starts |
|
scan_start_time |
datetime2(3) |
timestamp |
Start time when agent begins physical scan |
|
scan_stop_time |
datetime2(3) |
timestamp |
Stop time when agent completes physical scan |
|
enum_start_time |
datetime2(3) |
timestamp |
Agent metrics related to file system object enumeration |
|
enum_stop_time |
datetime2(3) |
timestamp |
Agent metrics related to file system object enumeration |
|
enum_file_count |
integer |
integer |
Agent metrics related to file system object enumeration |
|
enum_directory_count |
integer |
integer |
Agent metrics related to file system object enumeration |
|
enum_link_count |
integer |
integer |
Agent metrics related to file system object enumeration |
|
caching_start_time |
datetime2(3) |
timestamp |
Metrics related to agent caching |
|
caching_stop_time |
datetime2(3) |
timestamp |
Metrics related to agent caching |
|
cached_file_count |
integer |
integer |
Metrics related to agent caching |
|
cached_directory_count |
integer |
integer |
Metrics related to agent caching |
|
cached_link_count |
integer |
integer |
Metrics related to agent caching |
|
cache_size |
integer |
integer |
Metrics related to agent caching |
|
cache_size_max |
integer |
integer |
Metrics related to agent caching |
|
metadata_start_time |
datetime2(3) |
timestamp |
Agent metrics related to filesystem metadata collection |
|
metadata_stop_time |
datetime2(3) |
timestamp |
Agent metrics related to filesystem metadata collection |
|
metadata_file_count |
integer |
integer |
Agent metrics related to filesystem metadata collection |
|
metadata_directory_count |
integer |
integer |
Agent metrics related to filesystem metadata collection |
|
metadata_link_count |
integer |
integer |
Agent metrics related to filesystem metadata collection |
|
accounts_start_time |
datetime2(3) |
timestamp |
Agent metrics related to security principal collection |
|
accounts_stop_time |
datetime2(3) |
timestamp |
Agent metrics related to security principal collection |
|
accounts_object_count |
integer |
integer |
Agent metrics related to security principal collection |
|
transfer_start_time |
datetime2(3) |
timestamp |
Related to transfer of scan file from the Agent to the Engine |
|
transfer_stop_time |
datetime2(3) |
timestamp |
Related to transfer of scan file from the Agent to the Engine |
|
db_start_time |
datetime2(3) |
timestamp |
Database insert start time |
|
db_stop_time |
datetime2(3) |
timestamp |
Database insert stop time |
|
status_code |
integer |
integer |
Internal status code |
|
error_string |
nvarchar(1024) |
varchar(1024) |
|