Solved

CSVDE export some fields unreadable

Posted on 2010-09-15
6
1,726 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:aideb
  • 3
  • 3
6 Comments
 
LVL 57

Accepted Solution

by:
Mike Kline earned 500 total points
ID: 33683603
I'll have to test csvde later, in the meantime can you try with adfind http://www.joeware.net/freetools/tools/adfind/index.htm
adfind -default -f "&(objectcategory=person)(objectclass=user)"  samaccountname objectsid objectguid -csv >  users.csv
 
Thanks
Mike
0
 
LVL 2

Author Comment

by:aideb
ID: 33689658
Excellent, Thanks!

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

Cheers
0
 
LVL 57

Expert Comment

by:Mike Kline
ID: 33691903
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
0
 
LVL 2

Author Comment

by:aideb
ID: 33694345
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


0
 
LVL 2

Author Closing Comment

by:aideb
ID: 33694350
Fantastic thanks!
0
 
LVL 57

Expert Comment

by:Mike Kline
ID: 33694529
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
0

Join & Write a Comment

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now