Scheduled reports date time issue due to different timezones

nis · ‎06-15-2017

Hi,

I have a couple of reports that need to be scheduled to be sent to different locations - separate job has been defined for for each location.

The issue we are facing is that when currently the date is being displayed in the server's timezone i.e. CET and all the users are receiving reports in CET timezone.

I would like to know if there are any capabilities in ServiceNow where I can run the different scheduled report using a different user profiles.

Or if there is any way I could solve this issue.

The reason why we need in the recipients timezone is because the dates being displayed are details like Meeting start time and end time etc.

Best Regards,

Nisha

nis · ‎06-23-2017

Hi,

I have managed to fix this.

So, each scheduled job has a field "Run As". This is not displayed by default in the UI - you could configure the layout to add this field on the UI.

Now, for various jobs I assign a different user-id each of them having their specific timezone.

Now when the report job is executed the results are in the run-as user-ID's timezone set in their user-preference.

Best Regards,

Nisha

View solution in original post

Vimal Priya · ‎06-15-2017

Hi Nisha,

If your system in CET timezone and you are required to send email in IST time ex.9.00 a.m IST then convert the IST to CET tz and set (5.00 a.m CET) in scheduled job.

nis · ‎06-15-2017

Hi Vimal,

I am not looking for the timezone issue in scheduling the reports.

I am talking about the content in the report. These are currently being displayed in CET. I want the contents of the report to be displayed as per the recipient time zone.

The highlighted items in screenshot need to be converted to various timezones before being sent as an attachment via email.

Best Regards,

Nisha

jyoti29208 · ‎06-15-2017

Hi Nisha,

I faced this issue 2 days ago. Go to timezone dictionary and check the choice options that it should not have java script option there. if there is any. please make it inactive.

Otherwise raise a Hi ticket regarding the same.

Please provide your feedback appropriately (Like, Helpful, Endorse AND/OR Correct) to help community.

Thank you!

Regards,

Jyoti

nis · ‎06-15-2017

Hi Jyoti,

Thank you for your quick response but I would like to understand how would this change ensure that different scheduled reports have dates automatically converted to their corresponding timezone?

Also,can you give details on how I can get this timezone dictionary for reporting module?

Best Regards,

Nisha