Hello!
Is there a table in the database that lists the AVAILABLE license count, NOT the licensed users? (I've read the KB on the accurate active license count here:000030005 - How to get an accurate active user license count in RSA Authentication Manager 8.1 using SQL )
We are looking to connect our database to Tableau for metrics reporting, and would like to display an "available licenses vs licensed users" count on that dashboard. I've figured out how to query all of the other metrics we'd like, except for this available license count field - (if it's even available).
So any help would be appreciated!
You're very welcome, Tiffany! Just one wrinkle I have since found... I've just implemented this in our production Auth Mgr instance, only to find that the OID with the license count is .1.3.6.1.4.1.2197.20.24.1.2.527, not .1.3.6.1.4.1.2197.20.24.1.2.526! So the OID for license consumption is clearly a 'movable feast', so you'll either need an 'if... else' clause in your code to select the correct OID depending on whether you're running your script in your Prod or Dev environment, or else run the following command:
snmpwalk -v 3 -u {user name} -l {security level} -a {authentication protocol} -A {authentication password} -x {privacy protocol} -X {privacy password} {hostname}.1.3.6.1.4.1.2197 | grep ims.license.active_user_count
This returns something like:
SNMPv2-SMI::enterprises.2197.20.24.1.1.527 = STRING: "ims.license.active_user_count"
The last number in the partial OID shows you where to look for the license count, in this case it will be .1.3.6.1.4.1.2197.20.24.1.2.527 (because of the final 527 in the output above).