C:\ Utilization Filter Not Working

[nmanm0305]

I have a report that lists C:\ drive capacity, usage, remaining and percent-used for VMs. It is supposed to filter for VMs with 90%+ utilized C:\ drives.

Since upgrading from 6.7 to 7.0, the filter is no longer functional.

Without the filter, C:\ percent-used displays correctly.

But with the filter, VMs that do not have 90% C:\ utilization are displayed (including VMs with no information at all).

This is problematic as the purpose of the report is to display only VMs that have 90%+ utilized C:\ drives.

[RobertMesropyan]

Hello!

Could you please attach your view's xml?

[nmanm0305]

The View is not utilizing an XML. It is configured manually in the widget.

[RickVerstegen]

Check the metrics in the filter. Metrics can be removed or changed (different name) when upgrading to a newer version.

Another thing you can try is to re-create the view from scratch in version 7.0.

[RobertMesropyan]

I would ask you to try export view:

[RobertMesropyan]

In addition, try to configure all metrics with 'Current' transformation

[nmanm0305]

Exported view below......

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<Content>

    <Views>

        <ViewDef id="4798e97e-7618-4b6d-abe3-e0ed7112fd16">

            <Title>Cust-VM Guest File System &gt; 90%</Title>

            <Description>Gathers Guest File System Information (C:\)</Description>

            <SubjectType adapterKind="VMWARE" filter="[[{&quot;condition&quot;:&quot;EQUALS&quot;,&quot;metricKey&quot;:&quot;summary|runtime|powerState&quot;,&quot;metricValue&quot;:{&quot;isStringMetric&quot;:true,&quot;value&quot;:&quot;Powered On&quot;},&quot;filterType&quot;:&quot;properties&quot;},{&quot;condition&quot;:&quot;NOT_EQUALS&quot;,&quot;metricKey&quot;:&quot;summary|parentVcenter&quot;,&quot;metricValue&quot;:{&quot;isStringMetric&quot;:true,&quot;value&quot;:&quot;gpvmwvca03&quot;},&quot;filterType&quot;:&quot;properties&quot;},{&quot;condition&quot;:&quot;NOT_EQUALS&quot;,&quot;metricKey&quot;:&quot;summary|parentVcenter&quot;,&quot;metricValue&quot;:{&quot;isStringMetric&quot;:true,&quot;value&quot;:&quot;gpvmwvcb03&quot;},&quot;filterType&quot;:&quot;properties&quot;}]]" resourceKind="VirtualMachine" type="descendant"/>

            <SubjectType adapterKind="VMWARE" filter="[[{&quot;condition&quot;:&quot;EQUALS&quot;,&quot;metricKey&quot;:&quot;summary|runtime|powerState&quot;,&quot;metricValue&quot;:{&quot;isStringMetric&quot;:true,&quot;value&quot;:&quot;Powered On&quot;},&quot;filterType&quot;:&quot;properties&quot;},{&quot;condition&quot;:&quot;NOT_EQUALS&quot;,&quot;metricKey&quot;:&quot;summary|parentVcenter&quot;,&quot;metricValue&quot;:{&quot;isStringMetric&quot;:true,&quot;value&quot;:&quot;gpvmwvca03&quot;},&quot;filterType&quot;:&quot;properties&quot;},{&quot;condition&quot;:&quot;NOT_EQUALS&quot;,&quot;metricKey&quot;:&quot;summary|parentVcenter&quot;,&quot;metricValue&quot;:{&quot;isStringMetric&quot;:true,&quot;value&quot;:&quot;gpvmwvcb03&quot;},&quot;filterType&quot;:&quot;properties&quot;}]]" resourceKind="VirtualMachine" type="self"/>

            <Usage>dashboard</Usage>

            <Usage>report</Usage>

            <Usage>details</Usage>

            <Usage>content</Usage>

            <Controls>

                <Control id="time-interval-selector_id_1337" type="time-interval-selector" visible="false">

                    <Property name="advancedTimeMode" value="false"/>

                    <Property name="unit" value="DAYS"/>

                    <Property name="count" value="7"/>

                </Control>

                <Control id="attributes-selector_id_1338" type="attributes-selector" visible="false">

                    <Property name="attributeInfos">

                        <List>

                            <Item>

