How to extract Connection with expiry date at once

[Shwet01]

Hi All,

I am trying to extract all connection at with expiry date at once, can someone suggest how to extract. I through query what is table for it. 

Thanks

SS

[dgandhi]

What do you mean by expiry date in the connection? Can you elaborate?

[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