I am having a difficult time extracting fields for data returned by iostat. Has anyone been able to extract these individual fields? Data below:
Device rReq_PS wReq_PS rKB_PS wKB_PS avgWaitMillis avgSvcMillis bandwUtilPct
sda 0.00 208.00 0.00 1644.00 1.45 0.02 0.50
sda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sda2 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sda5 0.00 208.00 0.00 1644.00 1.45 0.02 0.50
sda6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Does multikv
not work for you?
| stats count | eval _raw="<your data above>" | multikv | fields - _raw count
Seems to work as expected.