filtering time and CSV export not matching selected time

[rosieodonell]

When I search a string in the Nagios log server and select custom time of 24 hours (Mar 29, 2020 00:00:00 to Mar 29, 2020 23:59:00). the time in the filtering shows (time must, field: @timstamp from: "2020-03-29T07:00:00:000Z" to: "2020-03-30T06:59:00.000Z". The information below shows correct for the time I have selected. But when I do CSV export of the data, it seems to export the wrong time data from the filtering section of 07:00 - 06:59.

So basically I can't export the data when using a custom time. I was on older code (2.13) and upgraded to the latest code of 2.15. Please reach out to me to assist this is a big failing if this isn't a quick fix.

[benjaminsmith]

Hi @rosieodonell,

First of all, welcome to the Nagios Support forum and thank you for trying out Nagios Log Server. I ran a some similar queries and I didn't seem to get the sames results, so I'd like to clarify a few things.

1. You did not experience this issue on 2.1.3, but since upgrading to 2.1.5? Is this correct?

But when I do CSV export of the data, it seems to export the wrong time data from the filtering section of 07:00 - 06:59.

2. Could you provide a screenshoot of the CSV export, so we see what's happening to the time data?

[cdienger]

I think part of the problem may be due to how the table adjusts the table results automatically to fit the browser's local time(and the export doesn't do this same conversion). If you disable the "local time" option like in the screenshot you should see that the exported csv times match what the table then shows. Another thing keep in mind is that the export tool will only export the data found in the table. This is set to 250 results by default and if this is a busy machine then this could easily limit the time frame seen in the results. Use the "Paging" section of the Table Settings screen to adjust this.