• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

SSAS Query Log has future timestamps?

I have a cube with query log enabled.  When I look at the query log table, I found there are times in the future.  Is it using UTC?  Thanks.
0
thomaszhwang
Asked:
thomaszhwang
1 Solution
 
ValentinoVBI ConsultantCommented:
Perhaps your SSAS server date/time settings are a bit off?
0
 
mlmccCommented:
Are these legitimate values?  So long as they are then they will be the same as other timestamps in the database.

WHen you say future, how far in the future?
Are they simply the number of hours you are behind GMT?
ie here in the Central US at 08:21 (CDT) 1 the time saved or logged would be  14:21 so the time seems to be in the future.

If that is the difference then it is most likely a UTC time

mlmcc
0
 
thomaszhwangAuthor Commented:
Yes, it's exactly the UTC time.  Thanks.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now