Get all groups in AD using AD Spoke

Evren Yamin
Tera Contributor

‎10-12-2023 07:52 PM

Hello,

 

Is there a way for us to get all the groups in AD using Microsoft AD Spoke? I can see the existing actions can only get 1 record at a time or update 1 record at a time like for example these actions:

EvrenYamin_0-1697165482505.png

Was hoping I can get all groups using a filter using AD spoke in flow designer.

Appreciate all the help.

 

Thank you.

 

 

 

0 Helpfuls
  • 1,592 Views
6 REPLIES 6

Tai Vu
Kilo Patron
Kilo Patron

‎10-12-2023 09:55 PM

Hi @Evren Yamin 

Yes we can. The action should be used is Query AD

TaiVu_0-1697172881221.png

TaiVu_1-1697172889138.png

 

Query AD
This action Queries AD for Objects specified by search filter.
Inputs:
  • Search Filter - An LDAP filter string that defines the search parameters. Use any valid LDAP filtering criteria.For e.g. samaccountname = xyz
  • Properties - A comma-separated list of Active Directory properties to return. For example, givenName,SN,title. If this field is blank, then all properties are returned.
Outputs:
  • Status - Will be set to "Success" if the request succeeds or "Error" if a failure in AD occurs.
  • Error Message If the status is Error and action fails to run the query, the error message has details of failure.
  • Object Properties
  • Records Found?
Error Messages:
  • The provided filter is invalid. Please check the filter syntax.
  • No object found with the filter provided.
  • The properties mentioned are not in comma separated string format.
  • One or more properties are invalid.

 

0 Helpfuls

Evren Yamin
Tera Contributor
In response to Tai Vu

‎10-15-2023 04:12 PM

Hello @Tai Vu, query AD action is no longer available in UTAH. Do you perhaps know which version is this available? Wanted to check how it was setup.

0 Helpfuls

AnveshKumar M
Tera Sage
Tera Sage

‎10-12-2023 09:58 PM

Hi @Evren Yamin 

There is no OOTB Action available to query multiple groups at once. You can use Query AD action with the filter given below to query the groups and it will return the records in  JSON format which you can process using a custom Script Action.

 

Filter:

(objectclass=group)

 

Please mark my answer helpful and accept as solution if it helped you 👍✅

Thanks,
Anvesh

Evren Yamin
Tera Contributor
In response to AnveshKumar M

‎10-15-2023 04:12 PM

Hello @AnveshKumar M, query AD action is no longer available in UTAH. Do you perhaps know which version is this available? Wanted to check how it was setup.

0 Helpfuls