3 Replies Latest reply on Apr 3, 2015 5:22 AM by Mark ODonnell

Can I tell which groups are AD Sync and which are not?

Mark ODonnell Apr 2, 2015 11:09 AM

Is there a way via command line or DB query for a server admin to tell which groups were setup as AD sync groups and which were not?

I am trying to avoid sending an email to hundreds of site admins asking which groups were created from AD.

Thanks.

1. Re: Can I tell which groups are AD Sync and which are not?

Jeff Strauss Apr 2, 2015 1:35 PM (in response to Mark ODonnell)

I don't think there's a way to tell via tabcmd. However, with a query you should be able to tap into public.groups joined with public.domain and any domain that is local is not considered AD. There may also be a way to do it via the REST API, but I haven't explored this too much in depth yet.
Like Show 0 Likes(0)

Actions
2. Re: Can I tell which groups are AD Sync and which are not?

Mark ODonnell Apr 2, 2015 2:14 PM (in response to Jeff Strauss)

I will pull those into a workbook and see if I can find something useful. I also have a case file opened with the same question and will keep this posted updated if I hear anything.
Like Show 0 Likes(0)

Actions
3. Re: Can I tell which groups are AD Sync and which are not?

Mark ODonnell Apr 3, 2015 5:22 AM (in response to Jeff Strauss)

The DB query works very well. Domain groups are clearly identified with Name = domain or Family = ActiveDirectory.
This will aid in another PowerShelll script I am writing to auto sync the domain groups. I can use this as my input for the array.
Thanks!
Like Show 0 Likes(0)

Actions

Tableau Community