nmanm0305
Enthusiast
Enthusiast

C:\ Utilization Filter Not Working

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.

pastedImage_0.png

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

pastedImage_1.png

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

pastedImage_4.png

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

0 Kudos
10 Replies
RobertMesropyan
VMware Employee
VMware Employee

Hello!

Could you please attach your view's xml?

0 Kudos
nmanm0305
Enthusiast
Enthusiast

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

pastedImage_2.png

pastedImage_1.png

pastedImage_3.png

pastedImage_4.png

0 Kudos
RickVerstegen
Expert
Expert

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.

Blog: https://rickverstegen84.wordpress.com/ Twitter: https://twitter.com/verstegenrick
0 Kudos
RobertMesropyan
VMware Employee
VMware Employee

I would ask you to try export view:

0 Kudos
RobertMesropyan
VMware Employee
VMware Employee

In addition, try to configure all metrics with 'Current' transformation
0 Kudos
nmanm0305
Enthusiast
Enthusiast

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>

0 Kudos
nmanm0305
Enthusiast
Enthusiast

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

pastedImage_0.png

0 Kudos
RobertMesropyan
VMware Employee
VMware Employee

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
0 Kudos
nmanm0305
Enthusiast
Enthusiast

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.

pastedImage_2.pngpastedImage_3.png

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).

pastedImage_4.png

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.

pastedImage_6.png

4. Troubleshooting continues with GSS.

0 Kudos
nmanm0305
Enthusiast
Enthusiast

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.

0 Kudos