How do I move a string cat operation from the search and store it in an extracted field option that Splunk offers under events? This way the string cat won't appear in the search.
I can use string cat to create my fields the way I want with this format subrackNo "-" SlotNo "-" boardType
... | strcat subrackNo "-" SlotNo "-" boardType fields | timechart max(kpi) by fields
And this give me this format
0-1-SPUb
0-11-SPUb
0-16-GOUa
THis is one of the rows from my data set:
2016-12-18 23:59:59,DeviceName=Device1,subrackNo=2,boardType=GOUc,SlotNo=23,SubsystemNo=1,CPUoccupancy=3,Throughputoccupancy=0
Now what I want to be able to do is do this in the extracted field option that splunk offers, so I don't have to do it in the search as I am doing with the string cat above. So this way my search could be like this with the string cat removed.
... | timechart max(kpi) by fields
EDIT1
this might the path to take using regex - https://regex101.com/r/nPatfn/1
... View more