Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Set MyUser = GetObject ("LDAP://cn=" & uname & ",ou=" & strname & ",DC=bobdom,DC=net")
- Set MyUser = GetObject ("LDAP://mail=" & uname & ",ou=" & strname & ",DC=bobdom,DC=net")
- Function getOffice (strname, uname)
- strEmail = uname
- WScript.Echo "email: " & strEmail
- Dim objRoot : Set objRoot = GetObject("LDAP://RootDSE")
- Dim objDomain : Set objDomain = GetObject("LDAP://" & objRoot.Get("defaultNamingContext"))
- Dim cn : Set cn = CreateObject("ADODB.Connection")
- Dim cmd : Set cmd = CreateObject("ADODB.Command")
- cn.Provider = "ADsDSOObject"
- cn.Open "Active Directory Provider"
- Set cmd.ActiveConnection = cn
- cmd.CommandText = "SELECT physicalDeliveryOfficeName FROM '" & objDomain.ADsPath & "' WHERE mail='" & strEmail & "'"
- cmd.Properties("Page Size") = 1
- cmd.Properties("Timeout") = 300
- cmd.Properties("Searchscope") = ADS_SCOPE_SUBTREE
- Dim objRS : Set objRS = cmd.Execute
- If IsNull(objRS.Fields(0)) = TRUE Then
- getOffice = "BLANK"
- Else
- getOffice = objRS.Fields(0)
- WScript.Echo getOffice
- End If
- Set objRS = Nothing
- Set cmd = Nothing
- Set cn = Nothing
- Set objDomain = Nothing
- Set objRoot = Nothing
- End Function
- <LDAP://SERVERNAME/DC=bobdom,DC=net>;(&(objectClass=user)([email protected]));
- <LDAP://SERVERNAME/DC=bobdom,DC=net>;(&([email protected]));name,mail,member,description,memberOf,userParameters,userAccountControl,whenCreated,CN;subTreeCount=1
- Set oCon = Server.CreateObject("ADODB.Connection")
- oCon.Provider = "ADsDSOObject"
- oCon.Open "ADProvider", "ADUsername", "ADPassword"
- Set oCmd = Server.CreateObject("ADODB.Command")
- Set oCmd.ActiveConnection = oCon
- sQuery = "<LDAP://SERVERNAME/DC=bobdom,DC=net>;(&([email protected]));name,distinguishedName,physicalDeliveryOfficeName;subTreeCount=1>"
- oCmd.CommandText = sQuery
- Set ADRecordSet = oCmd.Execute
Add Comment
Please, Sign In to add comment