We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Fetching connection details from connections

Kaushik1
New Contributor
New Contributor

Hi Team,

We have a requirement to view the threshold value mentioned in all the connections created till date. There are 300 + connections. Is there any way (any table/ column) which will be able to extract the threshold value from all the connection in one go. We tried checking the same on data analyzer but no such column exists.

Regards,

Anshita

1 REPLY 1

rushikeshvartak
All-Star
All-Star

If below does not work from data analyzer , please create analytics report

 

select t.connectiontype,c.CONNECTIONNAME,
ec.attributekey as 'Attribute',ec.attributevalue from endpoints e,securitysystems s,externalconnection c,externalconnectiontype t,externalconnattvalue ec where e.securitysystemkey=s.systemkey and s.externalconnection=c.externalconnectionkey and c.externalconnectiontype =t.externalconnectiontypekey and e.status=1 and s.status=1 and c.status=1 and ec.connectiontype=c.EXTERNALCONNECTIONKEY
and length(ec.attributevalue)!=0 and ec.attributekey='STATUS_THRESHOLD_CONFIG​'

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.