Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/22/2023 06:30 AM
05/22/2023 06:53 AM
@aryan9975 Thanks for posting your question. Please try the below query and see if it is bringing the expected accounts. This will bring all privileged accounts except for Just In Time accounts
SELECT ac.ACCOUNTKEY AS ID, ac.accountid AS 'accountid', ac.NAME AS 'Account Name',ac.accounttype AS 'Account Type', ep.ENDPOINTNAME AS 'EndpointName', ep.DISPLAYNAME AS 'Endpoint Display Name', epp.PLATFORM_TYPE AS 'PLATFORM' FROM accounts ac INNER JOIN endpoints ep ON ac.ENDPOINTKEY=ep.ENDPOINTKEY AND ep.status = 1 AND ac.status IN (1,'Manually Provisioned') AND ((ac.accounttype IS NOT NULL AND ac.accounttype != '') AND ac.ACCOUNTCONFIG LIKE '%"pamState":"ENABLED"%') AND (ac.accountconfig NOT LIKE '%"justInTime":"true"%') INNER JOIN endpoints_properties epp ON ep.ENDPOINTKEY = epp.ENDPOINTKEY;
Thanks
Nagesh K