3.2 Views

3.2.1 SRS.CURRENT_FS_SCANDATA

Table 3-13 Current File System Scan Data Unified View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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 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\SamAccountName

owner_id

varbinary(68)

bytea

Security Identifier (SID)

attributes

integer

integer
  • 0x0 = None
  • 0x1 = Read Only
  • 0x2 = Archive
  • 0x4 = System
  • 0x8 = Hidden
  • 0x10 = Directory
  • 0x20 = Compressed
  • 0x40 = Offline
  • 0x80 = NTFS device
  • 0x100 = NTFS Normal
  • 0x200 = NTFS Temporary
  • 0x400 = NTFS Sparse File
  • 0x800 = NTFS Reparse Point
  • 0x1000 = NTFS Not content indexed
  • 0x2000 = NTFS Encrypted
  • 0x4000 = NTFS Virtual

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
  • 0 = Unknown
  • 1 = File
  • 2 = Directory
  • 3 = File Symbolic Link
  • 4 = Directory Symbolic Link
  • 5 = Junction
  • 6 = Mount Point
  • 7 = Share
  • 8 = Volume
  • 9 = DFS Link
  • 10 = DFS Folder
  • 11 = DFS Root
  • 12 = HSM Stub
  • 13 = Reparse Point Unknown
  • 17 = Single Instance Storage Stub
  • 18 = Named Stream

status_code

integer

integer

 

3.2.2 SRS.CURRENT_FS_SCANS

Table 3-14 Current File System Scans View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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
  • 0 = Unknown
  • 1 = Windows

filesystem

integer

integer
  • 0 = Unknown
  • 1 = NTFS

scan_type

integer

integer

Should always be 1

progress_status

integer

integer
  • -2 = Waiting for retry
  • -1 = Ready for cleanup
  • 0 = Waiting for delegation
  • 1 = Delegated / scan in progress
  • 2 = Scan file transfer in progress
  • 3 = Database update in progress
  • 4 = Current - scan process complete
  • 5 = Database update pending
  • 6 = Previous
  • 7 = Retained

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

3.2.3 SRS.CURRENT_NTFS_ACES

Table 3-15 Current NTFS ACEs View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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
  • 0 = Unknown / Other
  • 1 = User
  • 2 = Group
  • 3 = Computer

sid

varbinary(68)

bytea

 

access_mask

integer

integer
  • 0x1 = Read Data / List Directory
  • 0x2 = Write Data / Create File
  • 0x4 = Append Data / Create Subdirectory
  • 0x8 = Read Extended Attributes
  • 0x10 = Write Extended Attributes
  • 0x20 = File Execute / Traverse
  • 0x40 = Delete Child
  • 0x80 = Read Attributes
  • 0x100 = Write Attributes
  • 0x10000 = Delete
  • 0x20000 = Read Permissions
  • 0x40000 = Change Permissions
  • 0x80000 = Change Owner
  • 0x100000 = Synchronize
  • 0x1000000 = Access System Security
  • 0x10000000 = Generic All
  • 0x20000000 = Generic Execute
  • 0x40000000 = Generic Write
  • 0x80000000 = Generic Read

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
  • 0 = Access Allowed
  • 1 = Access Denied
  • 2 = System Audit
  • 9 = Allowed Callback
  • 10 = Denied Callback
  • 13 = System Audit Callback
  • 17 = System Mandatory Label

ace_type_string

nvarchar(128)

varchar(128)

See srs.ace_type_string

ace_flags

smallint

 
  • 0x1 = Object Inherit
  • 0x2 = Container Inherit
  • 0x4 = No Propagate
  • 0x8 = Inherit Only
  • 0x10 = Inherited
  • 0x40 = Successful Access
  • 0x80 = Failed Access

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
  • 0 = Unknown
  • 1 = File
  • 2 = Directory
  • 3 = File Symbolic Link
  • 4 = Directory Symbolic Link
  • 5 = Junction
  • 6 = Mount Point
  • 7 = Share
  • 8 = Volume
  • 9 = DFS Link
  • 10 = DFS Folder
  • 11 = DFS Root
  • 12 = HSM Stub
  • 13 = Reparse Point Unknown
  • 17 = Single Instance Storage Stub
  • 18 = Named Stream

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

3.2.4 SRS.CURRENT_PERMISSIONS_SCANS

Table 3-16 Current Permissions Scans View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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
  • 0 = Unknown
  • 1 = Windows

filesystem

smallint

smallint
  • 0 = Unknown
  • 1 = NTFS

scan_type

integer

integer

Should always be 2

progress_status

integer

integer
  • -2 = Waiting for retry
  • -1 = Ready for cleanup
  • 0 = Waiting for delegation
  • 1 = Delegated / scan in progress
  • 2 = Scan file transfer in progress
  • 3 = Database update in progress
  • 4 = Current - scan process complete
  • 5 = Database update pending
  • 6 = Previous
  • 7 = Retained

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

3.2.5 SRS.PREVIOUS_FS_SCANDATA

