Modules

Browse queries by module.

All Modules

ARS Requests ARS Tasks Accounts Accounts, Endpoint Accounts, Endpoints Analytics Audit Logs Audit Trail Campaign Certification Connections Connections, Job Control Panel Endpoints Job Control Panel Roles Rules Security Systems User Group Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLES

All Active Connection Details

Module: Connections
Description

Get the details of all active connections.

Dynamic Input

nan

Execute in

Analytics

SQL Query 
SELECT
exc.connectionname,
exc.connectiondescription,
ext.connectiontype,
sr.rolename,
exc.emailtemplate,
CASE
exc.statusforenabledisable when 1 then 'Enable'
when 0 then 'Disable'
END AS C_Status,exc.updatedon as LastUpdated,
CASE
exc.status when 1 then 'Successful'
when 0 then 'Failed'
END AS Connection_Status,
xcv.attributekey,
xcv.attributevalue
FROM externalconnectiontype ext
INNER JOIN externalconnection exc
ON ext.externalconnectiontypekey=exc.externalconnectiontype
INNER JOIN externalconnattvalue xcv
ON exc.externalconnectionkey=xcv.connectiontype
INNER JOIN savroles sr
ON ext.defaultsavrole=sr.rolekey
WHERE exc.statusforenabledisable='1';
Comments

nan

Connections Details

Module: Connections
Description

Get details of all the connections in analytics

Dynamic Input

nan

Execute in

Analytics

SQL Query 
SELECT ec.externalconnectionkey,
ec.connectiondescription,
ec.connectionname,
ect.connectiontype,
ec.connectorms,
ec.createdby,
ec.createdon,
ec.credentialchangeconfig,
ec.emailtemplate,
ec.externalconnectiontype,
ec.msconnectorversion,
ec.node_mac_id,
ec.sslcertificate,
ec.status AS stat,
ec.statusforenabledisable AS stat_enable_disable,
ec.template_mandatorydata,
ec.templatename,
ec.updatedby,
ec.updatedon,
ec.vaultconfig,
ec.vaultcredentialconnection,
ec.connectortype
FROM externalconnection ec
JOIN externalconnectiontype ect
ON ec.externalconnectiontype = ect.externalconnectiontypekey;
Comments

nan

Email Template configured for Connections

Module: Connections
Description

For all Connections, see whether Email Template is configured or not

Dynamic Input

nan

Execute in

Analytics

SQL Query 
SELECT ec.externalconnectionkey,
ec.connectionname,
ect.connectiontype,
CASE
WHEN emailtemplate IS NOT NULL THEN ‘TRUE’
ELSE 'FALSE'
END AS CONTAINS_EMAIL,
ec.connectiondescription,
ec.connectorms,
ec.emailtemplate,
ec.externalconnectiontype,
ec.status AS stat,
ec.statusforenabledisable AS stat_enable_disable,
ec.template_mandatorydata,
ec.templatename,
ec.connectortype
FROM externalconnection ec
JOIN externalconnectiontype ect
ON ec.externalconnectiontype = ect.externalconnectiontypekey;
Comments

nan

Connections JSON- STATUS_THRESHOLD_CONFIG

Module: Connections
Description

For AD Connections get what is JSON configured under Status Threshold Config

Dynamic Input

Connection Name or the Connection Key

Execute in

Analytics

SQL Query 
SELECT exc.connectionname,
ext.connectiontype,
xcv.attributekey,
xcv.attributevalue
FROM externalconnectiontype ext
INNER JOIN externalconnection exc
ON ext.externalconnectiontypekey = exc.externalconnectiontype
INNER JOIN externalconnattvalue xcv
ON exc.externalconnectionkey = xcv.connectiontype
WHERE ( exc.connectionname LIKE '%Gallagher%' OR exc.externalconnectionkey = 27)
AND xcv.attributekey = 'STATUS_THRESHOLD_CONFIG';
Comments

nan

Connections JSON- ACCOUNT_ATTRIBUTE

Module: Connections
Description

For AD Connections get what is JSON configured under ACCOUNT_ATTRIBUTE

Dynamic Input

Connection Name or the Connection Key

Execute in

Analytics

SQL Query 
SELECT exc.connectionname,
ext.connectiontype,
xcv.attributekey,
xcv.attributevalue
FROM externalconnectiontype ext
INNER JOIN externalconnection exc
ON ext.externalconnectiontypekey = exc.externalconnectiontype
INNER JOIN externalconnattvalue xcv
ON exc.externalconnectionkey = xcv.connectiontype
WHERE ( exc.connectionname LIKE '%ADconnection1%' OR exc.externalconnectionkey = 15)
AND xcv.attributekey = 'ACCOUNT_ATTRIBUTE';
Comments

nan

Connections JSON- groupimportmapping

Module: Connections
Description

For AD Connections get what is JSON configured under Group Import Mapping

Dynamic Input

Connection Name or the Connection Key

Execute in

Analytics

SQL Query 
SELECT exc.connectionname,
ext.connectiontype,
xcv.attributekey,
xcv.attributevalue
FROM externalconnectiontype ext
INNER JOIN externalconnection exc
ON ext.externalconnectiontypekey = exc.externalconnectiontype
INNER JOIN externalconnattvalue xcv
ON exc.externalconnectionkey = xcv.connectiontype
WHERE ( exc.connectionname LIKE '%ADconnection1%' OR exc.externalconnectionkey = 15)
AND xcv.attributekey = 'groupimportmapping';
Comments

nan

Query copied!