Validate VMAN licensed sockets count for VMWare

6/17/2020 10:19 AM

2/18/2022 9:45 AM

SolarWinds Virtualization Manager is licensed according to the number of CPU sockets per monitored host. 

This article provides information on how to validate the VMAN licensed sockets count by SQL query.

Virtualization Manager

Run the SQL query below to validate the number of CPU sockets per monitored host:

• SELECT vc.Name AS vCenterName, h.HostName AS EsxHostName, h.VMwareProductName, h.VMwareProductVersion, h.Model, h.Vendor, h.CpuPkgCount AS 'CPU Sockets count'
  FROM [dbo].[VIM_Hosts] AS h
  JOIN [dbo].[VIM_DataCenters] AS dc ON h.DataCenterID = dc.DataCenterID
  JOIN [dbo].[VIM_VCenters] AS vc ON dc.VCenterID = vc.VCenterID
• Result as below:
  • 

Run the SQL query below to validate the total number of CPU sockets per vCenter:

• SELECT vc.Name AS vCenterName, SUM (h.CpuPkgCount) AS 'CPU Sockets count'
  FROM [dbo].[VIM_Hosts] AS h
  JOIN [dbo].[VIM_DataCenters] AS dc ON h.DataCenterID = dc.DataCenterID
  JOIN [dbo].[VIM_VCenters] AS vc ON dc.VCenterID = vc.VCenterID
  GROUP BY vc.Name
• Result as below:
  • 

Disclaimer: 
Scripts are not supported under any SolarWinds support program or service. Scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.