I have a event similiar to one below:
Server Status - ServerName - RUNNING
JMS Queue - ServerName : Module1!JMSServer1@QueueName1 , 0, 0, 13, 45, 0, 1345, 800
JMS Queue - ServerName : Module2!JMSServer1@QueueName2 , 0, 0, 3, 14, 0, 15, 800
JMS Queue - ServerName : Module3!JMSServer2@QueueName3 , 0, 0, 23, 24, 0, 13, 800
JMS Queue - ServerName : Module4!JMSServer3@QueueName4 , 0, 0, 25, 35, 0, 1, 800
JMS Bridge - ServerName:BridgeName1,Forwarding messages.
JMS Bridge - ServerName:BridgeName2,Forwarding messages.
This complete snippet is a single event.
This gets written onto a file at regular interval (JMS Queues and JMS Bridges status) which is monitored by splunk,and this complete thing is indexed as a single event with multiple lines,
Now i would like to extract info from this event and show in following table format in panel in dashboard
QueueName Field1 Field2 Field3 Field4 Field5 Field6 Field7
QueueName1 0 0 13 45 0 1345 800
QueueName2 0 0 3 14 0 15 800
QueueName3 0 0 23 24 0 13 800
QueueName4 0 0 25 35 0 1 800
... View more