Unless you have done something smart like indexing objectclass, you will want to convert the query to objectcategory=computer.
A quick test on my home test domain showed the following: **************************************************************************** ************* Objectclass=computer Statistics ================================= Elapsed Time: 971 (ms) Returned 11 entries of 16743 visited - (0.07%) Used Filter: (objectClass=computer) Used Indices: DNT_index:14022:N Analysis --------------------------------- Hit Rate of 0.07% is Inefficient No dedicated indices used for search, this is inefficient. Indices used: Index Name : DNT_index Record Count: 14022 (estimate) Index Type : Normal Attribute Index Filter Breakdown: (objectClass=computer) **************************************************************************** ************* Objectcategory=computer Statistics ================================= Elapsed Time: 0 (ms) Returned 11 entries of 11 visited - (100.00%) Used Filter: (objectCategory=CN=Computer,CN=Schema,CN=Configuration,DC=joe,DC=com) Used Indices: idx_objectCategory:11:N Analysis --------------------------------- Hit Rate of 100.00% is Efficient Indices used: Index Name : idx_objectCategory Record Count: 11 (estimate) Index Type : Normal Attribute Index Filter Breakdown: (objectCategory=CN=Computer,CN=Schema,CN=Configuration,DC=joe,DC=com) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Holme Sent: Thursday, August 11, 2005 2:30 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] csvde syntax DUMPCOMPUTERS.BAT @echo off set OU=%1 set FileName=%2 ldifde -f "%FileName%.ldf" -d "%OU%,dc=us,dc=ray,dc=com" -p SubTree -r "(objectClass=computer)" -l "objectClass,description,name,sAMAccountName" echo on the ldifde line is ONE line (watch for word wrap in the email) Call this file as in: DUMPCOMPUTERS.BAT "dc=windomain,dc=local" "computers.txt" Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Kern Sent: Thursday, August 11, 2005 11:18 AM To: activedirectory Subject: [ActiveDir] csvde syntax what's the ldap filter to use with csvde to just export all computer objects in a domain to a file? thanks List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
