1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| Set objCommand = CreateObject("ADODB.Command")
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Provider = "ADsDSOObject"
objConnection.Properties("User ID") = "cn=AAA,ou=programs,o=XXX"
objConnection.Properties("Password") = "xxxx"
objConnection.Open = "Active Directory Provider"
objCommand.ActiveConnection = objConnection
ArgReq = "(uid=" & IdUsr & ")"
strBase = "<LDAP://annuaire.yyy.com/ou=users,o=XXX>"
StrFilter = "(&(objectclass=person)" & ArgReq & ")"
StrAttributes = "sn,givenname,ou,l,mail,telephonenumber,employeenumber,buildingname,floor,roomnumber,postOfficeBox,company,sitecode,hierarchy,idcompany,securidnumber,employeetype,budgetingcenter,uid,adminsitecode,mobile,facsimileTelephoneNumber"
strQuery = strBase & ";" & StrFilter & ";" & StrAttributes & ";subtree"
objCommand.CommandText = strQuery
objCommand.Properties("Page Size") = 500
objCommand.Properties("Timeout") = 60
objCommand.Properties("Cache Results") = False
Set oRecordset = objCommand.Execute |
Partager