Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1658
  • Last Modified:

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

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
InnocentDrinks
Asked:
InnocentDrinks
  • 3
  • 2
1 Solution
 
williamvanerpCommented:
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
 
williamvanerpCommented:
Looks like its converting special characters into another text. Characters like
0
 
InnocentDrinksAuthor Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
williamvanerpCommented:
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
 
InnocentDrinksAuthor Commented:
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
 
CarlyleServiceDeskCommented:
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now