Solved

CSVDE export some fields unreadable

Posted on 2010-09-15
6
1,750 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
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

770 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