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 ROLESUsers created in last two days
Module: Users
Description
Get all users created in the last two days
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
select userkey, username,createdate, email FROM users
WHERE createdate >= NOW() - INTERVAL 2 DAY;
Comments
nan
Users with more than One Account
Module: Users
Description
Get the list of Users having more than one account
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
u.userkey,
u.username,
CASE
WHEN statuskey = 0 THEN 'Inactive'
WHEN statuskey = 1 THEN 'Active'
ELSE 'Unknown'
END AS User_Status,
a.accountkey,
a.name AS account_name,
CASE
WHEN a.status = 1 THEN 'Active'
WHEN a.status = 2 THEN 'Inactive'
WHEN a.status = 3 THEN 'Decommission Active'
WHEN a.status = 4 THEN 'Decommission Inactive'
WHEN a.status = 'Manually Provisioned' THEN 'Manually Provisioned'
WHEN a.status = 'Manually Suspended' THEN 'Manually Suspended'
WHEN a.status = 'SUSPENDED FROM IMPORT SERVICE' THEN 'Deleted'
ELSE a.status
END AS Account_Status,
e.endpointname
FROM users u
JOIN user_accounts ua
ON u.userkey = ua.userkey
JOIN accounts a
ON ua.accountkey = a.accountkey
JOIN endpoints e
ON a.endpointkey = e.endpointkey
WHERE u.userkey IN (
SELECT userkey
FROM user_accounts
GROUP BY userkey
HAVING COUNT(accountkey) > 1
)
ORDER BY u.username;
Comments
nan
Users updated since a particular date
Module: Users
Description
Get the list of Users updated since a particular date
Dynamic Input
Date
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
userkey,
username,
CASE
WHEN statuskey = 0 THEN 'Inactive'
WHEN statuskey = 1 THEN 'Active'
ELSE 'Unknown'
END AS User_Status,
CONVERT_TZ(savupdatedate, 'UTC', 'Asia/Kolkata') AS savupdatedate_ist
FROM users
WHERE savupdatedate > '2025-11-21 15:30:00.0'
ORDER BY savupdatedate DESC;
Comments
nan
Users created since a particular date
Module: Users
Description
Get the list of Users created since a particular date
Dynamic Input
Date
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
userkey,
username,
CASE
WHEN statuskey = 0 THEN 'Inactive'
WHEN statuskey = 1 THEN 'Active'
ELSE 'Unknown'
END AS User_Status,
CONVERT_TZ(createdate, 'UTC', 'Asia/Kolkata') AS createdate_ist
FROM users
WHERE createdate > '2025-11-21 15:30:00.0'
ORDER BY createdate DESC;
Comments
nan
Users with Inactive Managers
Module: Users
Description
Get the list of users whose Manager is Inactive.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
U.USERNAME AS USER_NAME,
M.USERNAME AS MANAGER_NAME,
U.STATUSKEY AS USER_STATUS,
M.STATUSKEY AS MANAGER_STATUS
FROM USERS U
JOIN USERS M
ON U.MANAGER = M.USERKEY
WHERE M.STATUSKEY IN (0, '0', 'Inactive');
Comments
nan
Users with Managers
Module: Users
Description
Get the list of users with Manager.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
u.username AS USER_NAME,
m.username AS MANAGER_NAME
FROM users u
JOIN users m
ON u.manager = m.userkey
WHERE u.manager IS NOT NULL AND m.statuskey IN (1, '1', 'Active');
Comments
nan
Users with NO Managers
Module: Users
Description
Get the list of users with no Manager.
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT USERNAME FROM users WHERE MANAGER IS NULL OR MANAGER = '';
Comments
nan
Count of Active and Inactive Users
Module: Users
Description
Get the total count of active and inactive users, grouped by statuskey (print statuskey, count(*))
Dynamic Input
nan
Execute in
Data Analyzer, Analytics
SQL Query
SELECT
statuskey,
CASE
WHEN statuskey = 0 THEN 'Inactive'
WHEN statuskey = 1 THEN 'Active'
ELSE 'Unknown'
END AS Status,
COUNT(*) AS Count
FROM users
GROUP BY statuskey;
Comments
nan
Query copied!