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 ROLESUser Count by User Group
Module: User Groups
Description
Displays total users in each user group.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT user_groupkey, COUNT(*) AS Total_Users FROM usergroup_users GROUP BY user_groupkey ORDER BY Total_Users DESC;
Comments
nan
User Groups Summary
Module: User Groups
Description
Displays available user groups.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT usergroupkey, user_groupname FROM user_groups ORDER BY user_groupname;
Comments
nan
Query copied!