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!
In PSQL I am not sure, but it is easy with snmpv3 gets.
Poll the License Strategies Table (.rsa.ims.strategyTable)
.1.3.6.1.4.1.2197.20.20 shows this table including max possible users on license [not actual users].
.1.3.6.1.4.1.2197.30.5.1 would give the total current active users (all active users = tokens+oda+rba)