 Loading |
|
Loading |
| VBScript |
| JavaScript |
| Powershell |
Search Options: Create a Department Phone List
|
||
|
' Description: Demonstration script that develops a department phone list for the Finance Department of fabrikam.com.
On Error Resume Next Const ADS_SCOPE_SUBTREE = 2 Set objConnection = CreateObject("ADODB.Connection") Set objCommand = CreateObject("ADODB.Command") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" Set objCommand.ActiveConnection = objConnection objCommand.CommandText = _ "SELECT givenName,SN,telephoneNumber FROM " & _ "'LDAP://DC=fabrikam,DC=com' " _ & "WHERE objectCategory='User' AND department='Finance'" objCommand.Properties("Page Size") = 1000 objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE Set objRecordSet = objCommand.Execute objRecordSet.MoveFirst Do Until objRecordSet.EOF Wscript.Echo objRecordSet.Fields("SN").Value & ", " & _ objRecordSet.Fields("givenName").Value & " " & _ objRecordSet.Fields("telephoneNumber").Value objRecordSet.MoveNext Loop | ||
© 2008 - 2013 Boris Toll :: Scripts available: 6.481 :: :: scriptbox.toll.at :: :: powered by www.toll.at :: | ||
