Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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: 1,312 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