How do I delete empty cells in a 2D array.

[water]

$aUserInfo = _AD_GetObjectsInOU("OU=company,DC=ad,DC=company,DC=org", "(&(objectCategory=Person)(objectclass=user)(sAMAccountName=" & $aNames[$i] & "*)(!distinguishedName=*TransferZone*))", "", "displayName,distinguishedName")

 

[Valnurat]

I don't get any result. $aUserInfo it 0.

[water]

Then @error and @extended tell you what went wrong.

[Valnurat]

@error = 3

Don't know what that means.

 

@Extended = 0

Edited March 24, 2017 by Valnurat

[water]

All error codes are listed in the respective function header in the AD UDF.

[Valnurat]

No records returned from Active Directory. $sFilter didn't return a record

[water]

My bad!
Unfortunately you can't use wildcards on a DN attribute (e.g. distinguishedname). https://social.technet.microsoft.com/wiki/contents/articles/5392.active-directory-ldap-syntax-filters.aspx

If you have all users in a single container you could limit the search to this container, else you need to eliminate unwanted users from the returned array.

[Valnurat]

@water

 

Local $aUserInfo = _AD_GetObjectsInOU("OU=company,DC=ad,DC=company,DC=org","(&(objectCategory=Person)(objectclass=user)(sAMAccountName=" & $aNames[$i] & "*)(!(ou:distinguishedName:=TransferZone)))","","displayName,distinguishedName")

This works. But do you know how to add more that should not to be included?

I have a "Leavers" not to be included.

[water]

Local $aUserInfo = _AD_GetObjectsInOU("OU=company,DC=ad,DC=company,DC=org","(&(objectCategory=Person)(objectclass=user)(sAMAccountName=" & $aNames[$i] & "*)(!(ou:distinguishedName:=TransferZone))(!(ou:distinguishedName:=Leavers)))","","displayName,distinguishedName")

[Valnurat]

Yes, I tried that too. It does not work.

11 minutes ago, water said:

Local $aUserInfo = _AD_GetObjectsInOU("OU=company,DC=ad,DC=company,DC=org","(&(objectCategory=Person)(objectclass=user)(sAMAccountName=" & $aNames[$i] & "*)(!(ou:distinguishedName:=TransferZone))(!(ou:distinguishedName:=Leavers)))","","displayName,distinguishedName")

This does not work either.

(!(|(ou:distinguishedName:=TransferZone)(ou:distinguishedName:=Leavers))))

 

Edited March 24, 2017 by Valnurat

[water]

Shouldn't it be:

(&(!(ou:distinguishedName:=TransferZone)!(ou:distinguishedName:=Leavers))))

 

[Valnurat]

@error = 3

Sorry to say.

[water]

Then I have run out of ideas
Didn't know that the format you use even existed. Where did you find this?

[Valnurat]

https://confluence.atlassian.com/display/DEV/How+to+write+LDAP+search+filters

 

Still i'm not sure, because if I use ADUC to create a filter, that doesn't work either.

 

[water]

As you are running Microsoft Active Directory the following describes why it doesn't work:

Quote

 As Microsoft Active Directory does not implement extensible matching, the following examples won't work with it.

(&(objectClass=group)(|(ou:dn:=Chicago)(ou:dn:=Miami)))

 

[Valnurat]

So it is not possible? But what about query in the picture previous post?

 

[water]

Does not work as the DistinguishedName does not support wildcards and looks like: CN=UserName,OU=Leavers,DC=Comapny,DC=tld

[water]

Seems we are back to the original idea:

$aResult = _AD_GetObjectsInOU(...)
For $i = $aResult[0][0] To 1 Step -1
    If $aResult[$i][0] = "" Or StringInStr($aResult[$i][0], "Leavers") > 0 Then
        _ArrayDelete($aResult, $i)
    EndIf
Next

Removes all records with displayname = "" (first column) or distinguishedname containing "Leavers" (columns 2)

[Valnurat]

#¤%&/&/(/

[AdamUL]

Are you looking for a certain list of users from their sAMAccountNames?  What type of filter are you trying to add?  It depends on what you are looking for.  

 

Adam