VMWare – Version

Background

Needing to find out what versions of VMWare we are running.

 

Databases

Vmware can be back-ended by an Oracle, SQL Server, or postgres.

 

Query

To determine the versions of VMWare our hosts are running on, we issue the query pasted below:

Script


select 
		  vwHost.[PRODUCT_FULLNAME]
		, vwHost.[PRODUCT_VERSION]
		, vwHost.[VMOTION_ENABLED]
		, [count] = count(*)

from   [dbo].[VPXV_HOSTS] vwHost

group by

		  vwHost.[PRODUCT_FULLNAME]
		, vwHost.[PRODUCT_VERSION]
		, vwHost.[VMOTION_ENABLED]


 

Output

 

Explanation

We are on VMWare ESXi 5.5.0

 

References

  1. Brian P. O’Dwyer
    • Gathering ESXi Host Information from VMware vCenter VCDB for Virtual SQL Servers
      Link
  2. VMWare
    • Home > Resources > Compatibility Guides > Interoperability Matrix
      • VMware Product Interoperability Matrices
        Link

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s