quick way of exporting large group of users to csv

hi,

  there ad server group contains around 200k users. job export these users 5 attributes("sn", "givenname","mail","c","telephone") on daily basis. first, have come c# solution. code below.

directoryentry directoryobject = getdirectoryentry();                 foreach (directoryentry child in directoryobject.children)                 {                     string childpath = child.path.tostring();                     string sn = childpath.remove(0, 7);                     alobjects.add(sn);
                    //get distinguishname, query ad again 5 attributes, slow.                     console.writeline(childpath);                     child.close();                     child.dispose();                 }                 directoryobject.close();                 directoryobject.dispose(); 

 

realize slow in performance. 3mins 1500 users. tried csvde, problem seems server not allow me export amount of users.throws exception "administrative limitation exceeded".  looks there search limitation on ad server side. there way "page" search result. example, everytime, csvde top 20 users, csvde next 20 users...etc. combine them later.

i dont think best solution. running out of ideas. , if knows quick , less performance impact solution, please post it.

 thank in advance.

---

rui

i use page size no larger 1000. however, learned maximum page size allowed 20000 (in windows server 2008). never heard of paged searches not being allowed. without enabling paging (by setting page size) queries limited 1000 records.

 

---

richard mueller - mvp directory services

Windows Server  >  Directory Services