asked on

CSVDE export some fields unreadable

I have a command line which I have run to export the list of user attributes. Some are not readable however (ObjectGUID, ObjectSID) etc. How do I get this to output correctly.

Here is the command line I am using

CSVDE -f C:\Migration\scripts\EuropeBackups\Users_dump_%dd%%mm%%yy%.csv -u -r objectClass=User

ASKER CERTIFIED SOLUTION

Mike Kline

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aideb

ASKER

Excellent, Thanks!

Is there a way to output all attributes? I can't seem to find the option in the help

Cheers

Mike Kline

Leave the output fields blank
adfind -default -f "&(objectcategory=person)(objectclass=user)" -csv -tdcs
I like to select the fields, that gives you a lot

aideb

ASKER

Hi MK

I tried that and it only gives DN and Name

It appears to not like to give you all the fields when I have the -CSV option enabled. It gives me a scrawl of individual records without the CSV option.

Thanks for you help on this one. I have what I need. All fields output in CSV would be ideal. If you discover how to then please advise

Cheers

aideb

ASKER

Fantastic thanks!

Mike Kline

ahhh ok, I wasn't able to teste at the time you can also list all the attributes you may want, the key is knowing the attribute names. Really nice blog post about what the attributes are actually called
http://www.selfadsi.org/user-attributes-w2k3.htm
Thanks
Mike