5.2 Temp Tables

5.2.1 tmp_cq_fs_paths

Column Name

SQL Server

PostgreSQL

Notes

report_id

integer

integer

Reference to primary key of associated srs.report_definitions entry

scan_id

integer

integer

Reference to primary key of associated srs.scans entry

scan_type

integer

integer
  • 0 = None
  • 1 = File System Data
  • 2 = Permissions
  • 4 = Volume Free Space

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

scan_start_time

datetime3(2)

timestamp

Start time when agent begins physical scan

scan_target_id

integer

integer

Reference to primary key of associated srs.scan_targets entry

target_path

nvarchar(max)

text

Selected path for this report

target_path_hash

binary(20)

bytea

SHA-1 hash of normalized target path

path_index

integer

integer

Used for hierarchical relation processing

ns_left

integer

integer

Nested-set Left index – used for hierarchical relation processing

ns_right

integer

integer

Nested-set Right index – used for hierarchical relation processing

path_depth

integer

integer

Entry depth with respect to the scan target’s root path

path_type

integer

integer
  • 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

is_permission_scan

bit

boolean

Flag indicating whether this entry is for a file system permissions scan

Can be used in place of scan_type

is_filesystem_scan

bit

boolean

Flag indicating whether this entry is for a file system metadata scan

Can be used in place of scan_type

is_current

bit

boolean

Flag indicating whether this entry is for the current scan

Can be used in place of progress_status

is_previous

bit

boolean

Flag indicating whether this entry is for a previous scan

Can be used in place of progress_status

is_baseline

bit

boolean

Flag indicating whether this entry is for a baseline scan

Can be used in place of progress_status