I am currently trying to import text data from Zabbix into Grafana. Actually I have managed this by selecting the Text query mode and then drilled down to the item. I have then selected table as the visualisation and the data is loaded into a table. The issue is that one field has multiple pieces of data. The template it comes from is the Zabbix TCP/UDP CONNECTIONS TEMPLATE - this lists items such as a Listening TCP ports etc.
The problem I have is 2 fold
- Can I show only the “Last Value” field and hide the other fields
- The “Last Value” field has something like "TCP 0.0.0.0:80 0.0.0.0:0 LISTENING 2152 TCP 0.0.0.0:135 0.0.0.0:0 LISTENING 904 TCP 0.0.0.0:443 0.0.0.0:0 LISTENING 2152 " - I would like to be able to grab just the port numbers out of the text and then list them each in a new line (possible??) for each port
Any assist would be greatly appreciated