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 Endpoints Job Control Panel Roles Rules Security Systems User Group Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLESUser Group Details
Module: User Group
Description
Get all the users and accounts of all User Groups.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
ug.user_groupname,
u.username as 'Users',
a.name as 'Accounts',
a.accountkey
FROM user_groups ug
LEFT JOIN usergroup_users ugu
ON ug.usergroupkey = ugu.user_groupkey
LEFT JOIN users u
ON ugu.userkey = u.userkey
LEFT JOIN user_accounts ua
ON u.userkey = ua.userkey
LEFT JOIN accounts a
ON ua.accountkey = a.accountkey
ORDER BY ug.user_groupname,
u.username,
a.name;
Comments
nan
Count of Users and Accounts in UserGroup
Module: User Group
Description
Get all the count of users and accounts of all User Groups
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
ug.user_groupname as 'User Group Name',
count(distinct u.userkey) as 'Total Users in User Group',
count(distinct a.accountkey) as 'Total Accounts Owned by User Group'
FROM user_groups ug
LEFT JOIN usergroup_users ugu
ON ug.usergroupkey = ugu.user_groupkey
LEFT JOIN users u
ON ugu.userkey = u.userkey
LEFT JOIN user_accounts ua
ON u.userkey = ua.userkey
LEFT JOIN accounts a
ON ua.accountkey = a.accountkey
GROUP BY ug.usergroupkey,
ug.user_groupname
ORDER BY ug.user_groupname;
Comments
nan
Query copied!