Here is how I calculated CPU percentage for Type70 rcds. This is a Splink macro I created. One problem was determining the nbr of CPs which was in another 70 rcd you had to process. eval z15_epoch = strptime("2021-01-16 20:00:00", "%Y-%m-%d %H:%M:%S") | eval nbrcp = case((SMF70CIX == 1 AND _time >= z15_epoch), 7, SMF70CIX == 1, 9, 1 == 1, 2) | eval key = case(SMF70CIX == 1, "CPU",1 == 1, "IIP") | eval CPUPct = round((((SMF70PDT / 1000000) / (nbrcp*(SMF70ONT / 1000000))) * 100),2)
... View more