Monitoring Health of Configuration Environment

csv_search_backslash.sql

This script retrieves a list of configuration options, including those set in the Annex, for which the configured value contains two or more sequential backslash characters (\\).This list is a drill-down report that enables you to determine if any particular object of a given type is configured with an option or annex value of two or more sequential backslashe characters.

With a PostgreSQL database, if the number of records in the report increases significantly immediately after a Configuration Server restart, you can use this report to determine if the PostgreSQL database setting standard_conforming_strings has been set incorrectly. The report can then form the basis of a new script that can fix the records. If you do not want to use a script, or if you only have a few records to correct, you can correct them manually using Genesys Administrator.

This script produces CSV-formatted output on the console. The number of rows is variable and can grow to be a very large number. Ther

This script produces CSV-formatted output on console. There is one header row, and any number of data rows. The number of data rows is variable and can be large. The data rows are grouped by type and then by parent object DBID within each type. The header row identifies each column in the data rows, as follows:

• type: The type of object, as visible in Genesys Administrator. The one exception is that a User or Agent object type is named Person.
• object_name: The name of the parent object.
• tenant_name: The name of the Tenant object to which this object belongs. This information is not provided for Folder object types.
• object_dbid: The DBID of the object, enabling a trace of the object in the database and the audit trail.
• option_type: The type of configuration option, based on where it is set, Option or Annex.
• section_name: The name of the configuration option section in which the the option is set.
• option_name: The name of the option with a value containing two or more sequential backslashes.
• option_value: The option value that contains two or more sequential backslashes.

Sample printout, in CSV format:

type,object_name,tenant_name,object_dbid,option_type,section_name,option_name,option_value
Application,confserv,Environment,99,Option,backslashOPt,backlashopt,^[\(\)\-\.\+\d\s\*#]*[\d]+[\(\)\-\.\+\d\s\*#/]*$
Application,confserv,Environment,99,Annex,backslashAnnex,backlashopt,^[\(\)\-\.\+\d\s\*#]*[\d]+[\(\)\-\.\+\d\s\*#/]*$