You’re offline. This is a read only version of the page.
Management Reporter 2012 notifications have the wrong time stamp. Is there a way to fix this?
The server and my computer both have the correct time so I'm not sure where MR grabs this time stamp
when generating the notification.
*This post is locked for comments
Sure StephJ24
In my case I had 2 rows
Id
Eastern Standard Time
UTC
2 ---
UPDATE sch
SET TimezoneID = tz.id
from Scheduling.[Trigger] sch join
Scheduling.TimeZone tz
on ( sch.TimeZoneId = tz.Id)
where tz.Id ='Eastern Standard Time' AND
sch.TimeZoneId <> 'Eastern Standard Time'
Hope this helps.
Hello Ven,
Thank you for this info. I do have admin access to the db but I cannot seem to edit these tables or find the value cell. Are you able to give me a bit more detail?
Thanks, StephJ24
Hello StephJ24,
The below may work.
If you have access to ManagementReporter database (not the data mart), the time zones are stored in scheduling.Timezone table.
You may also want to look at [Scheduling].[Trigger] table and then update the TimeZoneID column.
Best of luck.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (