Hello I have this query : index="report" Computer_Name="*" |chart dc(Category__Names_of_Patches) as totalNumberOfPatches by Computer_Name
| eval exposure_level = case(
totalNumberOfPatches >= ...
See more...
Hello I have this query : index="report" Computer_Name="*" |chart dc(Category__Names_of_Patches) as totalNumberOfPatches by Computer_Name
| eval exposure_level = case(
totalNumberOfPatches >= 3 AND totalNumberOfPatches <= 6, "Low Exposure",
totalNumberOfPatches >= 7 AND totalNumberOfPatches <= 10, "Medium Exposure",
totalNumberOfPatches >= 11, "High Exposure",
totalNumberOfPatches == 2, "Compliant",
totalNumberOfPatches == 1, "<not reported>",
1=1,"other"
)
| stats count(Computer_Name) as totalNumberOfPatches by exposure_level
| eval category=exposure_level Looks like I've lost the _time field on the way so when im trying to run timechart im getting no results