<Value>

    <Property name="objectType" value="RESOURCE"/>

    <Property name="attributeKey" value="guestfilesystem:C:\|capacity"/>

    <Property name="preferredUnitId" value="gb"/>

    <Property name="isStringAttribute" value="false"/>

    <Property name="adapterKind" value="VMWARE"/>

    <Property name="resourceKind" value="VirtualMachine"/>

    <Property name="rollUpType" value="NONE"/>

    <Property name="rollUpCount" value="0"/>

    <Property name="transformations">

        <List>

            <Item value="LAST"/>

        </List>

    </Property>

    <Property name="isProperty" value="false"/>

    <Property name="displayName" value="C:\ Drive Capacity"/>

</Value>

                            </Item>

                            <Item>

<Value>

    <Property name="objectType" value="RESOURCE"/>

    <Property name="attributeKey" value="guestfilesystem:C:\|usage"/>

    <Property name="preferredUnitId" value="gb"/>

    <Property name="isStringAttribute" value="false"/>

    <Property name="adapterKind" value="VMWARE"/>

    <Property name="resourceKind" value="VirtualMachine"/>

    <Property name="rollUpType" value="NONE"/>

    <Property name="rollUpCount" value="0"/>

    <Property name="transformations">

        <List>

            <Item value="LAST"/>

        </List>

    </Property>

    <Property name="isProperty" value="false"/>

    <Property name="displayName" value="C:\ Drive Usage"/>

</Value>

                            </Item>

                            <Item>

<Value>

    <Property name="objectType" value="RESOURCE"/>

    <Property name="attributeKey" value="guestfilesystem:C:\|freespace"/>

    <Property name="preferredUnitId" value="gb"/>

    <Property name="isStringAttribute" value="false"/>

    <Property name="adapterKind" value="VMWARE"/>

    <Property name="resourceKind" value="VirtualMachine"/>

    <Property name="rollUpType" value="NONE"/>

    <Property name="rollUpCount" value="0"/>

    <Property name="transformations">

        <List>

            <Item value="CURRENT"/>

        </List>

    </Property>

    <Property name="isProperty" value="false"/>

    <Property name="displayName" value="C:\ Drive Remaining"/>

</Value>

                            </Item>

                            <Item>

<Value>

    <Property name="objectType" value="RESOURCE"/>

    <Property name="attributeKey" value="guestfilesystem:C:\|percentage"/>

    <Property name="preferredUnitId" value="percent"/>

    <Property name="isStringAttribute" value="false"/>

    <Property name="adapterKind" value="VMWARE"/>

    <Property name="resourceKind" value="VirtualMachine"/>

    <Property name="rollUpType" value="NONE"/>

    <Property name="rollUpCount" value="0"/>

    <Property name="transformations">

        <List>

            <Item value="LAST"/>

        </List>

    </Property>

    <Property name="sortCriteria" value="false"/>

    <Property name="isProperty" value="false"/>

    <Property name="displayName" value="C:\ Drive % Used"/>

</Value>

                            </Item>

                            <Item>

<Value>

    <Property name="objectType" value="RESOURCE"/>

    <Property name="attributeKey" value="summary|tag"/>

    <Property name="isStringAttribute" value="true"/>

    <Property name="adapterKind" value="VMWARE"/>

    <Property name="resourceKind" value="VirtualMachine"/>

    <Property name="rollUpCount" value="0"/>

    <Property name="transformations">

        <List>

            <Item value="LAST"/>

        </List>

    </Property>

    <Property name="isProperty" value="true"/>

    <Property name="displayName" value="Owner"/>

</Value>

                            </Item>

                            <Item>

