We help IT Professionals succeed at work.

SSAS Query Log has future timestamps?

Medium Priority
540 Views
Last Modified: 2016-02-14
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.
Comment
Watch Question

ValentinoVBI Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
Perhaps your SSAS server date/time settings are a bit off?
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
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

Author

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

Explore More ContentExplore courses, solutions, and other research materials related to this topic.