LOL.  Thanks, joe.  Actually, just using the –csv gave me the commas I needed to parse out the columns easily in Excel.

Al Maurer
Service Manager, Naming and Authentication Services
IT | Information Technology
Agilent Technologies
(719) 590-2639; Telnet 590-2639
http://activedirectory.it.agilent.com


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joe
Sent: Monday, February 20, 2006 5:35 PM
To: [email protected]
Subject: RE: [ActiveDir] Null values in adfind results

 

That is one way.

 

If you want to keep the "standard" ADFIND output format you can also use the -oao switch which stands for ordered attribute output or the "Jerry" switch.

 

Also with both CSV and OAO you can specify a "NULL" value that you want ADFIND to write instead of a blank. So for instance say you want it to actually write "<NULL>" you can specify

 

-csv "<NULL>"

 

or

 

-oao "<NULL>"

 

 

 A personal favorite:

 

-oao "This space intentionally left blank"

 

 

   joe

 

--

O'Reilly Active Directory Third Edition - http://www.joeware.net/win/ad3e.htm 

 

 

 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan A. Conrad
Sent: Friday, February 17, 2006 10:45 AM
To: [email protected]
Subject: Re: [ActiveDir] Null values in adfind results

adfind -default -f "&(objectcategory=organizationalperson)(!attributename=*)" -csv  should do the trick. 

 

Ryan

 

On 2/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

I'm looking for null values in several attributes of user objects but the result only returns the attributes where a value is present.  I'd like to have the output in some kind of delimited text file so I can import it into a spreadsheet.

 

Can adfind do that?  I couldn't find a switch to specify returning null values.

 

Al Maurer
Service Manager, Naming and Authentication Services
IT | Information Technology
Agilent Technologies
(719) 590-2639; Telnet 590-2639
http://activedirectory.it.agilent.com

 

 

Reply via email to