Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • 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

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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