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

Recently Created Entitlements

Module: Entitlement Values
Description

Displays recently created entitlements.

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT entitlement_value,createdate,module FROM entitlement_values ORDER BY createdate DESC;
Comments

nan

Entitlements by System Criticality

Module: Entitlement Values
Description

Displays entitlement count grouped by system criticality.

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT CASE sys_critical WHEN 0 THEN 'None' WHEN 1 THEN 'Very Low' WHEN 2 THEN 'Low' WHEN 3 THEN 'Medium' WHEN 4 THEN 'High' WHEN 5 THEN 'Very High' ELSE CONCAT('Unknown (',sys_critical,')') END AS System_Criticality, COUNT(*) AS Total_Entitlements FROM entitlement_values GROUP BY sys_critical ORDER BY Total_Entitlements DESC;
Comments

nan

Entitlements by SOX Criticality

Module: Entitlement Values
Description

Displays entitlement count grouped by SOX criticality.

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT CASE sox_critical WHEN 0 THEN 'None' WHEN 1 THEN 'Very Low' WHEN 2 THEN 'Low' WHEN 3 THEN 'Medium' WHEN 4 THEN 'High' WHEN 5 THEN 'Very High' ELSE CONCAT('Unknown (',sox_critical,')') END AS SOX_Criticality, COUNT(*) AS Total_Entitlements FROM entitlement_values GROUP BY sox_critical ORDER BY Total_Entitlements DESC;
Comments

nan

Entitlements by Risk

Module: Entitlement Values
Description

Displays entitlement count grouped by risk.

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT CASE risk WHEN 0 THEN 'None' WHEN 1 THEN 'Very Low' WHEN 2 THEN 'Low' WHEN 3 THEN 'Medium' WHEN 4 THEN 'High' WHEN 5 THEN 'Very High' ELSE CONCAT('Unknown (',risk,')') END AS Risk_Level, COUNT(*) AS Total_Entitlements FROM entitlement_values GROUP BY risk ORDER BY Total_Entitlements DESC;
Comments

nan

Entitlements by Status

Module: Entitlement Values
Description

Displays entitlement count grouped by status.

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT CASE status WHEN 1 THEN 'Active' WHEN 2 THEN 'Inactive' WHEN 3 THEN 'Decommission Active' WHEN 4 THEN 'Decommission Inactive' WHEN 5 THEN 'Deleted' ELSE CONCAT('Unknown (',status,')') END AS Entitlement_Status, COUNT(*) AS Total_Entitlements FROM entitlement_values GROUP BY status ORDER BY Total_Entitlements DESC;
Comments

nan

Query copied!