How to get the number of active keys
Originally Published: 2011-09-09
Last Modified: 2023-09-25
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
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 SOAP Web Service AFX Connectors fail with 'Unable to get the WSDL' error in RSA Identity Governance & Lifecycle Number of Views The number of STX tables in RSA Identity Governance & Lifecycle database is increasing Number of Views Unification fails with ORA-30926: unable to get a stable set of rows in the source tables at 'AVUSER.UNFC_PROCESSOR', line… Number of Views RSA Identity Governance & Lifecycle unification fails with ORA-30926: unable to get a stable set of rows in the source tab… Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