Table 3-17 Previous File System Scan Data Unified View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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 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\SamAccountName

owner_id

varbinary(68)

bytea
  • Security Identifier (SID)

attributes

integer

integer
  • 0x0 = None
  • 0x1 = Read Only
  • 0x2 = Archive
  • 0x4 = System
  • 0x8 = Hidden
  • 0x10 = Directory
  • 0x20 = Compressed
  • 0x40 = Offline
  • 0x80 = NTFS device
  • 0x100 = NTFS Normal
  • 0x200 = NTFS Temporary
  • 0x400 = NTFS Sparse File
  • 0x800 = NTFS Reparse Point
  • 0x1000 = NTFS Not content indexed
  • 0x2000 = NTFS Encrypted
  • 0x4000 = NTFS Virtual

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
  • 0 = Unknown
  • 1 = File
  • 2 = Directory
  • 3 = File Symbolic Link
  • 4 = Directory Symbolic Link
  • 5 = Junction
  • 6 = Mount Point
  • 7 = Share
  • 8 = Volume
  • 9 = DFS Link
  • 10 = DFS Folder
  • 11 = DFS Root
  • 12 = HSM Stub
  • 13 = Reparse Point Unknown
  • 17 = Single Instance Storage Stub
  • 18 = Named Stream

status_code

integer

integer

 

3.2.6 SRS.PREVIOUS_FS_SCANS

Table 3-18 Previous File System Scans View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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
  • 0 = Unknown
  • 1 = Windows

filesystem

integer

integer
  • 0 = Unknown
  • 1 = NTFS

scan_type

integer

integer

Should always be 1

progress_status

integer

integer
  • -2 = Waiting for retry
  • -1 = Ready for cleanup
  • 0 = Waiting for delegation
  • 1 = Delegated / scan in progress
  • 2 = Scan file transfer in progress
  • 3 = Database update in progress
  • 4 = Current - scan process complete
  • 5 = Database update pending
  • 6 = Previous
  • 7 = Retained

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

3.2.7 SRS.PREVIOUS_NTFS_ACES

Table 3-19 Previous NTFS ACEs View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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
  • 0 = Unknown / Other
  • 1 = User
  • 2 = Group
  • 3 = Computer

sid

varbinary(68)

bytea

 

access_mask

integer

integer
  • 0x1 = Read Data / List Directory
  • 0x2 = Write Data / Create File
  • 0x4 = Append Data / Create Subdirectory
  • 0x8 = Read Extended Attributes
  • 0x10 = Write Extended Attributes
  • 0x20 = File Execute / Traverse
  • 0x40 = Delete Child
  • 0x80 = Read Attributes
  • 0x100 = Write Attributes
  • 0x10000 = Delete
  • 0x20000 = Read Permissions
  • 0x40000 = Change Permissions
  • 0x80000 = Change Owner
  • 0x100000 = Synchronize
  • 0x1000000 = Access System Security
  • 0x10000000 = Generic All
  • 0x20000000 = Generic Execute
  • 0x40000000 = Generic Write
  • 0x80000000 = Generic Read

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
  • 0 = Access Allowed
  • 1 = Access Denied
  • 2 = System Audit
  • 9 = Allowed Callback
  • 10 = Denied Callback
  • 13 = System Audit Callback
  • 17 = System Mandatory Label

ace_type_string

nvarchar(128)

varchar(128)

See srs.ace_type_string

ace_flags

smallint

 
  • 0x1 = Object Inherit
  • 0x2 = Container Inherit
  • 0x4 = No Propagate
  • 0x8 = Inherit Only
  • 0x10 = Inherited
  • 0x40 = Successful Access
  • 0x80 = Failed Access

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
  • 0 = Unknown
  • 1 = File
  • 2 = Directory
  • 3 = File Symbolic Link
  • 4 = Directory Symbolic Link
  • 5 = Junction
  • 6 = Mount Point
  • 7 = Share
  • 8 = Volume
  • 9 = DFS Link
  • 10 = DFS Folder
  • 11 = DFS Root
  • 12 = HSM Stub
  • 13 = Reparse Point Unknown
  • 17 = Single Instance Storage Stub
  • 18 = Named Stream

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

3.2.8 SRS.PREVIOUS_PERMISSIONS_SCANS

Table 3-20 Previous Permissions Scans View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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
  • 0 = Unknown
  • 1 = Windows

filesystem

smallint

smallint
  • 0 = Unknown
  • 1 = NTFS

scan_type

integer

integer

Should always be 2

progress_status

integer

integer
  • -2 = Waiting for retry
  • -1 = Ready for cleanup
  • 0 = Waiting for delegation
  • 1 = Delegated / scan in progress
  • 2 = Scan file transfer in progress
  • 3 = Database update in progress
  • 4 = Current - scan process complete
  • 5 = Database update pending
  • 6 = Previous
  • 7 = Retained

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

3.2.9 SRS.BASELINE_FS_SCANDATA

