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 ROLES

Security Systems by Endpoint Count

Module: Security Systems
Description

Displays endpoint count 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

Security Systems Summary

Module: Security Systems
Description

Displays available security systems.

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT systemkey, systemname FROM securitysystems ORDER BY systemname;
Comments

nan

Security system details

Module: Security Systems
Description

Get Security system details

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT ss.SYSTEMKEY,
ss.SYSTEMNAME,
ss.DISPLAYNAME,
CASE
WHEN ss.STATUS = 1 THEN 'Enabled'
WHEN ss.STATUS = 0 THEN 'Disabled'
ELSE 'Unknown'
END AS SYSTEM_STATUS,
ec.CONNECTIONNAME AS EXTERNAL_CONNECTION_NAME,
pc.CONNECTIONNAME AS PROVISIONING_CONNECTION_NAME,
sdc.CONNECTIONNAME AS SERVICE_DESK_CONNECTION_NAME,
pr.POLICYNAME AS POLICY_RULE_NAME,
prs.POLICYNAME AS POLICY_RULE_SERVICE_ACCOUNT_NAME,
ss.AUTOMATEDPROVISIONING,
ss.INSTANTPROVISION,
ss.DEFAULTSYSTEM,
ss.ACCESSADDWORKFLOW,
ss.ACCESSREMOVEWORKFLOW,
ss.ADDSERVICEACCOUNTWORKFLOW,
ss.REMOVESERVICEACCOUNTWORKFLOW,
ss.FIREFIGHTERIDWORKFLOW,
ss.FFIDREQUESTACCESSWORKFLOW,
u1.USERNAME AS CREATED_BY,
ss.CREATEDATE,
u2.USERNAME AS UPDATED_BY,
ss.UPDATEDATE as UPDATED_DATE,
ss.CREATEDFROM,
ss.ONECLICKIMPORTCONFIG
FROM securitysystems ss
LEFT JOIN users u1
ON u1.USERKEY = ss.CREATEDBY
LEFT JOIN users u2
ON u2.USERKEY = ss.UPDATEDBY
LEFT JOIN policyrule pr
ON ss.POLICYRULE = pr.POLICYRULEKEY
LEFT JOIN policyrule prs
ON ss.POLICYRULESERVICEACCOUNT = prs.POLICYRULEKEY
LEFT JOIN externalconnection ec
ON ss.EXTERNALCONNECTION = ec.EXTERNALCONNECTIONKEY
LEFT JOIN externalconnection pc
ON ss.PROVISIONINGCONNECTION = pc.EXTERNALCONNECTIONKEY
LEFT JOIN externalconnection sdc
ON ss.SERVICEDESKCONNECTION = sdc.EXTERNALCONNECTIONKEY
ORDER BY ss.SYSTEMKEY;
Comments

nan

Provisioning Threshold of Security System

Module: Security Systems
Description

Get the ProvisioningThreshold configured for each Security System

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
select systemkey, systemname, displayname, provlimitjson from securitysystems;
Comments

nan

Query copied!