Solved

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

Posted on 2010-09-10
6
1,604 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
  • 3
  • 2
6 Comments
 
LVL 4

Accepted Solution

by:
williamvanerp earned 500 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
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!

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
what about DCpro 2 30
Event 4625 - Account Name: _ 3 29
Whitelisting applications 2 23
Unable to add new user to AD 2 24
Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

822 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