Enable Calendar Presence

When Cisco originally released the Cisco Unified Presence Communicator (CUPC) client several years ago, they provided end-users with the ability to share their calendar presence.
Jabber for Windows, which replaced CUPC, does not provide the same simple way for the end-user to share his/her calendar presence status (e.g. “In a Meeting” or “Available”).
In order for the end-user to “opt-in” to this feature, he/she must login to the Cisco Unified Presence User Options web page (https://[imp server]/cupuser).  Obviously, this is not the most ideal situation.
In order to enable this feature for the end-user, perform the following steps:

1. SSH into the Cisco Unified Presence Server
2. Login with the OS administrator ID and the defined password.
3. From the command prompt enter the following command, substituting “username” for the end-user account being modified:

run sql execute procedure spSetUserCalendaring((select pkid from enduser where userid like ‘username’),’t',’t')

To adjust this setting for multiple users, I leveraged Excel and the concatenate formula as follows:

• Column A: This column should contain the usernames
• Column B: =CONCATENATE(“     run sql execute procedure spSetUserCalendaring((select pkid from enduser where userid like ‘”,A2,”‘),’t',’t') “

Take the results from Column B, copy the values and paste into TextWrangler (Mac) or Notepad++ (Windows).  From here, you can copy/paste the commands into the SSH terminal.
If you notice, I added 5 spaces in front of the SQL command. During my testing, I found that some of the initial characters can be cut off when pasting multiple lines into the CLI.