Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Server & Application Monitor (SAM) > 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: 152 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