When you want to convert to a CSV with adcsv you don't want to use -nodn and -nolabel with adfind or else it can't figure out what is in the file, it is just a bunch of text. I didn't notice that he had specified those options in his post when I responded.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Kern Sent: Monday, August 22, 2005 8:29 PM To: [email protected] Subject: Re: [ActiveDir] export to csv I ran adfind with simillar parameters to what Charlie suggested. Now, I think i got stoopid because i'm having issues with adcsv.pl. When i use the output of adfind as the inputfile for adcsv.pl, i just get a DN; and thats it. Using the switch for csv, doesn't seem to do anything. If my outputfile is called "test.txt.", adcsv.pl, just makes a "test.txt.txt" file with only the 1 entry- DN; This happens no matter what arguments I use or don't use. What am i doing wrong? Am i this dense? Thanks On 8/22/05, Tom Kern <[EMAIL PROTECTED]> wrote: > On 8/19/05, joe <[EMAIL PROTECTED]> wrote: > > After you export to a file, then you can use adcsv.pl (also in the > > zip) to convert the file to a delimited single liner per object > > file. Version 2.0.0, if I ever get to work on it, will have native delimited output capability. > > > > joe > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Charlie > > Kaiser > > Sent: Friday, August 19, 2005 3:51 PM > > To: [email protected] > > Subject: RE: [ActiveDir] export to csv > > > > Yes. > > > > adfind -default -f displayname="Username" cn streetaddress st co > > -noctl -nodn -nolabel > outputfile.txt (or csv) > > > > You may have to play with the order in the output file to get what you want. > > > > ********************** > > Charlie Kaiser > > W2K3 MCSA/MCSE/Security, CCNA > > Systems Engineer > > Essex Credit / Brickwalk > > 510 595 5083 > > ********************** > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Kern > > > Sent: Friday, August 19, 2005 11:42 AM > > > To: activedirectory > > > Subject: [ActiveDir] export to csv > > > > > > Whats the best utility to export only user object and attribs > > > like st,streetAddress,c,email addy,etc. > > > Just the "human" stuff a manager would be interested in? > > > could adfind do this? > > > thanks > > > List info : http://www.activedir.org/List.aspx > > > List FAQ : http://www.activedir.org/ListFAQ.aspx > > > List archive: > > > http://www.mail-archive.com/activedir%40mail.activedir.org/ > > > > > List info : http://www.activedir.org/List.aspx > > List FAQ : http://www.activedir.org/ListFAQ.aspx > > List archive: > > http://www.mail-archive.com/activedir%40mail.activedir.org/ > > > > List info : http://www.activedir.org/List.aspx > > List FAQ : http://www.activedir.org/ListFAQ.aspx > > List archive: > > http://www.mail-archive.com/activedir%40mail.activedir.org/ > > > List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
