2 Replies Latest reply on Jan 6, 2009 8:14 AM by sotherls

Time in CustomPollerStaus off??

sotherls Jan 6, 2009 5:51 AM

Has anyone else seen this problem? I just noticed that the posted time in my CustomPollerStatus table is off by 6 hours. I checked and the servers (all three new Orion 9.1 SP2 and SP3 build servers) report the same anomoly.

I ran this query from SQL to see what it reports and can see the difference - not sure why. I have opened a case with Solarwinds but nothing yet?

select getdate()
select * from custompollerstatus
where datetime >'2009-01-06'
order by datetime desc

Results in:
2009-01-06 05:39:03.550

3DF02575-878C-49BB-AE01-94DA501AC9E6              2009-01-06 11:38:47.130
8F512DBF-5F87-4595-B969-0C13263117F8              2009-01-06 11:38:27.223
DC24663D-2433-4C2C-B17A-2505537CDB08            2009-01-06 11:38:22.817

Re: Time in CustomPollerStaus off??

casey.schmit Jan 6, 2009 7:28 AM (in response to sotherls)

With 9.0, we started using UTC time for the status and statistics(on Universal Device Pollers). I'm pretty sure this is what you are seeing.
Like Show 0 Likes(0)

Actions
- Re: Time in CustomPollerStaus off??
  
  sotherls Jan 6, 2009 8:14 AM (in response to casey.schmit)
  
  Thank you! Finally an answer that makes sense... I guess technical support did not get the memo....
  In any case I modified my reports and queries to include the adjustment for the time change.
  dateadd(hour, -6, datetime) will adjust for the variance.
  
  Like Show 0 Likes(0)
  
  Actions

Go to original post