?
Solved

CSVDE and LDIFDE export showing numerals starting X'434 instead of expected text

Posted on 2010-09-10
6
Medium Priority
?
1,636 Views
Last Modified: 2012-05-10
Whenever i run a csvde export or ldifde export i get a bunch of numbers instead of text.

the command i am running is :

CSVDE -f c:\temp\grpmem.txt -l "dn,member" -r objectClass=group


and i get a bunch of results like this:
"CN=Users,CN=Builtin,DC=fruit,DC=co,DC=uk"X'434e3d446f6d696e6963204e656c736f6e2c4f553d53616c65732c4f553d50656f706c652c4f553d496e6e6f63656e74204c74642c44433d6672756974746f776572732c44433d696e6e6f63656e746472696e6b732c44433d636f2c44433d756b'

using ldifde i am running :
 ldifde -f c:\temp\grpmem.txt

and i get results like this
dn: CN=Innocent,OU=Security Groups,DC=fruit,DC=co,DC=uk
changetype: add
member::  Q049RG9taW5pYyBOZWxzb24sT1U9U2FsZXMsT1U9UGVvcGxlLE9VPUlubm9jZW50IEx0ZCxEQz1mcn VpdHRvd2VycyxEQz1pbm5vY2VudGRyaW5rcyxEQz1jbyxEQz11aw==

We have a mixed environment 1 x 2008 and 2 x 2003 servers.  Im sure this only started happening after we introduced the 2008 server into the mix but im not sure it would affect the scripts like this.

Bascially i have a bunch of scripts that take our production AD and replicates it across to our test environments.  I need to know if can easily convert these characters back to normal text?
0
Comment
Question by:InnocentDrinks
[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
  • 2
6 Comments
 
LVL 4

Accepted Solution

by:
williamvanerp earned 2000 total points
ID: 33648660
It looks like the script is converting special characters into another text. If these characters are used in usernames, you don't easily search and replace since the problobly whould be all different. If its something like a department name, you should get the same results and search and replace program may fix it for you fast and easy.
0
 
LVL 4

Expert Comment

by:williamvanerp
ID: 33648663
Looks like its converting special characters into another text. Characters like
0
 

Author Comment

by:InnocentDrinks
ID: 33661277
thanks, is there any way i can tell what this is referring to?, it just seems to be randomly selecting users and replacing their information with random characters like aboev.
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 4

Expert Comment

by:williamvanerp
ID: 33710699
If its random it is not like i discribed. Have you tried to run the command to the 2003 server directly and to the 2008 server to see if there is a difference in outcome? Try this CSVDE -f c:\temp\grpmem.txt -s Servername -l "dn,member" -r objectClass=group where Servername is the name of your 2003 / 2008 DC.
0
 

Author Comment

by:InnocentDrinks
ID: 33718357
Hi Will,

After more investigating it seems like it was trying to convert special characters in usernames.  Im not sure why this problem didnt show itself up before but at least i know why it is doing it.  Also just by having 1 member with this special character it will try to convert the whole output string i.e. it does not leave non special usernames intact. wierd
0
 

Expert Comment

by:CarlyleServiceDesk
ID: 35729020
Hi all,

Did anyone find a resolution to this?  Out of around 1000 users in our AD, this is happening to 8 accounts only.  The exported data looks fine (with CN= group membership information) for all users except those 8 accounts. I can't seem to find anything unique about those accounts. They definitely don't have elevated privileges.

Thanks,
Nick
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Had a business requirement to store the mobile number in an environmental variable. This is just a quick article on how this was done.
Here's a look at newsworthy articles and community happenings during the last month.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses

752 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