How to get the number of active keys
Originally Published: 2011-09-09
Article Number
Applies To
Issue
Resolution
For SQL Server
select count(*)
from security_object so, state_timeline st
where so.muid = st.muid
and starttime / 1000 < DATEDIFF(s,'19700101 00:00:00:000',GETUTCDATE())
and endtime / 1000 > DATEDIFF(s,'19700101 00:00:00:000',GETUTCDATE())
and destroytime / 1000 > DATEDIFF(s,'19700101 00:00:00:000',GETUTCDATE())
and compromisetime / 1000 > DATEDIFF(s,'19700101 00:00:00:000',GETUTCDATE())
Related Articles
The number of STX tables in RSA Identity Governance & Lifecycle database is increasing Number of Views SOAP Web Service AFX Connectors fail with 'Unable to get the WSDL' error in RSA Identity Governance & Lifecycle Number of Views How to convert the date field number from a request form to a human readable date in RSA Via Lifecycle and Governance Number of Views How to modify the number of allowable active tokens per user on RSA Authentication Manager 8.x Number of Views 'Number of Missing Required Entitlements' under Role Analytics is not updated after completing Change Requests that succes… Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA Authentication Manager 8.9 Patches and Hotfixes Readme Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
