Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

CSVDE export some fields unreadable

Posted on 2010-09-15
6
Medium Priority
?
1,864 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 2000 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

971 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