let map_certtype = datatable(serial_start:string, readable:string)
[
"40", "Intune Device",
"41", "Intune Device",
"42", "Intune Incompliant Device",
"50", "Static",
"51", "Static",
"60", "Intune User",
"61", "Intune User",
"64", "Jamf User",
"65", "Jamf User",
"6C", "Jamf User on Device",
"6D", "Jamf User on Device",
"70", "Domain Controller",
"7C", "Jamf User on Computer",
"7D", "Jamf User on Computer",
"54", "Jamf Computer",
"55", "Jamf Computer",
"44", "Jamf Device",
"45", "Jamf Device"
];
SCEPman_CL
| where LogCategory == "Scepman.Server.Controllers.OcspController" and Level == "Info"
| where Message startswith_cs "OCSP Response"
| project serial = extract("Serial Number ([A-F0-9]+)", 1, Message)
| distinct serial
| extend serial_start = substring(serial,0,2)
| join kind=leftouter map_certtype on serial_start
| summarize count() by (readable)