Microsoft® Windows PowerShell™ Step By Step

Creating More Effective Queries

The BasicQuery.ps1 script is a fairly wasteful script in that all it does is produce a list of user names and print them out. Although the script illustrates the basics of making a connection into Active Directory by using ADO, it is not exactly a paradigm of efficiency. ADO, however, is a very powerful technology, and there are many pieces of the puzzle we can use to make the script more efficient and more effective. The first thing we need to do is to understand the objects we have that we can use with ADO. These objects are listed in Table 8-2.

Table 8-2. Objects Used to Search Active Directory

Object	Description
Connection	An open connection to an OLE DB data source such as ADSI
Command	Defines a specific command to ...