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
SOAP Web Service AFX Connectors fail with 'Unable to get the WSDL' error in RSA Identity Governance & Lifecycle Number of Views RSA Identity Governance and Lifecycle MigrationReports.zip fails to install Migration Reports with ORA-04063: package body… Number of Views Overview of steps to move Authentication Manager 8.1 production data to VMware ESX 6.0 Number of Views RSA Authentication Manager as a Secure Proxy Server for RSA Cloud Access Service Number of Views Where can I find my Partner Site ID if I am an RSA SecurWorld Partner? Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device How to Download OTP Token Seed Files from myRSA Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
