SQL Get Total Amount of Authentication Licenses
Hi, we found previously a query to get count of the amount of used licenses:
select count (distinct loginuid) from rsa_rep.ims_principal_data join am_token on am_token.principal_id = ims_principal_data.id where authenticator_bit_flags is not null)
but is there a query from a table somewhere from the AM db that lists the license limit in the AM instance?:
AFAIK....Not really in the database like that, as that value is calculated from various tables.
(someone may chime in with the answer but I don't know it yet)
However you can get the max limit count using SNMP gets on these OID's
(this is an snmp table "License Strategies Table")
My license, is 1 million user with tokens, and 1 million RBA/On-demand.
In the MIB is a table .18.104.22.168.4.1.2197.20.20
SNMPv2-SMI::enterprises.222.214.171.124.7.2 = STRING: "1000000" (users with assigned authenticators)
SNMPv2-SMI::enterprises.2126.96.36.199.7.8 = STRING: "1000000" (RBA/ODA authenticators)