Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Take Connection backup from analytics

Diwakar
Regular Contributor
Regular Contributor

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.

Diwakar_0-1724055141268.png

Thanks,

Diwakar.

 

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

 

 

rushikeshvartak_0-1724057748620.png

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'

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

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