Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

CSVDE export some fields unreadable

Posted on 2010-09-15
6
1,767 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

This article explains how to install and use the NTBackup utility that comes with Windows Server.
In-place Upgrading Dirsync to Azure AD Connect
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

838 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