ExternalConnection table - need all fields

[anandshahgrange]

From an earlier forum thread I found some fields for the externalConnection table, but I see that the externalConnection table is not exposed in the Data Analyzer.

Ref: https://forums.saviynt.com/t5/identity-governance/fetching-connection-details-from-connections/m-p/6...

Can someone provide me a list of fields of these tables?

• externalconnection
• externalconnectiontype

[sudeshjaiswal · Accepted solution]

Hello @anandshahgrange,

Please find the tables name for the externalconnection and externalconnectiontype below

externalconnection 

EXTERNALCONNECTIONKEY
CONNECTIONDESCRIPTION
CONNECTIONNAME
CONNECTORMS
CREATEDBY
CREATEDON
CREDENTIALCHANGECONFIG
EMAILTEMPLATE
EXTERNALCONNECTIONTYPE
MSCONNECTORVERSION
NODE_MAC_ID
SSLCERTIFICATE
STATUS
STATUSFORENABLEDISABLE
TEMPLATE_MANDATORYDATA
TEMPLATENAME
UPDATEDBY
UPDATEDON
VAULTCONFIG
VAULTCREDENTIALCONNECTION
CONNECTORTYPE

externalconnectiontype 

EXTERNALCONNECTIONTYPEKEY
ATTRIBUTEDESCMAP
ATTRIBUTETYPECONFIG
ATTRIBUTETYPEMAP
ATTRIBUTEKEY
CONNECTIONTYPE
CONNECTORVERSION
DEFAULTJSON
DEFAULTSAVROLE
DYNAMICFIELDS
ENCRYPTEDATTRIBUTES
FFIDCONFIG
HELPJSON
IMAGE_ID
IMPORTPARAMSMAP
IMPORTCONFIG
MANDATORYATTRIBUTES
READONLYTYPE

 Thanks

[anandshahgrange]

Thank you so much, Sudesh.

Can this table be added to the Data Analyzer view?

[sudeshjaiswal]

Hello @anandshahgrange,

No, It cannot be added to dataanalyzer view.

Thanks.

[rushikeshvartak]

Can this be added in documentation ?