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 ROLESEndpoints with Parent Endpoint
Module: Endpoints
Description
Displays endpoints configured with a parent endpoint.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT endpointname,parentendpointkey FROM endpoints WHERE parentendpointkey IS NOT NULL;
Comments
nan
Endpoints by Request Owner Type
Module: Endpoints
Description
Displays endpoints grouped by request owner type.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT requestownertype, COUNT(*) AS Total_Endpoints FROM endpoints GROUP BY requestownertype ORDER BY Total_Endpoints DESC;
Comments
nan
Endpoints by Security System
Module: Endpoints
Description
Displays endpoints grouped by security system.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT securitysystemkey, COUNT(*) AS Total_Endpoints FROM endpoints GROUP BY securitysystemkey ORDER BY Total_Endpoints DESC;
Comments
nan
Recently Imported Endpoints
Module: Endpoints
Description
Displays endpoints ordered by last import date.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT endpointname,lastimport FROM endpoints WHERE lastimport IS NOT NULL ORDER BY lastimport DESC;
Comments
nan
Endpoints by Owner Type
Module: Endpoints
Description
Displays endpoints grouped by owner type.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT CASE ownertype WHEN 1 THEN 'User' WHEN 2 THEN 'User Group' ELSE CONCAT('Unknown (',ownertype,')') END AS Owner_Type, COUNT(*) AS Total_Endpoints FROM endpoints GROUP BY ownertype ORDER BY Total_Endpoints DESC;
Comments
nan
Endpoints Details
Module: Endpoints
Description
Get Endpoint details
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
e.endpointkey,
e.endpointname,
e.displayName,
e.description,
ss.systemname,
CASE
WHEN e.status=0 THEN 'Disabled'
WHEN e.status=1 THEN 'Enabled'
ELSE 'Unknown'
END AS STATUS,
e.accessquery,
e.accountTypeForServiceAccount,
e.disableaccountrequest,
e.createDate,
uc.username AS Created_By,
e.endpointConfig,
e.requestowner,
e.serviceAccountAccessQuery,
e.updateDate,
uu.username AS Updated_By,
e.createdFrom,
e.lastImport
FROM endpoints e
LEFT JOIN securitysystems ss
ON e.securitysystemkey = ss.systemkey
LEFT JOIN users uc
ON e.createdBy = uc.userkey
LEFT JOIN users uu
ON e.updatedBy = uu.userkey
ORDER BY e.endpointkey;
Comments
nan
Query copied!