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
Is it possible to modify the PIN of an nCipher Admin Card Set card? Number of Views Is it possible to disable the protected URL cache? Number of Views Is it possible to deploy software token 3.0 to a Blackberry with content protection enabled? Number of Views Is it possible to use custom revoked / suspended certificate reasons in RSA Certificate Manager? Number of Views SQL Query to obtain directly assigned entitlements for a user Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide User Application Portal The RSA Identity Governance & Lifecycle AD Collector and AD ADC authentication source fail to establish a TLS 1.2 SSL conn… RSA Authentication Manager 8.1 Quick Setup Fails with "Failed to Attach Replica Instance" How to Replace the Web Server Certificate for the RSA Identity Governance & Lifecycle Web Console
Don't see what you're looking for?
