Thanks for this Andrey for pointing out my small error! I tired it but it didn't like it (no entries written) so I knocked off the mailnickname=* but still didn't like it. I then tried this: CSVDE -f storlimit.csv -r "(&(objectClass=User)) -l "name,distinguishedName,mDBStorageQuota,mDBOverQuotaLimit,mDBOverHardQuo taLimit" And that worked but still gave me computers also. Any ideas as to why? Not to worry too much as I now have a decent looking result. Thanks
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Fyodorov, Andrey FTL > Sent: 29 September 2004 13:55 > To: Exchange Discussions > Subject: RE: Help with csvde query > > > CSVDE -f maillimit.csv -r > "(&(objectclass=user)(mailnickname=*))" -l > name,mDBStorageQuota,mDBOverQuotaLimit,mDBOverHardQuotaLimit > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Rob Hackney > Sent: Wednesday, September 29, 2004 8:48 AM > To: Exchange Discussions > Subject: Help with csvde query > > > > > Hi, I am trying to export user storage limits using CSVDE. I > am a total novice at csvde so apologies if the below isn't > very good as I'm still trying to understand it. The first > query I tried was: > > CSVDE -f maillimit.csv -l "DN,objectclass, > objectcategory,name, > distinguishedName,cn,desription,ou,mDBStorageQuota,mDBOverQuot > aLimit,mDB > OverH > ardQuotaLimit" > > Which while giving me the info I wanted, also gave me a whole > load of info I did not want such as contacts/ computers etc > which is to be expected. > > So, I tried to mimimize what I wanted by using a LDAP search > expression: > > > CSVDE -f storlimit.csv -r (and(objectClass=User)) -l "name, > istinguishedName,mDBStorageQuota,mDBOverQuotaLimit,mDBOverH > ardQuotaLimit" > > This gave me no output at all. I was thinking that the LDAP > expression would return all Users but this was not the case. > Any pointers as to where I've gone wrong? thanks > > This email is confidential and intended solely for the use of the > individual(s) to whom it is addressed. It should not be > deemed to constitute a binding contract between TKC Group and > the recipient(s) unless a purchase order number is quoted. > Any views or opinions presented are solely those of the > author and do not necessarily represent those of TKC Group > Ltd. If you are not the intended recipient(s), please do not > copy or disclose its contents. Please return it to: > [EMAIL PROTECTED] then delete the email. > > Scanned for viruses by MailDefender > > > _________________________________________________________________ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Web Interface: > http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&t ext_mode=&lang =english To unsubscribe send a blank email to %%email.unsub%% Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&text_mode=&; lang=english To unsubscribe send a blank email to %%email.unsub%% Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. Scanned for viruses by MailDefender This email is confidential and intended solely for the use of the individual(s) to whom it is addressed. It should not be deemed to constitute a binding contract between TKC Group and the recipient(s) unless a purchase order number is quoted. Any views or opinions presented are solely those of the author and do not necessarily represent those of TKC Group Ltd. If you are not the intended recipient(s), please do not copy or disclose its contents. Please return it to: [EMAIL PROTECTED] then delete the email. Scanned for viruses by MailDefender _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&text_mode=&lang=english To unsubscribe send a blank email to [EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
