Graphing Cisco AnyConnect Client Versions

Question

All:  I can't seem to figure out how to do this:

I'm trying to create a graph that will allow me to track the number of AnyConnect clients that connect to my firewall by Version (E.G. Windows, Mac and Linux).  I have found that this info is exposed via Cisco's CISCO-REMOTE-ACCESS-MONITOR-MIB.  It seems the OID is: 1.3.6.1.4.1.9.9.392.1.3.21.1.18 for the information I'm looking for.  The first problem I'm having is that it appears that the Firewall generates two sub OIDs for each client each has the info I want, but each has it listed as slightly different text.

I was able to build a poller on that OID and it creates a chart on the Device's web page. The chart doesn't actually aggregate the data.  The graph in the Chart doesn't show any data either.  So I'm not sure what I'm doing wrong or if this type of data can even be graphed.

It appears that Cisco is trying to fit relational data in to what is essentially a hierarchal database format (SNMP).

Does anyone have any experience doing this?  Can it be done ?  Any help would be most appreciated.

Thanks!

Dave

lambchopper · Answer

Orion support helped me to build an Advanced SQL report based on the following SQL code that helped me to generate the report data needed.  We couldn't create a graph, but were able to aggregate the numbers of client versions we were looking for.

SELECT   n.NodeID, n.Caption as Node, cps.Status as Version, COUNT(cps.Status) as [Count]

FROM CustomPollers cp JOIN CustomPollerAssignment cpa ON (cp.CustomPollerID=cpa.CustomPollerID)

JOIN CustomPollerStatus cps ON (cpa.CustomPollerAssignmentID=cps.CustomPollerAssignmentID)

JOIN Nodes n ON (n.NodeID=cpa.NodeID)

WHERE cp.UniqueName='crasClientVersionString' AND cps.Status NOT LIKE ''

GROUP BY  n.NodeID, n.Caption, cps.Status

ORDER BY n.Caption, cps.Status, COUNT(cps.Status)