I have an issue with a super metric I am trying to build on vRops 8.6.2. The super metric is meant to be applied on esxi hosts, its purpose is to process the number of active lun paths that host should have, based on the number of datastore connected to that host.
The super metric currently looks like below, it is not reporting syntax error but the where on the second line is not working as expected: the datastores that contains SC are going to match on first line (with config name that should not contain "SC") and also on the second line, which is unexpected.
count(${adaptertype=VMWARE, objecttype=Datastore, attribute=config|name, depth=1, where="contains SC"}) * 8 +
count(${adaptertype=VMWARE, objecttype=Datastore, attribute=config|name, depth=1, where=($value !contains SC && ${attribute=summary|isLocal} equals false)}) * 4 +
count(${adaptertype=VMWARE, objecttype=Datastore, attribute=summary|isLocal, depth=1, where="equals true"})
Any advises on how to fix the where clause in the second line?
