@matt8679 This a snippet from my current search index="x_devices" AND falcon_device.hostname=myhost
| spath
| stats count, min(_time) as firstTime, max(_time) as lastTime, max(_indextime) as recentTime, BY x_device.hostname, x_device.last_seen
| fieldformat firstTime=strftime(firstTime,"%m/%d/%Y %H:%M:%S")
| fieldformat lastTime=strftime(lastTime,"%m/%d/%Y %H:%M:%S")
| fieldformat recentTime=strftime(recentTime,"%m/%d/%Y %H:%M:%S")
| fieldformat lastUpdated=strftime(lastUpdated,"%m/%d/%Y %H:%M:%S")
| fields + x_device.hostname, x_device.last_seen, firstTime, lastTime, recentTime, lastUpdated, timeElapsed, hash, timeElapsed The x_device.last_seen field in the following format 2022-08-24T22:06:01Z I can seem to get x_devices.last_seen in an epoch format. I am currently only trying to change that field since all of my other times are already in the correct format. It appears that I may need to make modifications to transforms.conf
... View more