This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Export certificates list

Is there any way to export or print the list of certificates under Keys and Certificates > Assigned Certificates > (Search) ?

This thread was automatically locked due to age.

0 ChrisD over 11 years ago

Hey ttl,

there is currently no export function for the list of assigned user certificates available.

As an alternative, I created a sql select statement that shoud fully represent the Management Center view.

Cheers,

Chris

USE SafeGuard
SELECT
[CERTIFICATES].[CRT_SUBJECT] as 'Subject',
[CERTIFICATES].[CRT_ISSUER] as 'Issuer',
[CERTIFICATES].[CRT_SERIAL] as 'Serial',
[CERTIFICATES].[CRT_MODIFIED_BY] as 'Modified by',
[CERTIFICATES].[CRT_CREATED_BY] as 'Created by',
[CERTIFICATES].[CRT_EXPIRY] as 'Expires',
[CERTIFICATES].[CRT_SGN_STATE] as 'State',
[CERTIFICATES].[CRT_PROLONG] as 'Renew',
[CERTIFICATES_ASSIGN].[CAS_TYPE] as 'Standby'
FROM [CERTIFICATES], [CERTIFICATES_ASSIGN]
WHERE [CERTIFICATES].[CRT_ID] = [CERTIFICATES_ASSIGN].[CAS_CRT_ID]
ORDER BY [CERTIFICATES].[CRT_SUBJECT]