Internal documentation only
This page has been marked as draft.
How to filter ADS mounts for a specific Application Key
Presented with the following dataview I want to filter for a specific Application Key (let’s say 256) for all mounts across all managed entities.
Option 1 - Active Console - Use Filter Table Option
Right-click on the Dataview on any cell and choose Filter Table option.
Result:
Note: This will only apply to this specific data view (not other entities with the same name) and it does not persist meaning if you click into another entity and then return to this view the filter will no longer be present.
Option 2 - Active Console - Use Metric Overview
From the Active Console menu choose Tools, Metrics Overview. A Metrics Overview dialog box will appear. Change Dataview Attribute to Name, and then use the scrollbar to locate your dataview (ads mounts). Ensure the Limit on current state tree selection checkbox is unticked.
Right-click the dataview below on any cell and choose Filter Table option.
Note: This view is persistent and would include all managed entities that contain the ads mounts dataview.
Option 3 - Gateway SQL
The RTDS Integration XML templates contained Gateway SQL samplers which aggregate dataviews.
https://docs.itrsgroup.com/docs/geneos/current/collection/refinitiv-rtds/index.html
Create a Gateway SQL Sampler.
Under Tables, create a table name called mounts (Example below)
<xpath>
<tableName>
<data>mounts</data>
</tableName>
<xpaths>
<xpath>/geneos/gateway/directory/probe/managedEntity/sampler/dataview[wild(@name,"* Mounts")]/rows/row/cell[(@column="user")]</xpath>
</xpaths>
<columns>
<column>
<name>
<data>host</data>
</name>
<xpath>ancestor::managedEntity/@name</xpath>
</column>
<column>
<name>
<data>user</data>
</name>
<xpath>@value</xpath>
</column>
<column>
<name>
<data>mount</data>
</name>
<xpath>@rowname</xpath>
</column>
<column>
<name>
<data>mountTime</data>
</name>
<xpath>../cell[(@column="mountTime")]</xpath>
</column>
<column>
<name>
<data>applicationKey</data>
</name>
<xpath>../cell[(@column="applicationKey")]</xpath>
</column>
<column>
<name>
<data>position</data>
</name>
<xpath>../cell[(@column="position")]</xpath>
</column>
<column>
<name>
<data>items</data>
</name>
<xpath>../cell[(@column="items")]</xpath>
<type>INTEGER</type>
</column>
<column>
<name>
<data>stale</data>
</name>
<xpath>../cell[(@column="stale")]</xpath>
<type>INTEGER</type>
</column>
<column>
<name>
<data>pendingOut</data>
</name>
<xpath>../cell[(@column="pendingOut")]</xpath>
<type>INTEGER</type>
</column>
<column>
<name>
<data>nonRecoverableOpens</data>
</name>
<xpath>../cell[(@column="nonRecoverableOpens")]</xpath>
<type>INTEGER</type>
</column>
<column>
<name>
<data>version</data>
</name>
<xpath>../cell[(@column="version")]</xpath>
</column>
</columns>
</xpath>
Under Views, create a view called mounts.
Ensure that all the labels match the column names in your ads mounts view. The key thing is to add your filter here so for example if you want to only display applicationKey values that are 265 the below code would suffice.
Result
Note this is only on a per Gateway basis (unlike the Metric Overview).