Hi @Sharada ,
There should be Saviynt default actionable report for orphan accounts query. CC_Detected - Orphan Accounts
The same query shared below:
SELECT a.name 'Account Name',
e.displayname 'Application Name',
CASE
WHEN a.status = 1 THEN
'Active'
ELSE
a.status
END AS 'AccountStatus',
e.endpointKey,
a.accountclass,
a.ACCOUNTTYPE
FROM accounts a
INNER JOIN endpoints e
ON a.endpointKey = e.endpointKey
AND a.status IN ( 1, 'Active', 'Manually Provisioned' )
LEFT JOIN user_accounts ua
ON ua.accountkey = a.accountkey
WHERE ua.USERKEY IS NULL;
If this answers your question, please consider selecting Accept As Solution and hit Kudos
