Gestion des journaux
Mis à jour
Ce contenu vous a-t-il été utile ?
Ce contenu vous a-t-il été utile ?
SCEPman_CL
| where Level == "Warn" or Level == "Error" or Level == "Fatal"SCEPman_CL
| where Level == "Info" and Message startswith_cs "Issued a certificate with serial number"
| project Message, RequestBase = trim_end('/', replace_string(replace_string(replace_regex(RequestUrl, "(/pkiclient\\.exe)?(\\?operation=PKIOperation(&message=.+)?)?", ""),"certsrv/mscep/mscep.dll","intune"),"step/enrollment","activedirectory"))
| summarize IssuanceCount = count() by Endpoint = extract("/([a-zA-Z]+)$", 1, RequestBase)SCEPman_CL
| where Level == "Info" and Message startswith_cs "Issued a certificate with serial number"
| project Message, RequestBase = trim_end('/', replace_string(replace_string(replace_regex(RequestUrl_s, "(/pkiclient\\.exe)?(\\?operation=PKIOperation(&message=.+)?)?", ""),"certsrv/mscep/mscep.dll","intune"),"step/enrollment","activedirectory"))
| summarize IssuanceCount = count() by Endpoint = extract("/([a-zA-Z]+)$", 1, RequestBase)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)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_s == "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)