Solved

CSVDE export some fields unreadable

Posted on 2010-09-15
6
1,788 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
[X]
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
  • 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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
A hard and fast method for reducing Active Directory Administrators members.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
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.

738 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