AAA,NodeName,esbqpas01
AAA,timestampsize,0
AAA,note0, Warning - use the UNIX sort command to order this file before loading into a spreadsheet
AAA,note1, The First Column is simply to get the output sorted in the right order
AAA,note2, The T0001-T9999 column is a snapshot number. To work out the actual time; see the ZZZ section at the end
CPU_ALL,CPU Total esbqpas01,User%,Sys%,Wait%,Idle%,Busy,PhysicalCPUs
PCPU_ALL,PCPU Total esbqpas01,User ,Sys ,Wait ,Idle , Entitled Capacity
SCPU_ALL,SCPU Total esbqpas01,User ,Sys ,Wait ,Idle
CPU01,CPU 1 esbqpas01,User%,Sys%,Wait%,Idle%
PCPU01,PCPU 1 esbqpas01,User ,Sys ,Wait ,Idle
SCPU01,SCPU 1 esbqpas01,User ,Sys ,Wait ,Idle
MEM,Memory esbqpas01,Real Free %,Virtual free %,Real free(MB),Virtual free(MB),Real total(MB),Virtual total(MB)
MEMNEW,Memory New esbqpas01,Process%,FScache%,System%,Free%,Pinned%,User%
MEMUSE,Memory Use esbqpas01,%numperm,%minperm,%maxperm,minfree,maxfree,%numclient,%maxclient, lruable pages
PAGE,Paging esbqpas01,faults,pgin,pgout,pgsin,pgsout,reclaims,scans,cycles
PROC,Processes esbqpas01,Runnable,Swap-in,pswitch,syscall,read,write,fork,exec,sem,msg,asleep_bufio,asleep_rawio,asleep_diocio
FILE,File I/O esbqpas01,iget,namei,dirblk,readch,writech,ttyrawch,ttycanch,ttyoutch
BBBN,000,NetworkName,MTU,Mbits,Name
NET,Network I/O esbqpas01,en0-read-KB/s,lo0-read-KB/s,en0-write-KB/s,lo0-write-KB/s
NETPACKET,Network Packets esbqpas01,en0-reads/s,lo0-reads/s,en0-writes/s,lo0-writes/s
NETSIZE,Network Size esbqpas01,en0-readsize,lo0-readsize,en0-writesize,lo0-writesize
NETERROR,Network Errors esbqpas01,en0-ierrs,lo0-ierrs,en0-oerrs,lo0-oerrs,en0-collisions,lo0-collisions
Need output into a type field with an output which looks like:
AAA
CPU_ALL
PCPU_ALL
....
This is what you want: https://splunkbase.splunk.com/app/1753/
The NMON Performance Monitor for Unix and Linux Systems will do all that for you, and more.
Without a header (in which case you could use multikv) you are really going to have difficulty getting proper context from the data the way you have it...
Actually its from that app which I need from.
I need the first strings into a field named type.
Also looking for regex without using multikv so that i could create that field.