Guest OS Family Type Supermetric

[OsburnM]

Looking for some ideas here--  I'd like to build off the default "Virtual Machine Guest OS Name" Distribution View that shows a pie chart of all the Guest OS Type Names and simplify it down to just either Microsoft or Linux.  Anyone have any ideas or suggestions?

[sxnxr]

I messed around with this and could not get it to work.

I tried creating custom groups and adding them to the chart. Also created a count super metric for the groups and still not able to get it in the chart. As far as i can see you cant do what you are after

[marcethz]

If anyone ever wants to do this , this is how I got it working with supermetrics which can be used in a report. Not really elegant, but it does what it's supposed to do. This is  for Linux Guest OS which can be applied on vCenter Server for example

count(${adaptertype=VMWARE, objecttype=VirtualMachine, attribute=config|guestFullName, depth=5, where =(
$value contains 'Red Hat Enterprise Linux 7 (64-bit)' || 
$value contains 'Red Hat Enterprise Linux 6 (64-bit)' || 
$value contains 'Red Hat Enterprise Linux 6 (32-bit)' || 
$value contains 'Red Hat Enterprise Linux 5 (64-bit)' || 
$value contains 'Red Hat Enterprise Linux 5 (32-bit)' || 
$value contains 'Red Hat Enterprise Linux 4 (64-bit)' ||
$value contains 'Red Hat Enterprise Linux 4 (32-bit)' ||
$value contains 'Red Hat Enterprise Linux 3 (64-bit)' ||
$value contains 'Red Hat Enterprise Linux 3 (32-bit)' ||
$value contains 'Red Hat Enterprise Linux 2.1' ||
$value contains 'SUSE Linux Enterprise 12 (64-bit)' ||
$value contains 'SUSE Linux Enterprise 11 (64-bit)' ||
$value contains 'SUSE Linux Enterprise 11 (32-bit)' ||
$value contains 'SUSE Linux Enterprise 10 (64-bit)' ||
$value contains 'SUSE Linux Enterprise 10 (32-bit)' ||
$value contains 'SUSE Linux Enterprise 8/9 (64-bit)' ||
$value contains 'SUSE Linux Enterprise 8/9 (32-bit' ||
$value contains 'CentOS 4/5 or later (64-bit)' ||
$value contains 'CentOS 4/5 or later (32-bit)' ||
$value contains 'Debian GNU/Linux 7 (64-bit)' ||
$value contains 'Debian GNU/Linux 7 (32-bit)' ||
$value contains 'Debian GNU/Linux 6 (64-bit)' ||
$value contains 'Debian GNU/Linux 6 (32-bit)' ||
$value contains 'Debian GNU/Linux 5 (64-bit)' ||
$value contains 'Debian GNU/Linux 5 (32-bit)' ||
$value contains 'Debian GNU/Linux 4 (64-bit)' ||
$value contains 'Debian GNU/Linux 4 (32-bit)' ||
$value contains 'Asianux 4 (64-bit)' ||
$value contains 'Asianux 4 (32-bit)' ||
$value contains 'Asianux 3 (64-bit)' ||
$value contains 'Asianux 3 (32-bit)' ||
$value contains 'Oracle Linux 4/5 or later (64-bit)' ||
$value contains 'Oracle Linux 4/5 or later (32-bit)' ||
$value contains 'Ubuntu Linux (64-bit)' ||
$value contains 'Ubuntu Linux (32-bit)' ||
$value contains 'Other 3.x Linux (64-bit)' ||
$value contains 'Other 3.x Linux (32-bit)' ||
$value contains 'Other 2.6.x Linux (64-bit)' ||
$value contains 'Other 2.6.x Linux (32-bit)' ||
$value contains 'Other 2.4.x Linux (64-bit)' ||
$value contains 'Other Linux (64-bit)' ||
$value contains 'Other Linux (32-bit)' ||
)})