Splunk Search

Time extraction from string?

asifhj
Path Finder

I have following values in a field

+000 00:00:00.00

+000 00:00:00.03

+000 00:00:43.18

+000 00:00:20.69

+000 00:00:00.04

+000 00:00:00.01

+000 00:00:00.03

I tried the following query to extract

...| eval t = strftime(strptime(CPU_USED,"+%3N %T.%Q"),"%3N %T.%Q") | table t, CPU_USED

I am getting the output as follows

000 00:00:00.000

000 00:00:00.000

000 00:00:43.000

000 00:00:20.000

000 00:00:00.000

000 00:00:00.000

000 00:00:00.000

As u can see I am unable to get the last two digits basically they are milliseconds.

And suggestions?

Regards

Asif J.

0 Karma

adityapavan18
Contributor

Dude..%3N & %Q both denote milliseconds.
http://docs.splunk.com/Documentation/Splunk/6.0.3/SearchReference/Commontimeformatvariables

So i guess splunk timestamp processor is confused..use only one and hopefully it should work

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...