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
Don't see what you're looking for?
