topic Seperate content of the logs in different fields, in Log Analytics

Seperate content of the logs in different fields,

abhi_03 — Mon, 15 Apr 2024 08:51:05 GMT

I am looking for parse command to seperate below content from the logs, those are comma seperated

INSERT,STATISTIC,,"205456",679,"","SmSyServerPlugin","",59998,"DBP_Total_Request_Sent_Count","oioujio|ALL",0,0,0,0,0,"",1713015899987,0,"sgy",0,0,0,PC,0,0,0,0,0

Re: Seperate content of the logs in different fields,

AntonPineiro — Mon, 15 Apr 2024 06:49:29 GMT

Hi,

You have here a Dynatrace Pattern Language example.

If you are in Grail, I recommend you DPL Architect.

Best regards

Re: Seperate content of the logs in different fields,

PacoPorro — Mon, 15 Apr 2024 09:35:47 GMT

Example:

data record(line = "INSERT,STATISTIC,,\"205456\",679,\"\",\"SmSyServerPlugin\",\"\",59998,\"DBP_Total_Request_Sent_Count\",\"oioujio|ALL\",0,0,0,0,0,\"\",1713015899987,0,\"sgy\",0,0,0,PC,0,0,0,0,0") | fieldsAdd splitLine = splitString(line, ",") | fieldsAdd field1 = splitLine[0], field2 = splitLine[1], field3 = splitLine[2]