Create a Department Phone List

Demonstration script that develops a department phone list for the Finance Department of fabrikam.com.

VBScript Code


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