Out of band Detection : Analytics querry to fetch the accounts for specific endpoints

[tpawle]

We want to genrate the Analytics report to fectch the accounts details for sepecific end points , which are reconciled from target system and not created through saviynt. Once we get the accounts details then we will setup the out of band detection configuration. 

[pmahalle · Accepted solution]

Hi @tpawle,

Can you try below query for the same. Make sure to add your required fields and endpointkey in the query.

SELECT NAME, ACCOUNTID, CUSTOMPROPERTY1, STATUS FROM ACCOUNTS WHERE ENDPOINTKEY IN (xx,yy,zz) AND STATUS IN ('1','MANUALLY PROVISIONED') AND ACCOUNTKEY NOT IN (SELECT ACCOUNTKEY FROM ARSTASKS WHERE ENDPOINTKEY IN (xx,yy,zz) AND STATUS IN (3,9) AND TASKTYPE=3)