This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to list all linked security groups per location

Hello,

We have a multitude of AD security groups linked to specific locations in Identity Manager in order to automatically grant membership to users that are provisioned in, or moved to those locations. Does anyone have a SQL query or other method of listing out the groups that are linked to each location? I would need to list all locations and all groups linked to each specific location. Any help would be appreciated.

Thank you

Parents

0 George Cerbone over 8 years ago

That information is stored in a table called "LocalityHasADSGroup". There will be one row for each location and group. You can join the table called "Locality" if you want to query by location name, etc.
Cancel
Up 0 Down

Cancel

Reply

0 George Cerbone over 8 years ago

That information is stored in a table called "LocalityHasADSGroup". There will be one row for each location and group. You can join the table called "Locality" if you want to query by location name, etc.
Cancel
Up 0 Down

Cancel

Children

No Data