Jon Clyde IT Blogs

Enterprise IT and Technology Blogs

‘Location’ field in Outlook appointment does not book a room

Hi All,

I just wanted to do a quick blog on a  feature of outlook that can cause confusion for users and has been brought to me a few times in the past.

When you create a new appointment in Outlook, you will notice there is a ‘location’ field. When clicking on the arrow, a dropdown displays any previously used locations.


However, it’s important to note that the location is just an informational text field and will not book a meeting room if entered. This can cause confusion because the names of meeting rooms may be populated in the list from when rooms have been booked for meetings in the past.

In order to book a meeting room, you should use the scheduling assistant or invite the room as an attendee.

Hope this helps!

Reset Airwatch console password in SQL Management Studio

The symptoms
You cannot access the Airwatch console of your on premise airwatch environment

The cause
The password for the administrator account(s) has been lost or forgotten

The solution
The password of an Airwatch account can be reset with a few SQL queries run on the Airwatch database in SQL management studio

The blog

I recently needed to reset a forgotten password for the administrator account of an on premise airwatch environment (version 7) and just wanted to share the steps I followed (provided by Airwatch support) in order to complete this in SQL Management Studio.

1) Open SQL Management Studio and connect to the airwatch SQL instance

2) First of all, we need to find out the ‘CoreUserID’ of the user account that is having it’s password reset.

Run the following SQL query and make note of the ‘CoreUserID’ of the account you are resetting the password for:

use AirWatch

Select * from CoreUser;

3) After you have obtained the CoreUserID above, run the following command to reset the password. Ensure the query is updated with your CoreUserID

UPDATE CoreUser SET Password = ‘c2otxl1SURGxVibCX1K9IJvyizYl4ylnIIfXhwNtfe1iCuuVM8LNPK1oWWSwE3C3BB3AYxspGqrfXaVnryxjzw==’ , PasswordSalt = ‘6eklCHP5ixaMT9RREfQbmi4Z2jc=’ WHERE CoreUserID = <COREUSERID>;

After you have ran this command, you will be able to access the account using the password ‘a123b456c789’.

Remember to change your password as soon as you get logged in.

Hope this helps

© 2016 Jon Clyde IT Blogs

Theme by Anders NorenUp ↑