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 ROLESRecently Certified Accounts
Module: User Accounts
Description
Displays role-user assignments recently certified.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT accountkey,userkey,lastcertifiedcampaignname,lastcertifiedcampaigndate
FROM role_user_account
WHERE lastcertifiedcampaigndate IS NOT NULL
ORDER BY lastcertifiedcampaigndate DESC;
Comments
nan
Users with Single Account
Module: User Accounts
Description
Displays users having exactly one correlated account.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT userkey,
COUNT(*) AS Account_Count
FROM user_accounts
GROUP BY userkey
HAVING COUNT(*)=1;
Comments
nan
Accounts linked to Multiple Users
Module: User Accounts
Description
Displays accounts correlated to multiple users.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT accountkey,
COUNT(*) AS User_Count
FROM user_accounts
GROUP BY accountkey
HAVING COUNT(*)>1
ORDER BY User_Count DESC;
Comments
nan
Users with Multiple Accounts
Module: User Accounts
Description
Displays users having more than one correlated account.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT userkey,
COUNT(*) AS Account_Count
FROM user_accounts
GROUP BY userkey
HAVING COUNT(*)>1
ORDER BY Account_Count DESC;
Comments
nan
Users without Accounts
Module: User Accounts
Description
Displays users that do not have any correlated accounts.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT u.userkey, u.username
FROM users u
LEFT JOIN user_accounts ua ON u.userkey=ua.userkey
WHERE ua.accountkey IS NULL;
Comments
nan
Query copied!