cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to specify a duration time literals when parsing JSON using DQL?

strudeau
Participant

Hello, I am attempting to parse the following json:

 

 

 

{"ResultCode": "Ok",
"DurationMs": "450.1132",
"PerformanceBucket": "250ms-500ms"}

 

 

I use the following DQL in my notebook:

 

 

fetch logs
| parse content, "JSON{STRING:ResultCode, STRING:PerformanceBucket, DURATION:DurationMs}:parsedContent"

 

 

How can I specify that the Duration is in milliseconds instead of nanoseconds (which is the default)? It looks like the DURATION datatype doesn't allow to pass a duration time literals argument...

Thanks

DQL data types - Dynatrace Docs

1 REPLY 1

ChadTurner
DynaMight Legend
DynaMight Legend

can you add in mathematical operators to take your nano and multiply it by 1,000,000?

nanoseconds = (5 ms × 1,000,000) = 5,000,000 ns

-Chad

Featured Posts