[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2010-09-10
6
Medium Priority
?
1,642 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
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.
Suggested Courses

656 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