Removing a deleted license key from the Licensing Reporting tab in vCenter Server

Products

• VMware vCenter Server

Issue/Introduction

This article provides steps to remove deleted license keys from the Licensing Reporting tab in vCenter Server.

 

You may want to use this procedure if the license information continues to display in the vSphere Client Licensing Reporting tab even after removing the asset and the license key from vCenter Server.

Environment

VMware vCenter Server 5.0.x

Resolution

To remove the license key information from the reporting tool, you must remove the license information from the vCenter Server database.

Note: VMware recommends that you consult your Database Administrator (DBA) before implementing any changes to the database configuration and whenever possible the DBA should be the one to perform these actions. Before performing any database operations, take a full backup of the database. For more information, see Microsoft Knowledge Base article Create a Full Database Backup.

 

To remove the license information from the vCenter Server database:

Note: This procedure uses the example of vRealize Operations Standard (formerly known as vCenter Operations Manager Standard) as the deleted asset and license key.

1. Stop the VMware VirtualCenter Management Webservices on vCenter Server. For more information, see Stopping, starting, or restarting vCenter services (1003895).
2. Take a complete backup of the vCenter Server database. Do not skip this step.
3. Launch Microsoft SQL Server Management studio.
4. Click New Query.
5. Ensure that the vCenter Database (vcdb) is selected in the Available Databases dropdown.
6. In the new query window, paste these SQL statements and click Execute:
   
   delete from VPX_LIC_USAGE where CONTEXT_ID =(select CONTEXT_ID from VPX_LIC_CONTEXT where LICENSE_ID = (Select LICENSE_ID from VPX_LIC_LICENSES where EDITION_NAME = 'vCenter Operations Standard'))
   
   delete from VPX_LIC_CONTEXT where LICENSE_ID = (Select LICENSE_ID from VPX_LIC_LICENSES where EDITION_NAME = 'vCenter Operations Standard')
   
   delete from VPX_LIC_LICENSES where EDITION_NAME = 'vCenter Operations Standard'
   
7. Start the VMware VirtualCenter Management Webservices. For more information, see Stopping, starting, or restarting vCenter services (1003895).

Additional Information

How to stop, start, or restart vCenter Server services