Getting Data In

Windows FileTime timestamp to human readable

luckyb56
Explorer

I tried a lot to convert windows filetime timestamp [web]support.microsoft.com/kb/188768) to human readable using TIME_FORMAT, but was not able to. One sample timestamp is 130308696850032106. This is supposed to be Saturday, December 7, 2013 1:01:25am.
I get this when choosing input format as 'filetime' at [web]silisoftware.com/tools/date.php

Can anyone give me any hint/pointers as to what TIME_FORMAT be set to? I tried with %s%9N but it renders as something else. I have tried convert mstime and ctime, but doesn't help.

0 Karma

luckyb56
Explorer

Got the answer @answers http://answers.splunk.com/answers/63559/multiple-events-and-multiple-key-value-pairs-one-being-times...
To be exact the eval for win32 time should be eval human_time=strftime(time/10000000-11644473600,"%Y-%m-%d %H:%M:%S")

0 Karma

luckyb56
Explorer

Is there anyway I could do this in props.conf while indexing and overwrite the _time value with the above calculated one?

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...