I always use quotes around the LDAP query: -r "(query)" And have never used them around the stuff that goes after -l
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rob Hackney Sent: Wednesday, September 29, 2004 10:08 AM To: Exchange Discussions Subject: RE: Help with csvde query So which part do I need quotes round? Just once in a query? When I've searched on CSVDE and found examples, inc the MS site (which admittedly was for XP but wouldn't have thought it would be that different), they have had quote marks on both commands (-r and -l) or if showing a -r query, no quote marks. I'm not doubting you , I'm just try to find what's right for the future. thanks > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Fyodorov, Andrey FTL > Sent: 29 September 2004 14:59 > To: Exchange Discussions > Subject: RE: Help with csvde query > > > You have a mismatch of " quote marks. > > Also whatever goes after -l does not need to be surrounded by > quote marks. > > I just tried to run my command and it worked fine - > 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 9:53 AM > To: Exchange Discussions > Subject: RE: Help with csvde query > > > 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,mDBO > verHardQuo > 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&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. > > > 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&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.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 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.
