Endpoint is Disabled but Accounts remain active

[Gopinath3]

Hi Team,

We have a parent connection to Active Directory and a one of the endpoint as ServiceNow Management, where we have only disabled the endpoint, but the accounts remain active.

1.Is it possible to disable the accounts via a CSV file when the endpoint is inactive?
2. Can we disable the accounts using an enhanced query and how? (They are 2700 Accounts associated with this endpoint)

@Akilan @Rama 

Thanks,

Gopinath

[rushikeshvartak · Accepted solution]

• When you disable connection , respective account, security system, endpoint ,entitlement gets disabled.
• Disabling endpoint does not disable accounts
• You can disable using enhanced query 

SELECT
CONCAT(ac.name, '-Deleted on-', SYSDATE()) AS accounts__name,
'SUSPENDED FROM IMPORT SERVICE' AS accounts__status,
ac.accountkey AS accounts__primarykey FROM accounts ac,endpoints e where ac.STATUS  not in  ( 'SUSPENDED FROM IMPORT SERVICE') and ac.endpointkey=e.endpointkey and e.endpointname='Rushi'