Modules

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

SELECT rolekey,userkey,accountkey,enddate FROM role_user_account WHERE enddate BETWEEN CURRENT_DATE() AND DATE_ADD(CURRENT_DATE(),INTERVAL 30 DAY) ORDER BY enddate;
                    

SELECT rolekey,userkey,accountkey,enddate FROM role_user_account WHERE enddate IS NOT NULL AND enddate<CURRENT_DATE() ORDER BY enddate DESC;
                    

SELECT source, COUNT(*) AS Total_Assignments FROM role_user_account GROUP BY source ORDER BY Total_Assignments DESC;