Applications Systems

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

Reference this article when comparing tables that are part of NPM or Orion core to tables which are also part of SAM and the date formats are different. NPM tables are stored in UTC date format and many of the SAM tables are stored in local time.

First published date

10/16/2018 8:33 PM

Last published date

4/21/2022 9:15 AM

Overview

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

Product section

Server Application Monitor

Resolution

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 

Orion.APM.HistoricalMemory

The same concept applies to Alerts and Events. Alerts table follow UTC while the Events table follow the Orion server time.

Currently this would be suggested as a feature request. For reference, see: https://thwack.solarwinds.com/ideas/3000

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.