When I schedule the following search and send a report through email, the date/time in the attached .csv file does not show the correct format, it shows the numerical time ie. 1287990000.
index=_internal todaysBytesIndexed LicenseManager-Audit NOT source=*web_service.log | eval Daily_Indexing_Volume_in_MBs = todaysBytesIndexed/1024/1024 | timechart avg(Daily_Indexing_Volume_in_MBs) by host
Running the search in the UI and as an exported report will return a readable date.
10/25/10 00:00:00.000 AM
How do I convert the date/time format in the .csv file?
Does anyone know why this isn't handled automatically in the
sendemail.py script? I mean, does anyone ever really want to see
_time as an epoch value? Is this because of some kind of timezone thing?