|
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? |
|
One of several options: Also, see previous thread:
Does anyone know why this isn't handled automatically in the
(09 Nov '10, 15:23)
Lowell ♦
Easy enough to modify the script yourself, but agreed that at least
(10 Nov '10, 02:38)
southeringtonp ♦
|
