How to configure GDPR (Forget Customer) script

Introduction

With the GDRP script you can remove the customers info from Anywhere365.

 

Configure

Request the "forgeturi - GDPR.zip" and store on a location from where you have access to the Database, SharePoint sites and the optional UNC storage.

To help the script find the proper locations, a couple parameters need to be set in the forgetUri.ps1 file

$sqlServer = 'WSP-SQLServer.contoso.com'

$sqlInstance = 'NamedInstance' #for default leave empty

$sqlDatabase = 'UCCUCC stands for Unified Contact Center and consists of a queue that can be handled by Agents Each Contact Center has its own settings, interactive voice response questions and Agent with specific skills. Agents can be member of, or sign up to, one or more Contact Centers._Database'

$sqlUsername = '' #for SQL Authentication only; for windows authentication execute script as user with permissions to the database; e.g. service account

$sqlPassword = '' #for SQL Authentication only; for windows authentication execute script as user with permissions to the database; e.g. service account

$spUsername = '' #if no SharePoint username is defined it will use current user account

$spPassword = ''

$a365ServerName = ''

$a365ConfigLocation = ''

$replaceUriWith = '**********'

$recordingLibrary = 'Recordings'

$voicemailLibrary = 'Voicemails'

 

Parameter

Description

$sqlServer

The SQL Server address (Normally Hostname+Domain)

$sqlInstance

Only needs to be set when a Named Instance is used. If that’s not the case, the default (MSSQL) will be used

$sqlDatabase

The name of the Anywhere365 CDR Database

$sqlUsername

If SQL Server Authentication is used, set the username here. This does not apply when you’re using the Windows Authentication method. In case of Windows Authentication, leave blanc and run the PowerShell script with the proper account.

$sqlPassword

If SQL Server Authentication is used, set the password here. This does not apply when you’re using the Windows Authentication method. In case of Windows Authentication, leave blanc and run the PowerShell script with the proper account.

 

 

$spUsername

Set the SharePoint username for the account which has permissions on the UCC sites (best to use a Site Collection Administrator account). If this is left blanc, the script will automatically use the credentials of the account who runs the script.

$spPassword

Set the SharePoint password for the account which has permissions on the UCC sites (best to use a Site Collection Administrator account). If this is left blanc, the script will automatically use the credentials of the account who runs the script.

 

 

$a365ServerName

Provide the name of the Anywhere365 server (so the script can find the Config.xml)

$a365ConfigLocation

Provide the Binary path of the Config.xml

6.3: C:\ProgramData\Anywhere365\CoreThe Core is the center of Anywhere365. It manages all the Dialogues.\Service\UnifiedContactCenterService\Config.xml

6.0: C:\Program Files\Anywhere365\Core\Config.xml

5.0: C:\Program Files\UCC\Config.xml

 

 

$replaceUriWith

The LineUri will be replaced by this (Default is **********)

$recordingLibrary

The name of the SharePoint library where the recordings are stored.

$voicemailLibrary

The name of the SharePoint library where the voicemails are stored.

 

To run the script and start ‘forgetting’ the customers of your choosing, follow the steps below:

  1. Fill in the above parameters
  2. Run Windows PowerShell as administrator

    Note Make sure to use an account which has permissions on the Database and the SharePoint sites.

  3. Use the cd cmdlet to browse to the path of the forgetUri.ps1 script.
  4. Start the script, by typing .\forgetUri.ps1 and press enter
  5. The script prompts “Please enter URI to be forgotten:”
    1. Enter the phone number of the customer who wants to be forgotten. Use the E.164 notation. (e.g. tel:+31612345678)
  6. The script will prompt the x amount of results found in the database
    1. ‘Select URI’s to forget (comma-separated):
    2. Fill in the number, or numbers of phone numbers to wish to forget.
    3. E.g. 1 or 1,2,3
    4. Hit enter
  7. The script will now start:
    1. to delete the found recordings
    2. to delete the recordings references in the database (to remove the recording link in the reports)
    3. to delete the voicemails
    4. to delete the voicemails references in the database (to remove the recording link in the reports)
    5. to anonymize the phone number into the value, set in $replaceUriWith (default *********)
    6. to anonymize the phone number on the CallSummary on the SharePoint site(s)

 

Examples

Example of the script

 

Example of modified report

 

Example of Call Summary list