Hi,
I have a search and output.
source="risks_repor.csv"| dedup "Computer Name" | search D-
Cleaned by deletion 10 19.608%
Left alone 6 11.765%
Deleted 5 9.804%
Cleaned 4 7.843%
sum as "Some string"="Cleaned by deletion" + "Left alone"
sum1 as "Some string1"="Deleted" + "Cleaned"
16 9
this is not working i tried it....
Can you provide more information on how it didn't work? Also, please check the name of fields and apply those in the answer provided here.
Hi,
source="risks_repor.csv".....|table value count |where value="Cleaned" OR value ="Deleted"|stats sum(count) as Somestring1|
appendcols[search source="risks_repor.csv".....|table value count|where value="Left alone" OR value ="Cleaned by deletion"|stats sum(count) as Somestring]
I hope this helps..!!!