How is the Timezone set for the Metrics engine in HEAT 2013/2014.x?

Version 1

    Details

    How is the Timezone set for the Metrics engine in HEAT 2013/2014.x?


    Resolution

    Metric engine has 2 types of metrics:   1) Regular metrics where date/time aggregates (e.g. count group by datetime) are computed dynamically using SQL engine  2) Historical metrics (analytic snapshot) where Metric engine perform schedule jobs and store calculated aggregates in Metrics table  For regular metrics, group by is performed by database engine. Since datetime value is stored in UTC, group by is always in UTC, and no possibility to show metrics by specific time zone.  For historical metrics (analytic snapshots), metrics engine can perform timezone shift. customer can define metrics for specific timezone.