Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
forest_dns |
nvarchar(256) |
varchar(256) |
Forest DNS name |
domain_dns |
nvarchar(256) |
varchar(256) |
Domain DNS name |
domain_netbios |
nvarchar(15) |
varchar(15) |
Domain NetBIOS name |
id |
bigint |
bigint |
Primary key |
dn |
nvarchar(max) |
text |
Distinguished name |
db_domain_sid |
nvarchar(256) |
varchar(256) |
SID of the domain itself |
db_last_update |
datetime2(3) |
timestamp |
Last update time for this entry in the database |
account_expires |
datetime2(0) |
timestamp |
|
create_timestamp |
datetime2(0) |
timestamp |
|
department |
nvarchar(64) |
varchar(64) |
|
description |
nvarchar(1024) |
varchar(1024) |
Only uses first value of this multi-value attribute |
display_name |
nvarchar(256) |
varchar(256) |
|
dns_host_name |
nvarchar(2048) |
varchar(2048) |
Applies to Computer objects |
given_name |
nvarchar(64) |
varchar(64) |
|
group_type |
integer |
integer |
See https://docs.microsoft.com/en-us/windows/win32/adschema/a-grouptype for details.
0x10 - APP_BASIC group for Windows Server Authorization Manager 0x20 - APP_QUERY group for Windows Server Authorization Manager 0x80000000 - Security Group. If not set, then a Distribution Group |
last_logon_timestamp |
datetime2(0) |
timestamp |
NOTE: This attribute only has 14-day granularity. See: https://docs.microsoft.com/en-us/windows/win32/adschema/a-lastlogontimestamp |
|
nvarchar(256) |
varchar(256) |
|
managed_by_guid |
nvarchar(36) |
varchar(36) |
GUID of referenced DS object |
manager_guid |
nvarchar(36) |
varchar(36) |
GUID of referenced DS object |
object_category |
nvarchar(256) |
varchar(256) |
Using LDAP display name, not FDN. |
object_class |
nvarchar(256) |
varchar(256) |
Only includes structural class value from this multi-value attribute. |
object_guid |
nvarchar(36) |
varchar(36) |
Object's GUID |
object_sid |
nvarchar(256) |
varchar(256) |
Object's Security Identifier |
primary_group_sid |
varbinary(68) |
varchar(256) |
SID of referenced object |
sam_account_name |
nvarchar(256) |
varchar(256) |
SAM account name |
sam_account_type |
integer |
integer |
See https://docs.microsoft.com/en-us/windows/win32/adschema/a-samaccounttype for details.
|
sam_principal_name |
nvarchar(256) |
varchar(256) |
NetBIOS\SamAccountName. From msDS-PrincipalName. Note that the NetBIOS name here may be different from the associated domain NetBIOS name where this account was scanned. This is especially true for domain Builtin\* accounts and foreign security principals. |
surname |
nvarchar(64) |
varchar(64) |
|
title |
nvarchar(128) |
varchar(128) |
|
uac_flags |
integer |
integer |
|
upn |
nvarchar(1024) |
varchar(1024) |
User principal name |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp |
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\SamAccountName |
owner_id |
varbinary(68) |
bytea |
Security Identifier (SID) |
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 |
|
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
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 |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp |
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\SamAccountName |
owner_id |
varbinary(68) |
bytea |
Security Identifier (SID) |
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 |
|
Column |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
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 |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
Stored as UTC time |
modify_time |
datetime2(0) |
timestamp |
Stored as UTC time |
access_time |
datetime2(0) |
timestamp |
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\SamAccountName |
owner_id |
varbinary(68) |
bytea |
Security Identifier (SID) |
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 |
|
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |
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 |
Column Name |
SQL Server |
PostgreSQL |
Notes |
---|---|---|---|
id |
bigint |
bigint |
Primary key |
scan_id |
integer |
integer |
Reference to scans table |
identity_system |
nvarchar(256) |
varchar(256) |
Identity system name |
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 |