1.1 Updates and Breaking Changes

1.1.1 Additional scan_id Column

The scan_id column has now been extended to the following tables and indexed to provide simpler joins and quicker lookup:

  • srs.scan_directory_data

  • srs.ntfs_aces

  • srs.security_descriptors

  • srs.ncp_trustees

1.1.2 Added srs.byte_unit_string Function

The function srs.byte_unit_string was added in this release. This function is similar to srs.byte_string but allows the caller to specify which unit the formatted result will be displayed in, such as KB, MB, or GB.

1.1.3 Deprecated Column is_valid

The column is_valid in the table srs.scans and the views srs.current_fs_scans and srs.current_permissions_scans is now deprecated. This column is redundant in that it reflects whether the progress_status column contains the value 4, indicating whether a scan is Current. Since the progress_status column maintains the scan state for the Current, Previous, and Retained scan statuses as well as other scan states, it should be used instead.

This field still remains in the schema for this release, but might be removed in a later version.

1.1.4 Active Views

The previously deprecated srs.active_* views have been removed in this release. Please update any queries referencing these to the equivalent replacement views listed below.

Table 1-1 Active Views

Removed View

Replacement View

srs.active_fs_scans

srs.current_fs_scans

srs.active_fs_scandata

srs.current_fs_scandata

srs.active_fs_scandata_ad

srs.current_fs_scandata_ad

srs.active_fs_scandata_edir

srs.current_fs_scandata_edir

srs.active_permissions_scans

srs.current_permissions_scans

srs.active_ncp_trustees

srs.current_ncp_trustees

srs.active_ntfs_aces

srs.current_ntfs_aces