Table 3-21 Baseline File System Scan Data Unified View

Column Name

SQL Server Data Type

PostgreSQL Data Type

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 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\SamAccountName

owner_id

varbinary(68)

bytea
  • Security Identifier (SID)

attributes

integer

integer
  • 0x0 = None
  • 0x1 = Read Only
  • 0x2 = Archive
  • 0x4 = System
  • 0x8 = Hidden
  • 0x10 = Directory
  • 0x20 = Compressed
  • 0x40 = Offline
  • 0x80 = NTFS device
  • 0x100 = NTFS Normal
  • 0x200 = NTFS Temporary
  • 0x400 = NTFS Sparse File
  • 0x800 = NTFS Reparse Point
  • 0x1000 = NTFS Not content indexed
  • 0x2000 = NTFS Encrypted
  • 0x4000 = NTFS Virtual

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
  • 0 = Unknown
  • 1 = File
  • 2 = Directory
  • 3 = File Symbolic Link
  • 4 = Directory Symbolic Link
  • 5 = Junction
  • 6 = Mount Point
  • 7 = Share
  • 8 = Volume
  • 9 = DFS Link
  • 10 = DFS Folder
  • 11 = DFS Root
  • 12 = HSM Stub
  • 13 = Reparse Point Unknown
  • 17 = Single Instance Storage Stub
  • 18 = Named Stream

status_code

integer

integer

 

3.2.10 SRS.BASELINE_FS_SCANS

Table 3-22 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)
  • 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
  • 0 = Unknown
  • 1 = Windows

filesystem

integer

integer
  • 0 = Unknown
  • 1 = NTFS

scan_type

integer

integer

Should always be 1

progress_status

integer

integer
  • -2 = Waiting for retry
  • -1 = Ready for cleanup
  • 0 = Waiting for delegation
  • 1 = Delegated / scan in progress
  • 2 = Scan file transfer in progress
  • 3 = Database update in progress
  • 4 = Current - scan process complete
  • 5 = Database update pending
  • 6 = Previous
  • 7 = Retained

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

3.2.11 SRS.BASELINE_NTFS_ACES

Table 3-23 Baseline NTFS ACEs View

Column Name

SQL Server Data Type

PosgreSQL Data Type

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
  • 0 = Unknown / Other
  • 1 = User
  • 2 = Group
  • 3 = Computer

sid

varbinary(68)

bytea

 

access_mask

integer

integer
  • 0x1 = Read Data / List Directory
  • 0x2 = Write Data / Create File
  • 0x4 = Append Data / Create Subdirectory
  • 0x8 = Read Extended Attributes
  • 0x10 = Write Extended Attributes
  • 0x20 = File Execute / Traverse
  • 0x40 = Delete Child
  • 0x80 = Read Attributes
  • 0x100 = Write Attributes
  • 0x10000 = Delete
  • 0x20000 = Read Permissions
  • 0x40000 = Change Permissions
  • 0x80000 = Change Owner
  • 0x100000 = Synchronize
  • 0x1000000 = Access System Security
  • 0x10000000 = Generic All
  • 0x20000000 = Generic Execute
  • 0x40000000 = Generic Write
  • 0x80000000 = Generic Read

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
  • 0 = Access Allowed
  • 1 = Access Denied
  • 2 = System Audit
  • 9 = Allowed Callback
  • 10 = Denied Callback
  • 13 = System Audit Callback
  • 17 = System Mandatory Label

ace_type_string

nvarchar(128)

varchar(128)

See srs.ace_type_string

ace_flags

smallint

 
  • 0x1 = Object Inherit
  • 0x2 = Container Inherit
  • 0x4 = No Propagate
  • 0x8 = Inherit Only
  • 0x10 = Inherited
  • 0x40 = Successful Access
  • 0x80 = Failed Access

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
  • 0 = Unknown
  • 1 = File
  • 2 = Directory
  • 3 = File Symbolic Link
  • 4 = Directory Symbolic Link
  • 5 = Junction
  • 6 = Mount Point
  • 7 = Share
  • 8 = Volume
  • 9 = DFS Link
  • 10 = DFS Folder
  • 11 = DFS Root
  • 12 = HSM Stub
  • 13 = Reparse Point Unknown
  • 17 = Single Instance Storage Stub
  • 18 = Named Stream

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

3.2.12 SRS.BASELINE_PERMISSIONS_SCANS

Table 3-24 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)
  • 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
  • 0 = Unknown
  • 1 = Windows

filesystem

smallint

smallint
  • 0 = Unknown
  • 1 = NTFS

scan_type

integer

integer

Should always be 2

progress_status

integer

integer
  • -2 = Waiting for retry
  • -1 = Ready for cleanup
  • 0 = Waiting for delegation
  • 1 = Delegated / scan in progress
  • 2 = Scan file transfer in progress
  • 3 = Database update in progress
  • 4 = Current - scan process complete
  • 5 = Database update pending
  • 6 = Previous
  • 7 = Retained

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