NetBackup IT Analytics System Administrator Guide

Usage

To insert a regular expression row into the database table, use this command:

execute server_group_package.insertCustomerOsNormData(null, 
'os_platform_regex', 'os_platform', 'os_version_regex', 
'ignore_string', priority, domain_id);

To update values in a regular expression row into the database table, use this command:

execute server_group_package.insertCustomerOsNormData
(os_normalization_id, 'os_platform_regex', 'os_platform', 
'os_version_regex' ,'ignore_strin g', priority, domain_id);

Where:

os_normalization_id: This value is unique for each Regex row

(See Host OS Categorization Default Settings.)

IDs less than 100000 are system defaults and cannot be removed, but their values can be modified. When inserting a regular expression into the database table, this value must be null because the process assigns this number.

os_platform_regex: These strings are used to match a substring in the collected text to identify the platform. This field cannot be null.

os_platform: This is the value that is saved to the database when the regular expression is encountered in the collected Host OS. This platform value can never be null, however, the version derived from the version regex may be null.

os_version_regex: This is the regular expression used to match a substring in the collected text to identify the version.

ignore_string: These strings are ignored and are treated as irrelevant details when determining the platform or version.

priority: This value indicates precedence: the higher the value, the higher the priority. For example, Red Hat has a higher priority than Linux, which means that a Host OS that contains a Red Hat substring and a Linux substring will result in a Host OS of Red Hat. User-defined regular expressions must have a priority higher than 1 to override system defaults. This field cannot be null.

domain_id: The Domain ID is shipped with a null default value. In multi-tenancy environments, such as Managed Services Providers, the Domain ID can be updated to change the processing for a specific domain/customer.

Note that a Creation Date also is saved in the database table. This is the date and time that the Regex record was created in the database.