Super Metric to count VMs by Windows or Non-Windows

This super metric was created for a customer use case of publishing an executive dashboard with the count of Windows VMs and Linux VMs within vRA Business Groups .

This super metric may also be applied against any other objects  like Datacenter , Datastore , vCenter etc.

The formula used were as below :

For Count of Windows VMs:

count(${adaptertype=VMWARE, objecttype=VirtualMachine, attribute=summary|guest|fullName, depth=5, where ="summary|guest|fullName startsWith Microsoft Windows"})

For Count of non-Windows VMs:

count(${adaptertype=VMWARE, objecttype=VirtualMachine, attribute=summary|guest|fullName, depth=5, where ="summary|guest|fullName !startsWith Microsoft Windows"})

You may modify this to count any specific OS also by replacing "Microsoft windows" with any other OS name as found from the Virtual Machine Property Summary|Guest Operating System|Guest OS Full Name.

Note : The above works only with vRops starts starting 7.0