Hi Splunker,
I want to rename an unknown field name from a JSON file. Please find the minimal example below:
{"timestamp": "2018-10-24T08:46:02.205664",
"type": "sw",
"serial": {"Switchah3nv": "000123456789"},
"system_time": "Wed Oct 24 08:46:04 CEST 2018",
.....
}
{"timestamp": "2018-10-24T08:47:02.205664",
"type": "fw",
"serial": {"Switchcklaie7": "000987654321"},
"system_time": "Wed Oct 24 08:47:04 CEST 2018",
.....
}
I'm trying to make a table for all the serial numbers. So something like:
hostname | serial_number
Switchah3nv |000123456789
Switchcklaie7 |000987654321
I'm able to rename one serial by using | rename serial.Switchah3nv AS serial_number , but I need something like | rename serial.{} AS serial_number or | rename serial.hostname AS serial_number
So anyone got an idea?
Best regards,
Sebastian
... View more