12-20-2017 03:39 AM - edited 03-17-2019 11:48 AM
Hello,
We upgraded our CUCM Cluster to 11.5SU2 in April 2017. Now we want to Change some Permission Things so that the Customer can do some things without our help. (Assign spec. Access Control Group to Enduser - Permission Group).
Thererfore we defined some Access Control Groups with User Rank id 8. The Customer should only be valid to assign ACGs with id 8 to enduser. Therefore we should change the (8000) Enduser to User Rank id 8.
Question
In the moment all Enduser are in User Rank 1 (=Default User Rank). We want to change the Enduser to User Rank 8 (=Enduser Rank). We created this User Rank. The problem is that we cannot change via BULK Tool the Enduser User Rank Field.
It seems that we should change this field manual. Because we have about 8000 Enduser this is not very comfortable. Does anybody know a hint to solve our problem (Change User Rank via BULK or SQL) ?
thanks
regards
alex
12-20-2017 09:01 AM
12-20-2017 02:25 PM
Sorry, but in the user export list we do. not see a 'user rank' id field :-(
08-01-2018 03:55 AM
Hi, did you manage to nail this question down ?
12-04-2019 05:49 AM
Hi,
we got into the same situation.
Additionally, when downgrading a user to a lower rank, in the webinterface all assigned 'Access Control Groups' are being removed.
I figured the following SQL query:
run sql update enduser set userrank = '5' where userid in ('user1','user2')
I tried this with single users successfully without losing the assigned 'Access Control Groups', but I'm not sure what might happen, when I roll this out to all endusers.
I definitely would prefer a Bulk Job Solution.
03-18-2020 12:21 AM
Hi
we solved the problem via cli
run sql ccm update enduser set userrank="8" where userrank="1" and userid like "%.032"
with the like filter we convert 6000 user in 10 Minutes from userrank 1 to 8
without loosing Access Group Def.
But this szenario is not tac supportet - so caution
regards
alex
03-18-2020 01:42 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide