Just noticed a new default when editing user accounts

[SteveBeauchemin]

In Admin > Manage Users > edit a user

CCM-Access.PNG

I see that CCM access = Login by default.

Can that default be changed globally somehow?

I have many accounts and will have to edit 200+ to turn that to "none'.

Can someone provide a SQL statement for me to fix this maybe?

Also can there be a default control for this? If there is already a control, please let me know. I need it set to none for all user additions.

Thanks

Steve B

[npolovenko]

Hello, @SteveBeauchemin. If I click on "Add new user" in XI it defaults to None. But to change this option to none for all existing users you can try executing the following query:

echo "UPDATE xi_usermeta SET keyvalue = '0' WHERE keyname='ccm_access';" | mysql -u root -pnagiosxi nagiosxi

*Please back up your XI before running the command.

[SteveBeauchemin]

After I run this - will I have caused my admin users a problem?

I can probably construct a query to skip them. Or if you know the syntax I'll take what I can.

All my existing users are set to Login. Sounds like the new user default is good.

Thanks for the info

Steve B

[npolovenko]

@SteveBeauchemin, Looks like the nagiosadmin user doesn't have such field so it's automatically excluded from this query. And for other users, if the authorization level is set to -> Admin then the ccm_access keyvalue seems to be ignored. So I'd say this query should work fine for all types of users.
Please backup XI server.

[SteveBeauchemin]

Thank you for looking in to this. I will use ESX snapshot when I run the query just in case.

Probably not gonna run this until my next upgrade cycle.

You can close this.

Thanks!!

Steve B

[scottwilkerson]

Thank you for looking in to this. I will use ESX snapshot when I run the query just in case.

Probably not gonna run this until my next upgrade cycle.

You can close this.

Thanks!!

Steve B

great, Locking