cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
609
Views
0
Helpful
1
Replies

SQL query to udate end user

Ronit Malhotra
Level 1
Level 1

Could you help me with sql query to update Home Cluster and Enable user for CM IM and Presence under service Settings in end user page

 

1 Reply 1

Slavik Bialik
Level 7
Level 7

I wouldn't suggest doing that. I once tried a VERY simple UPDATE query on Unity Connection, and the whole database got corrupted and I had to re-install the whole system.

 

Besides, why would you want to do that with a SQL query if you can simply doing it with a bulk?
Just go to: Bulk Administration -> Users -> Updates Users -> Query. If you intend to update all the users, just press "Find" and it'll show all of them, then you can go and change those specific settings for all of your users in one simple bulk.
If you want to change only specific users, so just go to:
Bulk Administration -> Users -> Updates Users -> Custom File

 

There you can run a custom file that you need to create. I attached you an example as CSV file, this is the correct template to do that.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: