Ensuring a History of Recorder Serial Numbers is Maintained in the Database

Some managed servers added to the Enterprise Manager must have a unique serial number. This serial number is used to generate a unique identifier, which is in turn used to identify uniquely each call recorded by the server.

Ensuring that each recorded call file is uniquely identified prevents existing recorded calls in storage from being overwritten by more recent recorded call files. (That is, it prevents two different recorded call files from being assigned the same name.) If the same serial number was assigned to two managed servers, it is possible that two recorded calls could be assigned the same identifier. In this case, one file could overwrite the other in storage.

Enterprise Manager ensures that no two managed servers with the same serial number are ever added to the Installations tree. To ensure that this situation does not occur, Enterprise Manager maintains a history of the serial numbers assigned to all current and past managed servers. (This history includes both managed servers currently existing in the Installations tree and managed servers that have been deleted from the Installations tree.)

Enterprise Manager maintains the serial number history in the GLOBALUNIQUEIDHISTORY table in the Framework Database Server role in the Data Center (also known as BPMain) that stores user, organization and group data, including user preferences and security data (roles, permissions, and license information)..

Enterprise Manager maintains the serial number history in the following way:

  1. A serial number is assigned to a managed server Server that is managed by the Enterprise Manager application. whenever one of these three roles is activated on the server: IP Recorder, Screen Recorder, or TDM Recorder.

  2. The serial number is written to the SERVERINSTALLATION table in the Framework Database.

  3. On system start, Enterprise Manager examines the serial numbers provided for all current servers in the SERVERINSTALLATION table.

  4. Enterprise Manager then verifies that each managed server listed in the GLOBALUNIQUEIDHISTORY table has a serial number associated to it. If a serial number is not associated to a managed server, Enterprise Manager assigns the serial number to the server. Enterprise Manager assigns the serial number based on the serial number information obtained from the SERVERINSTALLATION table.

    The server serial numbers and related information are maintained in these three columns of the GLOBALUIQUEIDHISTORY table:

    • COUNTERNAME - The table uses AUDIO_REC as the COUNTERNAME for the list of managed recorder servers and their serial numbers.

    • HOSTNAME - Contains the host name of a managed recorder server.

    • GLOBALUNIQUEID - Contains the serial number of the managed recorder server.