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
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
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%')
)
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%')
)
thanks the script worked