Updating a user attribute to the same value as a different attribute

This message was edited 1 time. Last update was at 08/02/2010 19:55:39

I'm trying to write a SQL query that will update a user attribute to be the same value as a different attribute, but so far all I can get it to do is make it the name of the other attribue, rather than the value.

Update CN=xxxxxx\, xx,OU=xxxxx,DC=xxx,DC=com Set extensionAttribute2 = pager

That's the query that I'm working with. Right now, it makes the value of extensionAttribute2 literally "pager." I want it to be the vlaue of the pager attribute.

Unfortunately you can't do that

The way I will handle this:

1. Export all the values of pager using a statement like this
Select pager from OU=xxx,DC=xx,DC=com
2. Export the result in csv format
3. Modify the file and generate update statements (Update CN=xxxxxx\, xx,OU=xxxxx,DC=xxx,DC=com Set extensionAttribute2= value)
4. Run those statements one by one.