Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Alert Reports generation using Insights


#1

I have been trying to pull alert incident reports from Insights and when I am pulling the results in CSV format the results are coming in Excel with 13 digit Integer.

in which time zone the reports will be generated EST/PST?


#2

Hey @rajeshkumar.avn - The reason you are getting a 13 digit integer is that Timestamps are recorded as epoch time - You can convert that to a human readable time here: https://www.epochconverter.com/

You’ll see that for example, right now it is 9:35am on Friday 29th November, but in Epoch time it is: 1575020139

You’ll be able to find some formula for converting Unix Epoch times to dates in Excel, here’s an example: https://exceljet.net/formula/convert-unix-time-stamp-to-excel-date