Take Connection backup from analytics

[Diwakar]

I can get the required connection details from below analytics query; however, I am not getting filter option with connectionname. Please help to add connectionname in filter.

'select * from externalconnattvalue where connectiontype in (select EXTERNALCONNECTIONKEY from externalconnection where EXTERNALCONNECTIONTYPE in (select EXTERNALCONNECTIONTYPEKEY from externalconnectiontype where connectiontype like '%DB%' and connectionname='SaviyntforSaviynt'))'

Filter currently showing in analytics.

Thanks,

Diwakar.

[rushikeshvartak · Accepted solution]

SELECT ec.connectionname,
       ec.connectiondescription,
       ec.emailtemplate,
       ec.status AS CONN_STATUS,
       ec.statusforenabledisable,
       ecav.attributekey,
       ecav.attributevalue,
       ecav.formdata
FROM   externalconnattvalue ecav
       INNER JOIN externalconnection ec
               ON ecav.connectiontype = ec.externalconnectionkey
       INNER JOIN externalconnectiontype ect
               ON ec.externalconnectiontype = ect.externalconnectiontypekey
WHERE  ect.connectiontype IN ( 'DB' )
       AND ec.connectionname = 'SaviyntforSaviynt'

[Diwakar]

Thank you so much Rushi. It worked for my requirement.