List Archives

This forum is an archive of all posts to our mailing list over the past few years. The forum is set read only therefore to contribute you will need to join our list community. See more info about this here.

When subscribed to the list you should use your standard email client to send your posts to ActiveDir@mail.activedir.org.

List Archives

Unanswered Active Topics

Forums Search

Forums >ActiveDir Mail List Archive >List Archives

Subject: RE: [ActiveDir] csvde syntax

Prev Next

You are not authorized to post a reply.

Author

Messages

listmail

Posts:497

08/21/2005 7:29 AM
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Dan Holme Sent: Thursday, August 11, 2005 2:30 PM To: ActiveDir@xxxxxxxxxxxxxxxxxx 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] 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/

You are not authorized to post a reply.

Forums >ActiveDir Mail List Archive >List Archives > RE: [ActiveDir] csvde syntax

ActiveForums 3.7

Syndicate

Friends

List Archives

List Archives

Friends

Members

Articles

Related Links

Ads