User 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!