Re: Querying AD with the LIKE operator

Richard, Is it possible to run a select statement against the record set
before stepping through the results?

Thanks,

Dan
"Dan White" <Dan.White@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23TnsQKSkFHA.3336@xxxxxxxxxxxxxxxxxxxxxxx
> I guess I will just have to return all computers then parse them out.
> Thanks!
>
> Dan
> "Richard Mueller [MVP]" <rlmueller-NOSPAM@xxxxxxxxxxxxxxxxxxxx> wrote in
> message news:u46Kd8xjFHA.3608@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> >
> > Wildcards are not allowed when filtering/querying on distinguishedName.
> Only
> > exact matches are recognized. This is true of any attribute with "DN"
> > syntax.
> >
> > --
> > Richard
> > Microsoft MVP Scripting and ADSI
> > Hilltop Lab web site - http://www.rlmueller.net
> > --
> > "Dan White" <Dan.White@xxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:e922DOwjFHA.3656@xxxxxxxxxxxxxxxxxxxxxxx
> > > I have a weird problem querying AD for computer accounts.
> > >
> > > I am trying to query AD for any computer in any OU that contains
> "server"
> > in
> > > the name of the OU.
> > >
> > > EG:
CN=cdecitrix9,OU=CAN,OU=!Citrix,OU=Servers,DC=MyDomain,DC=com
> > > CN=abccwrk1,OU=CAN,OU=Servers,DC=MyDomain,DC=com
> > >
> > > We have several nested OU's that I need to enumerate.
> > >
> > > Here code that searches the "name" attribute of AD computers:
> > > '<><><><><><><><><><><><><><><><><><><><><><>
> > > 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 distinguishedName,Name from
> > > 'LDAP://DC=MyDomain,DC=com' where objectClass='computer' and name =
> > > '*MyComp*'"
> > > 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("distinguishedName").Value
> > > objRecordSet.MoveNext
> > > Loop
> > > '<><><><><><><><><><><><><><><><><><><><><><>
> > >
> > > The above looks (starting at the root of the domain) for computers
that
> > have
> > > the string "MyComp" somewhere in their name. The above script works as
> > > expected.
> > >
> > > If I change the query command to:
> > >
> > > objCommand.CommandText = "Select distinguishedName,Name from
> > > 'LDAP://DC=MyDomain,DC=com' where objectClass='computer' and
> > > distinguishedName = '*MyComp*'"
> > >
> > > It doesn't work. You would think "distinguishedName" would return the
> same
> > > set of computers but it only returns and empty data set.
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > >
> > > Dan
> > >
> > >
> >
> >
>
>


.

Relevant Pages

  • Re: Local Security Settings
    ... > properties and that all the domain computers point only to the domain ... > controller as their preferred dns server. ... > dcdiag [domain controller only] and netdiag to check for the health of your ... > "Dan" wrote in message ...
    (microsoft.public.win2000.security)
  • Richard wonders if anyone has suggestions
    ... Below is the string between Richard Harper and myself over the last few ... >> other than the Windows XP firewall on either PC? ... >> * PLEASE post all messages and replies in the newsgroups ... >>> The computers get their IP addresses automatically through a router. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Computers/Users and OU structure
    ... Richard -- thank you for your insight. ... seperating computers and users wouldn't be a bad idea. ... "Alex Feigenson" wrote: ... do I move both the computer object and the user object ...
    (microsoft.public.windows.server.active_directory)
  • Re: Computers/Users and OU structure
    ... Richard -- thank you for your insight. ... seperating computers and users wouldn't be a bad idea. ... "Alex Feigenson" wrote: ... do I move both the computer object and the user object ...
    (microsoft.public.windows.server.active_directory)
  • Re: file sharing
    ... Two wireless laptops running XP Home, ... >>All the computers access the internet properly. ... >>service is running, firewall is off, guest account is active. ...
    (microsoft.public.windowsxp.network_web)