1

How To: SQL Query to retrieve list of disabled certificates

How To:

These sample queries will have the certificate details of all disabled certificate objects in Director / TrustAuthority

 

Microsoft SQL

SELECT * FROM store_associations WHERE VaultID IN
(SELECT CAST(AttributeValue AS INT)
FROM config_contains
WHERE GUID IN
(SELECT GUID FROM config_contains
WHERE Attribute = 'Disabled' AND AttributeValue = '1')
AND Attribute = 'Certificate Vault ID')

 

Oracle

SELECT * FROM DIRECTOR.store_associations WHERE VaultID IN
(SELECT CAST(AttributeValue AS Integer)
FROM director.config_contains
WHERE GUID IN
(SELECT GUID FROM director.config_contains
WHERE Attributename = 'Disabled' AND AttributeValue = '1')
AND Attributename = 'Certificate Vault Id');

 

Interpreting the data

Name: This column distinguishes the type of data.  Example: CN will show the common name of the certificate

ValueString: This will show the actual data for the row.

VaultID: This is the unique number assigned to the certificate in the database

1 comment

Please sign in to leave a comment.