Search for Computers Running Windows 2003

Demonstration script that searches Active Directory for all computers running Windows Server 2003.

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"
objCommand.ActiveConnection = objConnection
objCommand.Properties("Page Size") = 1000 
objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE  
objCommand.CommandText = _ 
    "SELECT Name, operatingSystemVersion FROM " _   
        & "'LDAP://DC=fabrikam,DC=com'" _ 
            & " WHERE objectClass='computer' AND " _
                &"operatingSystemVersion = '5.2 (3790)'" 
Set objRecordSet = objCommand.Execute 
objRecordSet.MoveFirst 

Do Until objRecordSet.EOF 
    Wscript.Echo "Name: " & objRecordSet.Fields("Name").Value 
    objRecordSet.MoveNext 
Loop