DB Servers in different Time zone

Sep 26, 2012 at 3:51 PM

Wanted to check to see if anyone was using EPM  on DB servers that are in different time Zones.  The issue that i am running into is with @lastlogBackupdate and @lastbackupdate.

My EPM server is in EST but i have several servers in CST ,MST and GMT.  It appears that is using the current datetime in the EPM and compares that to the values returnend from the policy results. i was going to convert everything to UTC however it look like datediff is not included in the policy expressions. So before i reinvent the wheel wanted to check to see if anyone has run into this

 

Thanks