Perfect! Worked like a charm! Thanks Michael.
On Mon, Jan 9, 2012 at 2:53 PM, Michael B. Smith <mich...@smithcons.com>wrote: > Adfind –csv –nodn –b “dc=domain,dc=org” –f > “(&(objectCategory=person)(mail=*)(!userAccountControl:1.2.840.113556.1.4.803:=2))” > name mail displayName**** > > You won’t be able to copy-n-paste that, but if you type it in, it gives > you what you want.**** > > ** ** > > Regards,**** > > ** ** > > Michael B. Smith**** > > Consultant and Exchange MVP**** > > http://TheEssentialExchange.com**** > > ** ** > > *From:* Harry Singh [mailto:hbo...@gmail.com] > *Sent:* Monday, January 09, 2012 1:44 PM > *To:* NT System Admin Issues > *Subject:* Adfind & Active Email CSV Dump.**** > > ** ** > > All --**** > > ** ** > > I could use a hand with generating the output i need using adfind. I'm > trying to dump all active e-mail addresses excluding those belonging to > Disabled Users to a csv file for HR. I'm using the following syntax.**** > > ** ** > > C:\Tools\AdFind>adfind -csv -nodn -b "dc=domain,dc=org" -f > "(&(objectCategory=**** > > person)(objectClass=user))" name mail displayName > mailusersjan62012.csv* > *** > > ** ** > > I suppose i could remove the -nodn and do find/replace within excel, but > am curious if there was a way to exclude disabled users. I do keep all my > disabled users in a single OU, so i'm assuming there could be a filter > switch i could use but am unfamiliar with that syntax as well.**** > > ** ** > > Also, the above dumps name, mail and displayname, but is there to way to > only output if the the mail field is not null ? Since my objective is to > get all email addresses, I don't want those users who don't have anything > populated in the mail field to appear. Again, if i have to manipulate > excel, that could work but it would sweet if i could accomplish everything > with one command.**** > > ** ** > > Regards,**** > > ** ** > > Harry.**** > > ** ** > > ** ** > > ** ** > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to listmana...@lyris.sunbeltsoftware.com > with the body: unsubscribe ntsysadmin**** > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to listmana...@lyris.sunbeltsoftware.com > with the body: unsubscribe ntsysadmin > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
