How to set location time zones automatically for cmn_location table?

[Ujjwala1]

Hello Experts,

We have around 20,000 plus locations in location table. The value may get increased in future. Our client wants to have some mechanism to get implemented in the system through which system should automatically update the time zone based on the city for that location.

Is there any way we can do so?

Please guide me for that.

Any kind of help here is highly appreciated.

Thank you in advance, 

Ujjwala 

[Yousaf · Accepted solution]

Hi Ujjwala,

Please refer to these links it has a discussion about what you want to acheive 
Auto Set Time Zone according to location

https://community.servicenow.com/community?id=community_question&sys_id=280eea8bdb930550fd8d2b691396...

Mark Correct or Helpful if it helps.

Thanks,

Yousaf