<Value>

    <Property name="objectType" value="RESOURCE"/>

    <Property name="attributeKey" value="summary|parentVcenter"/>

    <Property name="isStringAttribute" value="true"/>

    <Property name="adapterKind" value="VMWARE"/>

    <Property name="resourceKind" value="VirtualMachine"/>

    <Property name="rollUpCount" value="0"/>

    <Property name="transformations">

        <List>

            <Item value="CURRENT"/>

        </List>

    </Property>

    <Property name="isProperty" value="true"/>

    <Property name="displayName" value="Parent vCenter"/>

</Value>

                            </Item>

                        </List>

                    </Property>

                </Control>

                <Control id="pagination-control_id_1339" type="pagination-control" visible="true">

                    <Property name="start" value="0"/>

                    <Property name="size" value="50"/>

                </Control>

                <Control id="metadata_id_1340" type="metadata" visible="false">

                    <Property name="maxPointsCount" value="5000"/>

                    <Property name="distributionColor" value="6870C4"/>

                    <Property name="hideObjectNameColumn" value="false"/>

                    <Property name="listTopResultSize" value="-1"/>

                </Control>

            </Controls>

            <DataProviders>

                <DataProvider dataType="list-view" id="list-view_id_1336"/>

            </DataProviders>

            <Presentation type="list"/>

        </ViewDef>

    </Views>

</Content>

[nmanm0305]

No change after chaning all metric to 'Current' transformation.

[RobertMesropyan]

Hmm, in such case I would ask you to set add these classes in "analytics" log settings wuth debug level:

com.vmware.vcops.controller.query.QueryShardService

com.vmware.vcops.controller.query.QueryShardDataService

com.vmware.vcops.controller.query.reader.AnalyticsCacheReader

and collect logs during view execution.

P.S Don't forget to change log level to "error" after collection:)

com.vmware.vcops.controller.query.QueryShardService

com.vmware.vcops.controller.query.QueryShardDataService

com.vmware.vcops.controller.query.reader.AnalyticsCacheReader

[nmanm0305]

Ive been working with GSS on this issue. I have a report thats filter for VMs with 90%+ utilized C:\ drives. Since upgrading from 6.7 to 7.0, the filter is no longer functional.

1. GSS recommended filtering out non-Windows VMs. These machines were showing up on the report with dashes in place of actual metrics. The Support Engineer told me this was necessary because vROPS cannot apply the C:\ drive metric to non-Windows VMs. Filtering out the non-Windows VMs removed dozens of machines that were being erroneously listed. I find the necessity of the filter odd as it was not needed in 6.7; only after I upgraded to vROPS 7.0 did the this problem surface.

2. After removing non-Windows VMs from the report, there were still Windows VMs showing up that were not utilizing 90%+ of their C:\ drives. On my own initiative, I thought there might be a VMware Tools issue with those specific VMs. Of those VMs, some were running an old version of Tools (or none at all). After upgrading or installing Tools, those specific VMs disappeared from the report. Perhaps vROPS 7.0 plays nice with only some versions of Tools? My respective vCenter version is 6.7.1 and most of the Tools upgrades I performed were from version 10287 (10.1.15) to 10338 (10.3.2).

3. After filtering out non-Windows VMs (which wasnt necessary in vROPS 6.7) and upgrading (or installing) Tools on the remaining machines, my report is still listing Windows VMs that are not utilizing 90%+ of the C:\ drives. These machines are actually showing up on the report with dashes in place of actual metrics (just as non-Windows VMs were previously). These remaining Windows VMs are running Tools version 10338 (10.3.2), no upgrades or installations needed. I have restarted to the Tools service on those machines, but no change.

4. Troubleshooting continues with GSS.

[nmanm0305]

This is resolved. Machines that do not have 90% C:\ utilization no longer display on the report.

Root cause was stale VM records in vROPS. When a VM is deleted out of vCenter, vROPS holds onto the object’s shell for 15 days (then purges them automatically). This is notably an issue when VM names are re-used (a stale and active record will exist), which does occur in my environment.

I’ve manually purged the stale VM records and all have cleared from the report. Additionally, I’ve changed the 15-day default to 7.

I explained to GSS that this issue did not exist until we upgraded from vROPS 6.7 to 7.0. I assume 6.7 handled stale records differently (e.g. not forwarding them to reports), but GSS could not confirm that.