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 ROLESAccess Requests with Confidence Score
Module: Request Access
Description
Displays access requests where confidence score is available.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT request_accesskey, userkey, confidence_score
FROM request_access
WHERE confidence_score IS NOT NULL
ORDER BY confidence_score DESC;
Comments
nan
Access Requests by User
Module: Request Access
Description
Displays total access requests raised by each user.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT userkey, COUNT(*) AS Total_Requests
FROM request_access
GROUP BY userkey
ORDER BY Total_Requests DESC;
Comments
nan
Future Access Requests
Module: Request Access
Description
Displays access requests scheduled for future start date.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT request_accesskey, requestkey, userkey, startdate
FROM request_access
WHERE startdate>CURRENT_DATE()
ORDER BY startdate;
Comments
nan
Expired Access Requests
Module: Request Access
Description
Displays access requests whose end date has passed.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT request_accesskey, requestkey, userkey, enddate
FROM request_access
WHERE enddate IS NOT NULL
AND enddate<CURRENT_DATE()
ORDER BY enddate DESC;
Comments
nan
Recently Submitted Access Requests
Module: Request Access
Description
Displays recently submitted access requests.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT request_accesskey, requestkey, userkey, startdate, enddate
FROM request_access
ORDER BY startdate DESC;
Comments
nan
Request Access by Type
Module: Request Access
Description
Displays request access records grouped by request type.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
CASE requesttype
WHEN 1 THEN 'Add'
WHEN 2 THEN 'Remove'
WHEN 3 THEN 'Update Role'
WHEN 4 THEN 'Remove Role'
WHEN 12 THEN 'Update Account'
WHEN 15 THEN 'Proposed Account Owners'
WHEN 16 THEN 'Modify Organization'
WHEN 17 THEN 'Proposed Entitlement Owners'
WHEN 18 THEN 'Create User'
WHEN 19 THEN 'Update User'
WHEN 20 THEN 'Create Rule'
WHEN 21 THEN 'Update Rule'
WHEN 22 THEN 'Disable Rule'
WHEN 23 THEN 'Modify Privilege'
WHEN 24 THEN 'Firefighter ID'
WHEN 25 THEN 'Firefighter ID Access'
WHEN 26 THEN 'T2P Upload'
ELSE CONCAT('Unknown (',requesttype,')')
END AS Request_Type,
COUNT(*) AS Total_Requests
FROM request_access
GROUP BY requesttype
ORDER BY Total_Requests DESC;
Comments
nan
Request Access by Status
Module: Request Access
Description
Displays request access records grouped by status.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
CASE status
WHEN 1 THEN 'Default'
WHEN 2 THEN 'Approved'
WHEN 3 THEN 'Task Created'
WHEN 4 THEN 'Rejected'
WHEN 5 THEN 'Completed'
WHEN 6 THEN 'After End Date Revoke Task Created'
WHEN 7 THEN 'Task Duration Expired'
ELSE CONCAT('Unknown (',status,')')
END AS Request_Status,
COUNT(*) AS Total_Requests
FROM request_access
GROUP BY status
ORDER BY Total_Requests DESC;
Comments
nan
Query copied!