Table 3-16 Current File System Scan Data Unified View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
nvarchar(256) |
varchar(256) |
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_identity_system |
nvarchar(256) |
varchar(256) |
Owner’s Identity System name |
owner_domain |
nvarchar(256) |
varchar(256) |
Owner’s Active Directory domain |
owner_name |
nvarchar(256) |
varchar(256) |
|
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
|
owner_id |
varbinary(68) |
bytea |
|
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path. |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-17 Current File System Scan Data for Active Directory View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
|
|
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_identity_system |
nvarchar(256) |
varchar(256) |
Owner’s Identity System name |
owner_domain |
nvarchar(256) |
varchar(256) |
Owner’s Active Directory domain |
owner_name |
nvarchar(256) |
varchar(256) |
SAM Account Name |
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
DOMAIN\SAMAccount |
owner_id |
varbinary(68) |
bytea |
SID |
ad_object_id |
integer |
integer |
Reference to ad_objects table |
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-18 Current File System Scan Data for eDirectory View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
nvarchar(256) |
varchar(256) |
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_name |
nvarchar(256) |
varchar(256) |
Common Name (CN) |
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
Full distinguished object name |
owner_id |
varbinary(68) |
bytea |
GUID |
edir_object_id |
integer |
integer |
Reference to edir_objects table |
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-19 Current File System Scans View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
platform |
integer |
integer |
|
filesystem |
integer |
integer |
|
scan_type |
integer |
integer |
Should always be 1 |
progress_status |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
status_code |
integer |
integer |
|
ntfs_abe_enabled |
bit |
boolean |
Flag indicating that the Windows share has ABE enabled |
is_valid |
bit |
boolean |
[Deprecated] |
agent |
nvarchar(256) |
varchar(256) |
Name of agent that performed the scan |
file_count |
integer |
integer |
Number of files in the scan |
directory_count |
integer |
integer |
Number of directories in the scan |
link_count |
integer |
integer |
Number of links (junctions, symbolic links, reparse points) in the scan |
Table 3-20 Current NCP Trustees View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
trustee_name |
nvarchar(256) |
varchar(256) |
Common Name (CN) |
trustee_fdn |
nvarchar(512) |
varchar(512) |
Trustee’s full distinguished name |
trustee_display_name |
nvarchar(512) |
varchar(512) |
Trustee’s full distinguished name |
trustee_type |
integer |
integer |
|
trustee_guid |
varbinary(68) |
bytea |
GUID |
rights |
integer |
integer |
|
rights_string |
nvarchar(8) |
varchar(8) |
See srs.ncp_rights_string |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
edir_object_id |
integer |
integer |
Reference to edir_objects table |
Table 3-21 Current NTFS ACEs View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
trustee_identity_system |
nvarchar(256) |
varchar(256) |
Trustee’s Identity System name |
trustee_domain |
nvarchar(256) |
varchar(256) |
Trustee’s Active Directory domain |
trustee_name |
nvarchar(256) |
varchar(256) |
SAMAccount name |
trustee_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished name |
trustee_display_name |
nvarchar(max) |
text |
DOMAIN\SAMAccount |
trustee_type |
integer |
integer |
|
sid |
varbinary(68) |
bytea |
|
access_mask |
integer |
integer |
|
access_mask_string |
nvarchar(128) |
varchar(128) |
See srs.access_mask_string |
basic_permissions |
nvarchar(128) |
varchar(128) |
See srs.access_mask_basic_string |
ace_type |
smallint |
smallint |
|
ace_type_string |
nvarchar(128) |
varchar(128) |
See srs.ace_type_string |
ace_flags |
smallint |
|
|
ace_flags_string |
nvarchar(128) |
varchar(128) |
See srs.ace_flags_string |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
ad_object_id |
integer |
integer |
Reference to ad_objects table |
Table 3-22 Current Permissions Scans View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
platform |
smallint |
smallint |
|
filesystem |
smallint |
smallint |
|
scan_type |
integer |
integer |
Should always be 2 |
progress_status |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
status_code |
integer |
integer |
|
ntfs_abe_enabled |
bit |
boolean |
Flag indicating that the Windows share has ABE enabled |
is_valid |
bit |
boolean |
[Deprecated] |
agent |
nvarchar(256) |
varchar(256) |
Name of agent that performed the scan |
directory_count |
integer |
integer |
Number of directories in the scan |
Table 3-23 Previous File System Scan Data Unified View
Column Name |
SQL Server Data Type |
PostgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
nvarchar(256) |
varchar(256) |
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_identity_system |
nvarchar(256) |
varchar(256) |
Owner’s Identity System name |
owner_domain |
nvarchar(256) |
varchar(256) |
Owner’s Active Directory domain |
owner_name |
nvarchar(256) |
varchar(256) |
|
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
|
owner_id |
varbinary(68) |
bytea |
|
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-24 Previous File System Scan Data for Active Directory View
Column Name |
SQL Server Data Type |
PostgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
|
|
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_identity_system |
nvarchar(256) |
varchar(256) |
Owner’s Identity System name |
owner_domain |
nvarchar(256) |
varchar(256) |
Owner’s Active Directory domain |
owner_name |
nvarchar(256) |
varchar(256) |
SAM Account Name |
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
DOMAIN\SAMAccount |
owner_id |
varbinary(68) |
bytea |
SID |
ad_object_id |
integer |
integer |
Reference to ad_objects table |
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-25 Previous File System Scan Data for eDirectory View
Column Name |
SQL Server Data Type |
PostgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
nvarchar(256) |
varchar(256) |
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_name |
nvarchar(256) |
varchar(256) |
Common Name (CN) |
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
Full distinguished object name |
owner_id |
varbinary(68) |
bytea |
GUID |
edir_object_id |
integer |
integer |
Reference to edir_objects table |
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-26 Previous File System Scans View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
platform |
integer |
integer |
|
filesystem |
integer |
integer |
|
scan_type |
integer |
integer |
Should always be 1 |
progress_status |
integer |
integer |
|
identity_system_id |
integer |
integer |
|
scan_target_id |
integer |
integer |
|
status_code |
integer |
integer |
|
ntfs_abe_enabled |
bit |
boolean |
Flag indicating that the Windows share has ABE enabled |
agent |
nvarchar(256) |
varchar(256) |
Name of agent that performed the scan |
file_count |
integer |
integer |
Number of files in the scan |
directory_count |
integer |
integer |
Number of directories in the scan |
link_count |
integer |
integer |
Number of links (junctions, symbolic links, reparse points) in the scan |
Table 3-27 Previous NCP Trustees View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
trustee_name |
nvarchar(256) |
varchar(256) |
Common Name (CN) |
trustee_fdn |
nvarchar(512) |
varchar(512) |
Trustee’s full distinguished name |
trustee_display_name |
nvarchar(512) |
varchar(512) |
Trustee’s full distinguished name |
trustee_type |
integer |
integer |
|
trustee_guid |
varbinary(68) |
bytea |
GUID |
rights |
integer |
integer |
|
rights_string |
nvarchar(8) |
varchar(8) |
See srs.ncp_rights_string |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
edir_object_id |
integer |
integer |
Reference to edir_objects table |
Table 3-28 Previous NTFS ACEs View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
trustee_identity_system |
nvarchar(256) |
varchar(256) |
Trustee’s Identity System name |
trustee_domain |
nvarchar(256) |
varchar(256) |
Trustee’s Active Directory domain |
trustee_name |
nvarchar(256) |
varchar(256) |
SAMAccount name |
trustee_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished name |
trustee_display_name |
nvarchar(max) |
text |
DOMAIN\SAMAccount |
trustee_type |
integer |
integer |
|
sid |
varbinary(68) |
bytea |
|
access_mask |
integer |
integer |
|
access_mask_string |
nvarchar(128) |
varchar(128) |
See srs.access_mask_string |
basic_permissions |
nvarchar(128) |
varchar(128) |
See srs.access_mask_basic_string |
ace_type |
smallint |
smallint |
|
ace_type_string |
nvarchar(128) |
varchar(128) |
See srs.ace_type_string |
ace_flags |
smallint |
|
|
ace_flags_string |
nvarchar(128) |
varchar(128) |
See srs.ace_flags_string |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
ad_object_id |
integer |
integer |
Reference to ad_objects table |
Table 3-29 Previous Permissions Scans View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
platform |
smallint |
smallint |
|
filesystem |
smallint |
smallint |
|
scan_type |
integer |
integer |
Should always be 2 |
progress_status |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
status_code |
integer |
integer |
|
ntfs_abe_enabled |
bit |
boolean |
Flag indicating that the Windows share has ABE enabled |
agent |
nvarchar(256) |
varchar(256) |
Name of agent that performed the scan |
directory_count |
integer |
integer |
Number of directories in the scan |
Table 3-30 Baseline File System Scan Data Unified View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
nvarchar(256) |
varchar(256) |
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_identity_system |
nvarchar(256) |
varchar(256) |
Owner’s Identity System name |
owner_domain |
nvarchar(256) |
varchar(256) |
Owner’s Active Directory domain |
owner_name |
nvarchar(256) |
varchar(256) |
|
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
|
owner_id |
varbinary(68) |
bytea |
|
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-31 Baseline File System Scan Data for Active Directory View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
|
|
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_identity_system |
nvarchar(256) |
varchar(256) |
Owner’s Identity System name |
owner_domain |
nvarchar(256) |
varchar(256) |
Owner’s Active Directory domain |
owner_name |
nvarchar(256) |
varchar(256) |
SAM Account Name |
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
DOMAIN\SAMAccount |
owner_id |
varbinary(68) |
bytea |
SID |
ad_object_id |
integer |
integer |
Reference to ad_objects table |
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-32 Baseline File System Scan Data for eDirectory View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
name |
nvarchar(256) |
varchar(256) |
File or directory name |
filename_extension |
nvarchar(32) |
varchar(32) |
File name extension |
create_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp without time zone |
Stored as UTC time |
size |
bigint |
bigint |
For files, actual size; for directories, accumulative size of all subordinate files |
size_on_disk |
bigint |
bigint |
Assumes typical allocation unit size of 4K |
size_compressed |
bigint |
bigint |
Only accurate for NTFS file systems |
owner_name |
nvarchar(256) |
varchar(256) |
Common Name (CN) |
owner_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished object name |
owner_display_name |
nvarchar(max) |
text |
Full distinguished object name |
owner_id |
varbinary(68) |
bytea |
GUID |
edir_object_id |
integer |
integer |
Reference to edir_objects table |
attributes |
integer |
integer |
|
attribute_string |
nvarchar(256) |
varchar(256) |
See srs.attribute_string function |
fullpath_hash |
binary(20) |
bytea |
SHA-1 hash of lowercase fullpath |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
Table 3-33 Baseline File System Scans View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
platform |
integer |
integer |
|
filesystem |
integer |
integer |
|
scan_type |
integer |
integer |
Should always be 1 |
progress_status |
integer |
integer |
|
identity_system_id |
integer |
integer |
|
scan_target_id |
integer |
integer |
|
status_code |
integer |
integer |
|
ntfs_abe_enabled |
bit |
boolean |
Flag indicating that the Windows share has ABE enabled |
agent |
nvarchar(256) |
varchar(256) |
Name of agent that performed the scan |
file_count |
integer |
integer |
Number of files in the scan |
directory_count |
integer |
integer |
Number of directories in the scan |
link_count |
integer |
integer |
Number of links (junctions, symbolic links, reparse points) in the scan |
Table 3-34 Baseline NCP Trustees View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
trustee_name |
nvarchar(256) |
varchar(256) |
Common Name (CN) |
trustee_fdn |
nvarchar(512) |
varchar(512) |
Trustee’s full distinguished name |
trustee_display_name |
nvarchar(512) |
varchar(512) |
Trustee’s full distinguished name |
trustee_type |
integer |
integer |
|
trustee_guid |
varbinary(68) |
bytea |
GUID |
rights |
integer |
integer |
|
rights_string |
nvarchar(8) |
varchar(8) |
See srs.ncp_rights_string |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
edir_object_id |
integer |
integer |
Reference to edir_objects table |
Table 3-35 Baseline NTFS ACEs View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
fullpath |
nvarchar(max) |
text |
Full UNC path to the file system entry |
trustee_identity_system |
nvarchar(256) |
varchar(256) |
Trustee’s Identity System name |
trustee_domain |
nvarchar(256) |
varchar(256) |
Trustee’s Active Directory domain |
trustee_name |
nvarchar(256) |
varchar(256) |
SAMAccount name |
trustee_fdn |
nvarchar(512) |
varchar(512) |
Full distinguished name |
trustee_display_name |
nvarchar(max) |
text |
DOMAIN\SAMAccount |
trustee_type |
integer |
integer |
|
sid |
varbinary(68) |
bytea |
|
access_mask |
integer |
integer |
|
access_mask_string |
nvarchar(128) |
varchar(128) |
See srs.access_mask_string |
basic_permissions |
nvarchar(128) |
varchar(128) |
See srs.access_mask_basic_string |
ace_type |
smallint |
smallint |
|
ace_type_string |
nvarchar(128) |
varchar(128) |
See srs.ace_type_string |
ace_flags |
smallint |
|
|
ace_flags_string |
nvarchar(128) |
varchar(128) |
See srs.ace_flags_string |
idx |
integer |
integer |
Scan index; unique per scan |
parent_idx |
integer |
integer |
Parent index. Used for hierarchical relation processing |
path_depth |
integer |
integer |
Entry depth with respect to the scan target’s root path |
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 |
scan_id |
integer |
integer |
Reference to scans table |
scan_data_id |
bigint |
bigint |
Reference to scan_data table |
path_type |
integer |
integer |
|
status_code |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
ad_object_id |
integer |
integer |
Reference to ad_objects table |
Table 3-36 Baseline Permissions Scans View
Column Name |
SQL Server Data Type |
PosgreSQL Data Type |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
|
domain |
nvarchar(256) |
varchar(256) |
Active Directory domain |
server |
nvarchar(256) |
varchar(256) |
Server name |
scan_target |
nvarchar(256) |
varchar(256) |
UNC root path for scan target |
platform |
smallint |
smallint |
|
filesystem |
smallint |
smallint |
|
scan_type |
integer |
integer |
Should always be 2 |
progress_status |
integer |
integer |
|
identity_system_id |
integer |
integer |
Reference to identity_systems table |
scan_target_id |
integer |
integer |
Reference to scan_targets table |
status_code |
integer |
integer |
|
ntfs_abe_enabled |
bit |
boolean |
Flag indicating that the Windows share has ABE enabled |
agent |
nvarchar(256) |
varchar(256) |
Name of agent that performed the scan |
directory_count |
integer |
integer |
Number of directories in the scan |