Hello everyone,
I having issues using Splunk to read and extract fields from this JSON file.
I would appreciate any help.
json data
{
"uid" : "a82ee257",
"name" : "Throughput Utilization",
"axisXType" : "DateTime",
"elementReports" : [ {
"element" : {
"id" : "001",
"name" : "NS-001",
"type" : "NetworkSegment"
},
"series" : [ {
"uid" : "3242d4e4",
"instance" : "0",
"name" : "Utilization",
"data" : [ {
"x" : 1551051000000,
"y" : 0.0
}, {
"x" : 1551051300000,
"y" : 3.1
}, {
"x" : 1551136800000,
"y" : 7.4
}, {
"x" : 1551137100000,
"y" : 1.6
} ],
"e" : 1
} ]
}, {
"element" : {
"id" : "002",
"name" : "NS-002",
"type" : "NetworkSegment"
},
"series" : [ {
"uid" : "4654d4e4",
"instance" : "0",
"name" : "Utilization",
"data" : [ {
"x" : 1551051000000,
"y" : 0.3
}, {
"x" : 1551051300000,
"y" : 0.0
}, {
"x" : 1551051600000,
"y" : 0.0
}, {
"x" : 1551137100000,
"y" : 2.12
} ],
"e" : 1
} ]
}, {
"element" : {
"id" : "003",
"name" : "NS-003",
"type" : "NetworkSegment"
},
"series" : [ {
"uid" : "2481d4e6",
"instance" : "0",
"name" : "Utilization",
"data" : [ {
"x" : 1551051000000,
"y" : 0.0
}, {
"x" : 1551051300000,
"y" : 0.0
}, {
"x" : 1551051900000,
"y" : 0.0
}, {
"x" : 1551136800000,
"y" : 0.0
} ],
"e" : 1
} ]
}, {
"element" : {
"id" : "004",
"name" : "NS-004",
"type" : "NetworkSegment"
},
"series" : [ ]
} ]
}
Here is my setting:
[json_sample]
TRUNCATE = 0
SHOULD_LINEMERGE=false
LINE_BREAKER = (,*){\s+"element"
Here is what I am expecting:
element.id,element.name,element.type,element.series.uid,element.series.instance,element.series.name,data.x,data.y,,,,
001,NS-001,NetworkSegment,3242d4e4,0,Utilization,1551051000000,0.0,,,,
001,NS-001,NetworkSegment,3242d4e4,0,Utilization,1551051300000,3.1,,,,
001,NS-001,NetworkSegment,3242d4e4,0,Utilization,1551136800000,7.4,,,,
001,NS-001,NetworkSegment,3242d4e4,0,Utilization,1551137100000,1.6,,,,
002,NS-002,NetworkSegment,4654d4e4,0,Utilization,1551051000000,0.3,,,,
002,NS-002,NetworkSegment,4654d4e4,0,Utilization,1551051300000,0.0,,,,
002,NS-002,NetworkSegment,4654d4e4,0,Utilization,1551136800000,0.0,,,,
002,NS-002,NetworkSegment,4654d4e4,0,Utilization,1551137100000,2.12,,,,
003,NS-003,NetworkSegment,2481d4e6,0,Utilization,1551051000000,,,,,
003,NS-003,NetworkSegment,2481d4e6,0,Utilization,1551051300000,,,,,
003,NS-003,NetworkSegment,2481d4e6,0,Utilization,1551136800000,,,,,
003,NS-003,NetworkSegment,2481d4e6,0,Utilization,1551137100000,,,,,
... View more