Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Date format in local time in SAM is different from UTC in NPM

Date format in local time in SAM is different from UTC in NPM

Table of contents
Created by Jamin Walters, last modified by MindTouch on Jun 23, 2016

Views: 1,375 Votes: 1 Revisions: 5

Overview

This article provides information when comparing tables that are part of NPM or Orion core to tables which are also part of SAM date formats display inconsistency. NPM tables are stored in UTC date format and many of the SAM tables are stored in local time. 

Environment

  • All versions of SAM
  • All versions of NPM

Detail

When trying to compare date and time values from NPM tables to APM (SAM) tables, the NPM tables have date time values in UTC format, while APM tables are in local time. 

 

Example tables from SWQL studio would be Orion.NPM.InterfaceTraffic  and Orion.APM.HistoricalMemory. 

Currently this would be suggested as a feature request. 

For reference, see:

https://thwack.solarwinds.com/ideas/3000 

 

 

Last modified

Tags

Classifications

Public