This document describes the dumpcfg utility program, which is a database administration tool. The main function of the dumpcfg tool is to dump the Config_Message_Log table of the Logger database and display the table in a meaningful format. The Config_Message_Log table keeps track of configuration changes in an IP Contact Center (IPCC) Enterprise environment.
Cisco recommends that you have knowledge of these topics:
The information in this document is based on these software and hardware versions:
The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.
Refer to Cisco Technical Tips Conventions for more information on document conventions.
The ICM system keeps track of insertions, deletions and updates in the configuration database. The system retains this configuration history in a database table named Config_Message_Log.
Config_Message_Log is a database system table that stores configuration messages. Config_Message_Log contains these elements:
RecoveryKey: RecoveryKey is a value that the ICM software uses internally to track virtual time. This key can be converted to a twelve-digit configuration sequence number, which increments by one for each new record.
LogOperation: LogOperation indicates the type of configuration change. "Add" and "Update" are examples for LogOperation.
TableName: TableName represents the name of the table that the configuration change affects.
DateTime: DateTime indicates the date and time when a set of messages was logged.
ConfigMessage: ConfigMessage lists all configuration messages in a transaction.
The Config_Message_Log table is rather cryptic in the native state. Therefore, in order to understand the Config_Message_Log table, you need to extract the data, and convert the data into a readable and meaningful format. The dumpcfg utility can process the data and display the information in this list:
In order to view the details in the Config_Message_Log table, you can run the dumpcfg utility program. The audit trail of configuration changes appears. You can run the dumpcfg utility against the Logger database. Here is the syntax for this utility:
dumpcfg <database>[@server] <low recovery key> [high recovery key]
In this syntax:
< database > represents the case-sensitive name of the Logger database, for example, lab60_sideA.
@server represents the hostname of the ICM Admin Workstation (AW) or Logger.
Note: If you run the command at the server in question, substitute the @server with '@' character.
< low recovery key > and [ high recovery key ] represent a configuration sequence number (the RecoveryKey field in the Config_Message_Log table). In order to track all changes, ICM increments this configuration sequence number (see pink rectangles in Figure 1).
Run this command to produce a complete dump of these changes:
dumpcfg lab60_sideA@. 0
Set the value of lowRecoveryKey to zero (0), and drop the highRecoveryKey (see arrow A in Figure 1).
Figure 1 displays the partial output of the dumpcfg program.
In order to run dumpcfg and store the output in an ASCII text file named dumpcfg-output.txt, run the command with this syntax:
Figure 1 – The dumpcfg Utility and Partial Output
dumpcfg lab60_sideA@. 0 > dumpcfg-output.txt
You can determine the actual sequence numbers from the configuration in one of these ways: