Can someone please share a query to update a CustomPropertyX on the user profile with their Manager's Manager.
Go to Solution.
update users u ,users m,users mm set u.customproperty1=mm.username where u.manager=m.userkey and m.manager=mm.userkey limit 10;
update users u left join users m on u.manager=m.userkey left join users mm on m.manager=mm.userkey on u.customproperty1=mm.username limit 1;
I see you have replied two query, Is the query to try out as it is setting customproperty1 ?
Both will work .