[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
Updating a user attribute to the same value as a different attribute  XML
Forum Index » General Discussion
Author Message
ssa1



Joined: 29/06/2008 00:57:13
Messages: 3
Offline

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.

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

support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

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.


 
Forum Index » General Discussion
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.9 © JForum Team