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 ROLESActionable Analytics- Reopen Task
Actionable Analytics to reopen a closed task for re-execution (Reopens discontinued task with provisioning tasks greater than one)
nan
Analytics
SELECT
taskkey as tasks,
STATUS as Status_Key,
provisioningtries,
'reopenTasks' as 'Default_Action_For_Analytics'
FROM arstasks
WHERE status=4
and PROVISIONINGTRIES>1;
nan
Actionable Analytics- Deprovision Role (All Roles of a User)
Actionable Analytics to deprovision all role access of specific User
User Key, Role Key
Analytics
SELECT
r.ROLE_NAME,
u.username as name,
rua.ROLEKEY as roleKey,
rua.ACCOUNTKEY as acctKey,
a.name as Account_Name,
u.USERKEY as userKey,
'Deprovision Role' as 'Default_Action_For_Analytics'
FROM role_user_account rua
JOIN user_accounts ua
ON ua.ACCOUNTKEY=rua.ACCOUNTKEY
JOIN accounts a
ON a.ACCOUNTKEY=ua.ACCOUNTKEY
JOIN users u
ON u.USERKEY = ua.USERKEY
JOIN roles r
ON r.ROLEKEY = rua.ROLEKEY
WHERE r.STATUS=1
and u.userkey = 2520;
nan
Actionable Analytics- Deprovision Role (Specific Role of User)
Actionable Analytics to deprovision specific role access of specific User
User Key, Role Key
Analytics
SELECT
r.ROLE_NAME,
u.username as name,
rua.ROLEKEY as roleKey,
rua.ACCOUNTKEY as acctKey,
a.name as Account_Name,
u.USERKEY as userKey,
'Deprovision Role' as 'Default_Action_For_Analytics'
FROM role_user_account rua
JOIN user_accounts ua
ON ua.ACCOUNTKEY=rua.ACCOUNTKEY
JOIN accounts a
ON a.ACCOUNTKEY=ua.ACCOUNTKEY
JOIN users u
ON u.USERKEY = ua.USERKEY
JOIN roles r
ON r.ROLEKEY = rua.ROLEKEY
WHERE r.STATUS=1
and r.rolekey=1
and u.userkey = 2520;
nan
Actionable Analytics- Provision Role
Actionable Analytics to provision a role specific User
User Key, Role Key
Analytics
SELECT
r.ROLE_NAME,
u.username as name,
r.ROLEKEY as rolekey,
u.USERKEY as userkey,
'Provision Role' as 'Default_Action_For_Analytics'
FROM roles r,
users u
WHERE userkey =2520
and rolekey in (4);
nan
Actionable Analytics- Disable Account
Actionable Analytics to disable a specific User Account
Account Key
Analytics
SELECT
a.name,
a.accountkey as acctKey,
endpointkey,
'disableAccount' as Default_Action_For_Analytics
FROM accounts a
WHERE a.accountkey=7872;
nan
Actionable Analytics- Enable Account
Actionable Analytics to enable a specific User Account
Account Key
Analytics
SELECT
a.name,
a.accountkey as acctKey,
endpointkey,
'enableAccount' as Default_Action_For_Analytics
FROM accounts a
WHERE a.accountkey=7872;
nan
Actionable Analytics- Deprovision access
Actionable Analytics to deprovision access to a specific entitlement of an Endpoint for a User Account
Endpoint Key, Account Name, Entitlement Value Key
Analytics
select
ev.entitlement_valuekey as entvaluekey,
a.accountkey as acctKey,
a.name as accName,
u.userKey,
'Deprovision Access' as Default_Action_For_Analytics
from entitlement_values ev,
entitlement_types et,
accounts a,
user_accounts u
where ev.entitlementtypekey=et.entitlementtypekey
and et.endpointkey=6
and a.name= 'abc'
and ev.entitlement_valuekey= 190884
and u.ACCOUNTKEY=a.ACCOUNTKEY;
nan
Actionable Analytics- Provision access
Actionable Analytics to provision access to a specific entitlement of an Endpoint for a User Account
Endpoint Key, Account Name, Entitlement Value Key
Analytics
select
ev.entitlement_valuekey as entvaluekey,
a.accountkey as acctKey,
a.name as accName,
u.userKey,
'Provision Access' as Default_Action_For_Analytics
from entitlement_values ev,
entitlement_types et,
accounts a,
user_accounts u
where ev.entitlementtypekey=et.entitlementtypekey
and et.endpointkey=6
and a.name= 'abc'
and ev.entitlement_valuekey= 190884
and u.ACCOUNTKEY=a.ACCOUNTKEY;
nan
Actionable Analytics- Deprovision Account
Actionable Analytics to deprovision specific User Account in an Endpoint
Endpoint Key, Account Name
Analytics
SELECT
a.name,
a.accountkey as acctKey,
endpointkey,
'deprovisionAccount ' as Default_Action_For_Analytics
FROM
accounts a,
user_accounts ua
WHERE
a.accountkey = ua.accountkey
and a.endpointkey = 10
and a.name= 'ABC'
and a.status not in (
'SUSPENDED FROM IMPORT SERVICE');
nan
Actionable Analytics- Update Account (Specific User Account in an Endpoint)
Actionable Analytics to update specific User Account in an Endpoint
Endpoint Key, Account Name
Analytics
SELECT
a.name,
a.accountkey as acctKey,
endpointkey,
'UpdateAccount' as Default_Action_For_Analytics
FROM
accounts a,
user_accounts ua
WHERE
a.accountkey = ua.accountkey
and a.endpointkey = 10
and a.name= 'ABC'
and a.status not in (
'SUSPENDED FROM IMPORT SERVICE');
nan
Actionable Analytics- Update Accounts (All Accounts of an Endpoint)
Actionable Analytics to update accounts of a Specific Endpoint
Endpoint Key
Analytics
SELECT
a.name,
a.accountkey as acctKey,
endpointkey,
'UpdateAccount' as Default_Action_For_Analytics
FROM
accounts a,
user_accounts ua
WHERE
a.accountkey = ua.accountkey
and a.endpointkey = 10
and a.status not in (
'SUSPENDED FROM IMPORT SERVICE');
nan