How to set User CI and user settings fields based on country

Justin_Clarke

I have a large user base across many countries and regions globally. We are already syncing user information from AD including country and state. Is there any way to set the users timezone on the User CI in SCSM to the correct timezone? If this is not set users recieve times and dates in email notifications based on where the servers timezone.

Also is there a way to also set the language and date time setting in the portal for users based on the country and state field?

So if i have a user in australia and Queensland it will set my timezone as being +10 and my date time to English (Australia)?

thanks for your help

Justin

Konstantin_Slavin-Bo

We also only use 1 timezone and language setting for our users, but you could achieve both things with Orchestrator or Powershell. For SCSM, both the time zone and locale is located in the UserPreference.Localization object, which is related to the User CI with the UserHasPreference relationship. For the portal, the settings is located in the ServiceManagement DB in the CI$User table; [LocaleID] and [TimeZone].

So you should get the User CI, and get the Localization object through the UserHasPreference relationship (or simply "Localization" for Orchestrator). Now, if the relationship exists, you simply need to update it. If not, you will need to create a new Localization object (remember to generate a GUID), update it with the correct values from the User CI fields you have synced, and relate it to the User CI.

At the same time, you can update the CI$User table to match the preferences synced to the User CI.

Brian_Wiest

My environment is English only. Hopefully someone else with different countries can chime in. But if you have a testing lab if you review the ServiceManagement database. The CI$User table there is a column for LocaleID and TimeZone. Thinking you can update via script to mass set for your community.
HTH

Konstantin_Slavin-Bo

We also only use 1 timezone and language setting for our users, but you could achieve both things with Orchestrator or Powershell. For SCSM, both the time zone and locale is located in the UserPreference.Localization object, which is related to the User CI with the UserHasPreference relationship. For the portal, the settings is located in the ServiceManagement DB in the CI$User table; [LocaleID] and [TimeZone].

So you should get the User CI, and get the Localization object through the UserHasPreference relationship (or simply "Localization" for Orchestrator). Now, if the relationship exists, you simply need to update it. If not, you will need to create a new Localization object (remember to generate a GUID), update it with the correct values from the User CI fields you have synced, and relate it to the User CI.

At the same time, you can update the CI$User table to match the preferences synced to the User CI.

Justin_Clarke

Thanks for the response, i will look into creating a script to do this.

Konstantin_Slavin-Bo

Great, let me know, if you need any help with the script.

Konstantin_Slavin-Bo

Did you get the script done?