Reference ZenDesk Incident: 1561442

Description:   When BGRS acquires new clients as part of the business process they will contact I.T. to upload/enable the client in MoveXpert.  Attached in the ZenDesk request you will find an Excel sheet with the OrgName and OrgNumber. 

Process:

-- Below is the DBCR you will need to add clients into MoveXpert

IF (@@SERVERNAME not in ('SQLPPLumpsum\LUMPSUM'))
BEGIN
PRINT 'ERROR: This script is only intended to run on correct server name'
END
ELSE
BEGIN
PRINT @@SERVERNAME
PRINT 'INC- 1561442 - Add new client to MoveXpert'
USE Lumpsum

Insert Into Client
(ClientNumber,ClientName,SegmentId)VALUES

(601171,'Honeywell Helios Inc',1 ),
(601170,'United Airlines',1 ),
(601162,'L''Oreal',1)

IF EXISTS (select 3 from Client where ClientNumber in ('601171','601170','601162')and ClientName in ('Honeywell Helios Inc','United Airlines','L''Oreal'))

BEGIN
PRINT 'Verified!'
END
ELSE
BEGIN
PRINT 'ERROR: Verification failed!'
END
END

Once the DBCR has been applied by the DBA team have the requestor provide confirmation by validating in MoveXpert that the client list provided is now visible in the application.