Playbook to search AD expired accounts and delete them

pottapitot — Fri, 17 Jun 2022 16:08:04 GMT

Hi,

I am trying to create a playbook that

1) Searches for expired accounts in AD

2) Retrieves the sAMAccountName, Display name and expired date

3) Delete the accounts

4) Sent an email notification with the details of the accounts deleted.

I created the ldap query for the same and one factor was to get the current time to use in the query.

There is a function call DateTimetoADTime in XSOAR which can be used for that.

The LDAP query is as follows

(&(objectCategory=person)(objectClass=user)(!accountExpires=9223372036854775807)(!accountExpires=0))

I get the current date in AD format using

DatetimetoADTime days_ago=0

I append to the LDAP query above to get the result using ad-search (xsoar function) like so

(&(objectCategory=person)(objectClass=user)(!accountExpires=9223372036854775807)(!accountExpires=0))(accountExpires<=<output given from DatetimetoADTime>)

This works in the playground where I get the display names only though.

I tried to make a playbook out of this but I am stuck at the step after using the DateTimetoADTime, how do I give the value as input to ad-search to retrieve the users and also get the details of each user (sAMAccountName, Display name and expired date), then give the same as output to be deleted?

Thanks in advance

Re: Playbook to search AD expired accounts and delete them

jfernandes1 — Mon, 20 Jun 2022 02:34:51 GMT

Hi @pottapitot, you can use the extend context option to save the data to the context in the DatetimetoADTime step. Then use that context key token in the following step. Use "data=" to dump all command output into the context key. For more information refer - https://xsoar.pan.dev/docs/playbooks/playbooks-extend-context

Re: Playbook to search AD expired accounts and delete them

pottapitot — Mon, 20 Jun 2022 16:34:30 GMT

Hi @jfernandes1 ,

That was exactly what I was looking for. Thanks alot.

Cheers

topic Re: Playbook to search AD expired accounts and delete them in Cortex XSOAR Discussions

Playbook to search AD expired accounts and delete them

Re: Playbook to search AD expired accounts and delete them

Re: Playbook to search AD expired accounts and delete them