Identity Manager Community

Forum Create BR with dynamic condition

State Suggested Answer
Replies 2 replies
Answers 1 answer
Subscribers 94 subscribers
Views 313 views
Users 0 members are here

Options

Related

Create BR with dynamic condition

graziano santucci 6 months ago

I would like to create a Business role with the condition that it finds all users of a specific Organization Unit of Active Directory. I can't find the right conditions, every time I get zero users

Parents

0 henrik a johansson 6 months ago

Here you go:

UID_Person IN
(
SELECT UID_Person FROM ADSAccount a
JOIN ADSContainer as c on a.UID_ADSContainer = c.UID_ADSContainer
WHERE (c.cn = 'ACME' OR c.CanonicalName LIKE '%ACME%')
)
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Reply

0 henrik a johansson 6 months ago

Here you go:

UID_Person IN
(
SELECT UID_Person FROM ADSAccount a
JOIN ADSContainer as c on a.UID_ADSContainer = c.UID_ADSContainer
WHERE (c.cn = 'ACME' OR c.CanonicalName LIKE '%ACME%')
)
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Children

0 graziano santucci 6 months ago in reply to henrik a johansson

thanks the script worked
Cancel
Up 0 Down

Reply

Verify Answer

Cancel