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 Customers Email History Endpoints Entitlement Values External Connections Job Control Panel Request Access Role Assignments Roles Rules Rulesets Security Systems User Accounts User Group User Groups Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLESExternal Connections by Type
Module: External Connections
Description
Displays external connections grouped by connection type.
Dynamic Input
nan
Execute in
Analytics
SQL Query
SELECT connectiontype, COUNT(*) AS Total_Connections FROM externalconnections GROUP BY connectiontype ORDER BY Total_Connections DESC;
Comments
nan
Recently Updated External Connections
Module: External Connections
Description
Displays recently updated external connections.
Dynamic Input
nan
Execute in
Analytics
SQL Query
SELECT connectionname, updatedate FROM externalconnections ORDER BY updatedate DESC;
Comments
nan
External Connections by Status
Module: External Connections
Description
Displays external connections grouped by status.
Dynamic Input
nan
Execute in
Analytics
SQL Query
SELECT CASE status WHEN 1 THEN 'Successful / Enabled' WHEN 0 THEN 'Failed / Disabled' ELSE CONCAT('Unknown (',status,')') END AS Connection_Status, COUNT(*) AS Total_Connections FROM externalconnections GROUP BY status ORDER BY Total_Connections DESC;
Comments
Verify status semantics if environment separates enable/disable from execution status.
Query copied!