Query on SSl Certificate

[Sushma]

Hi All,

Can you please let me know, how to extract list of certificates tagged to respective connections/query to merge certificate list table with externalconnection table?

[rushikeshvartak]

SELECT E.CONNECTIONNAME,
       S.ALIAS,
       S.VALID_FROM,
       S.VALID_TO AS certificate_expiry
FROM   EXTERNALCONNECTION E,
       SAV_SSLCERT S
WHERE  S.CERT_KEY = E.SSLCERTIFICATE
       AND E.SSLCERTIFICATE IS NOT NULL