How to remove license keys from VMware vRealize Automation Center 6.x

Products

• VMware Aria Suite

Issue/Introduction

This article provides steps to remove license keys from vRealize Automation Center (formerly known as VMware vCloud Automation Center) 6.x.

Environment

VMware vCloud Automation Center for Server 6.1.x
VMware vCloud Automation Center for Server 6.0.x
VMware vRealize Automation 6.2.x
VMware vCloud Automation Center for Desktop 6.1.x
VMware vRealize Automation Desktop 6.2.x
VMware vCloud Automation Center for Desktop 6.0.x

Resolution

To remove existing license keys from vRealize Automation Center (formerly known as VMware vCloud Automation Center) 6.x, access the IaaS database and perform these steps:

1. Run this query to backup existing license keys to a new table:
   
   SELECT * INTO dbo.LicenseKeys_backup FROM dbo.LicenseKeys
   
   
2. Run this query to remove the license keys:
   
   DELETE FROM dbo.LicenseKeys WHERE SerialNumber IN ('1st license key', '2nd license key')
   
   Note: Replace the first license key and second license key with actual license keys and keep the quotes and parentheses.
   
   
3. If you require to restore the license keys you have removed, run this query:
   
   INSERT INTO LicenseKeys (SerialNumber) SELECT SerialNumber FROM LicenseKeys_backup WHERE NOT EXISTS (SELECT SerialNumber FROM LicenseKeys WHERE SerialNumber = LicenseKeys_backup.SerialNumber)