Masking a contact number in the local Experience Portal database

About this task

Use this procedure to mask a specified contact number in all CDR records in the local Experience Portal database.

The MaskContactNumberLocalDB script examines all CDR records in the local Experience Portal database and replaces all instances of the specified contact number with a new contact number. The script searches both the Originating Number field and the Destination Number field in each CDR record. For example, any reference to sip:4085551212 can be replaced with sip:408******* or just ****.

Procedure

Log on to Linux on the Primary EPM server.
- If you are an Avaya Services representative, and use Avaya Enterprise Linux, or if the Avaya Service accounts are installed on this server, log on to the local Linux console as root.
- Otherwise, log on remotely as a non-root user, and then change the user to root by entering the su - root command.
Navigate to the Support/VP-Tools directory under the Experience Portal installation directory.
Enter the cd $AVAYA_HOME/Support/VP-Tools command.

$AVAYA_HOME is an environmental variable pointing to the name of the installation directory specified during the Experience Portal software installation. The default value is /opt/Avaya/ExperiencePortal.
Enter the bash MaskContactNumberLocalDB “current contact number” “new contact number” command.

Ensure to enclose any value that contains non alphanumeric characters with quotation marks. For example, bash MaskContactNumberLocalDD "sip:4085551212" "****"

Note that the system may take some time to mask the data depending on the amount of data in the CDR database table.

If the script runs successfully, it returns a message stating how many records were updated. Otherwise, it returns a message stating the problem that it encountered.