Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

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,463 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