2.5 Supported Functions

Table 2-4 Supported Database Functions

Category

View Name

Description

General

srs.byte_string

Converts raw number to byte string such as 10 MB or 3.25 KB

 

srs.byte_unit_string

Converts raw number to byte string with specified unit and precision.

 

srs.attribute_string

Converts attributes to string representation

 

srs.guid_bytes

Converts Guid from string to binary

 

srs.guid_text

Converts Guid from binary to string

 

srs.path_hash

Calculates SHA-1 hash of lowercase input (typically a path)

 

srs.path_hash_sha256

Calculates SHA256 hash of lowercase input (typically a path)

 

srs.bytes_to_hex_string

Converts byte array to equivalent hex string

 

srs.hex_string_to_bytes

Converts hex string to equivalent byte array

Identity Systems

srs.sid_bytes

Converts SID from string to binary

 

srs.sid_text

Converts SID from binary to string

 

srs.ad_account_name

Combines AD account name elements into a single display name

Permissions

srs.access_mask_basic_string

Converts access mask value to basic permissions string

 

srs.access_mask_string

Converts access mask value to string representation

 

srs.ace_flags_string

Translates ACE flag to string values

 

srs.ace_type_string

Translates ACE type to string value

 

srs.ace_type_string

Translates ACE type to string value