Splunk Search
×
Are you a member of the Splunk Community?
Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- How to split JSON array into Multiple events at In...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
mayurr98
Super Champion
04-03-2019
03:48 PM
I have an event :
{
"local": [
{
"display_name": "juniper0",
"tenant": null,
"created": "2019-03-29",
"local_context_data": {
"ntp": {
"peers": [
"192.168.10.15",
"192.168.10.16"
]
}
},
"serial": "124334",
"asset_tag": null,
"site": {
"id": 1,
"name": "TestSite",
"slug": "testsite"
},
"virtual_chassis": null,
"primary_ip4": {
"id": 7,
"address": "192.37.28.78/24",
"family": 4
},
"cluster": null,
"tags": [],
"last_updated": "2019-04-01T09:41:41.633296Z",
"vc_position": null,
"primary_ip": {
"id": 7,
"address": "192.37.28.78/24",
"family": 4
},
"device_type": {
"id": 1,
"display_name": "Juniper test",
"manufacturer": {
"id": 5,
"name": "Juniper",
"slug": "juniper"
},
"slug": "test",
"model": "test"
},
"primary_ip6": null,
"parent_device": null,
"face": null,
"device_role": {
"id": 3,
"name": "Switch",
"slug": "switch"
},
"comments": "",
"platform": null,
"name": "juniper0",
"id": 8,
"status": {
"value": 1,
"label": "Active"
},
"position": null,
"custom_fields": {},
"rack": null,
"vc_priority": null
},
{
"display_name": "juniper1",
"tenant": null,
"created": "2019-04-02",
"local_context_data": null,
"serial": "",
"asset_tag": null,
"site": {
"id": 1,
"name": "TestSite",
"slug": "testsite"
},
"virtual_chassis": null,
"primary_ip4": null,
"cluster": null,
"tags": [],
"last_updated": "2019-04-02T18:08:16.222025Z",
"vc_position": null,
"primary_ip": null,
"device_type": {
"id": 1,
"display_name": "Juniper test",
"manufacturer": {
"id": 5,
"name": "Juniper",
"slug": "juniper"
},
"slug": "test",
"model": "test"
},
"primary_ip6": null,
"parent_device": null,
"face": null,
"device_role": {
"id": 6,
"name": "Firewall",
"slug": "firewall"
},
"comments": "",
"platform": null,
"name": "juniper1",
"id": 9,
"status": {
"value": 1,
"label": "Active"
},
"position": null,
"custom_fields": {},
"rack": null,
"vc_priority": null
}
]
}
I want this event to be split into 2 events such as :
1st Event
{
"display_name": "juniper0",
"tenant": null,
"created": "2019-03-29",
"local_context_data": {
"ntp": {
"peers": [
"192.168.10.15",
"192.168.10.16"
]
}
},
"serial": "124334",
"asset_tag": null,
"site": {
"id": 1,
"name": "TestSite",
"slug": "testsite"
},
"virtual_chassis": null,
"primary_ip4": {
"id": 7,
"address": "192.37.28.78/24",
"family": 4
},
"cluster": null,
"tags": [],
"last_updated": "2019-04-01T09:41:41.633296Z",
"vc_position": null,
"primary_ip": {
"id": 7,
"address": "192.37.28.78/24",
"family": 4
},
"device_type": {
"id": 1,
"display_name": "Juniper test",
"manufacturer": {
"id": 5,
"name": "Juniper",
"slug": "juniper"
},
"slug": "test",
"model": "test"
},
"primary_ip6": null,
"parent_device": null,
"face": null,
"device_role": {
"id": 3,
"name": "Switch",
"slug": "switch"
},
"comments": "",
"platform": null,
"name": "juniper0",
"id": 8,
"status": {
"value": 1,
"label": "Active"
},
"position": null,
"custom_fields": {},
"rack": null,
"vc_priority": null
}
2nd Event
{
"display_name": "juniper1",
"tenant": null,
"created": "2019-04-02",
"local_context_data": null,
"serial": "",
"asset_tag": null,
"site": {
"id": 1,
"name": "TestSite",
"slug": "testsite"
},
"virtual_chassis": null,
"primary_ip4": null,
"cluster": null,
"tags": [],
"last_updated": "2019-04-02T18:08:16.222025Z",
"vc_position": null,
"primary_ip": null,
"device_type": {
"id": 1,
"display_name": "Juniper test",
"manufacturer": {
"id": 5,
"name": "Juniper",
"slug": "juniper"
},
"slug": "test",
"model": "test"
},
"primary_ip6": null,
"parent_device": null,
"face": null,
"device_role": {
"id": 6,
"name": "Firewall",
"slug": "firewall"
},
"comments": "",
"platform": null,
"name": "juniper1",
"id": 9,
"status": {
"value": 1,
"label": "Active"
},
"position": null,
"custom_fields": {},
"rack": null,
"vc_priority": null
}
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
mayurr98
Super Champion
04-04-2019
11:35 AM
Solved with the following config:
[sourcetype]
KV_MODE = json
LINE_BREAKER = \}(,\s+)\{
SEDCMD-remove_footer = s/\}\s+\]//g
SEDCMD-remove_header = s/\{\s+\"local\"\:\s+\[//g
SHOULD_LINEMERGE = 0
pulldown_type = 1
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
mayurr98
Super Champion
04-04-2019
11:35 AM
Solved with the following config:
[sourcetype]
KV_MODE = json
LINE_BREAKER = \}(,\s+)\{
SEDCMD-remove_footer = s/\}\s+\]//g
SEDCMD-remove_header = s/\{\s+\"local\"\:\s+\[//g
SHOULD_LINEMERGE = 0
pulldown_type = 1
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
kamlesh_vaghela
SplunkTrust
04-03-2019
11:14 PM
@mayurr98
Can you please try below configurations in your props.conf?
[my_stanza]
DATETIME_CONFIG=CURRENT
SHOULD_LINEMERGE=true
NO_BINARY_CHECK=true
LINE_BREAKER=}(\,){
SEDCMD-break=s/({"local": \[)//g
SEDCMD-b=s/]}$//g
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
mayurr98
Super Champion
04-04-2019
11:36 AM
Thanks for the reply 🙂
Get Updates on the Splunk Community!
Dashboards: Hiding charts while search is being executed and other uses for tokens
There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...
Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...
This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...
Brains, Bytes, and Boston: Learn from the Best at .conf25
When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...
