Create BR with dynamic condition

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 over 1 year 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
0 graziano santucci over 1 year ago in reply to henrik a johansson

thanks the script worked
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 graziano santucci over 1 year ago in reply to henrik a johansson

thanks the script worked
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data