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
RSA Identity Governance and Lifecycle Review Details link ($reviewDetailURL) in Reviewer Email gets "The request could not… 78Number of Views How to get the Apache Tomcat version on an RSA enVision appliance 34Number of Views Is it possible to deploy software token 3.0 to a Blackberry with content protection enabled? 10Number of Views Is it possible to generate a PASSCODE on an Ericsson R380 telephone without a SIM card inserted? 5Number of Views Is it possible to modify the PIN of an nCipher Admin Card Set card? 5Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?