Hi Shaun - whoever did your install or provides you with support should be able to supply a very standard script that does this on a daily basis via a DB script. If you rummage around on this community area, you might find one that someone has published.
1 of 1 people found this helpful
I hope you are well; you can do this by creating a scheduled bulk action to update the attribute values on your users. Steps below, before making design changes please ensure you have a verified database backup.
Add the "Time Zone Name" attribute to the end user / analyst window
Create two queries (All End Users and All Analysts) - I have just put title on the display
Create a scheduled job to update the attribute values;
Click on the Window Data button and choose the required time zone from the drop down list and click save.
I'll see your scheduled job Nathan and raise you a DB script that also handles account managers and contacts :-)
You can also set the timezone as a default value on your import mapping too. Son on your user window you will need to put the time zone attribute on and then in your import mapping right click at the top of the mapping and set default values, the user window should appear and then you can set the default timezone on your import.
And don't forget you can also set a default value on the attribute itself within Object Designer. This won't update existing users but will be used for all new records regardless of how they're created.
Thank you all for all your help it has pointed me in the right direction. As this is a test environment now, best solution is to set up the imports to default to the correct Time Zone.