ASCDeviceEvents 數據表的查詢

發行項
11/05/2024

如需在 Azure 入口網站使用這些查詢的資訊，請參閱Log Analytics教學課程。如需 REST API，請參閱查詢。

Azure Sphere 裝置驗證和證明失敗

過去一周的 Azure Sphere 裝置驗證和證明失敗清單，依時間排序。

ASCDeviceEvents
| where OperationName == "DeviceCertificateEvent" and
        Properties.EventType == "DeviceAttestationFailure" or Properties.EventType == "DeviceCertificateEvent" and
        ResultType == "Failure" // Filter by time by adding " | where TimeGenerated > ago(7d) " for last 7 days of data or using time picker in the UI
| project TimeGenerated, DeviceId, Properties, ResultDescription, Location
| sort by TimeGenerated desc
| limit 100

Azure Sphere 裝置事件時程表

過去一周 Azure Sphere 裝置產生之所有事件的已排序時程表，用來監視和疑難解答任何非預期的失敗。

ASCDeviceEvents
| where OperationName == "DeviceCertificateEvent" or Properties.DeviceTelemetryEventCategory == "AppCrash" // Remove/Add filters to see all/specific events. Filter data by Device by adding " | where DeviceId == "Your Device ID" " 
| project TimeGenerated, OperationName, ResultType, ResultDescription, Properties, Location
| sort by TimeGenerated desc
| limit 100

Azure Sphere 裝置活動訊號事件時間圖

過去一周 Azure Sphere 裝置所起始的所有憑證產生事件的時間圖，可持續監視裝置健康情況並查看趨勢。

let Interval = timespan(1d); // Interval for the Chart 
ASCDeviceEvents
| where OperationName == "DeviceCertificateEvent" and 
        Properties.EventType == "DeviceCertificatesGenerate" and 
        ResultType == "Success"
| summarize Device_Heartbeat_Events=count() by bin(TimeGenerated, Interval)
| render timechart

未更新至最新 OS 的 Azure Sphere 裝置

過去一周尚未更新為最新操作系統版本的 Azure Sphere 裝置清單。

ASCDeviceEvents
| where OperationName == "DeviceUpdateEvent" and  
        todouble(Properties.InstalledOSVersion) != todouble(Properties.TargetedOSVersion) // Filter by time by adding " | where TimeGenerated > ago(7d) " for last 7 days of data or using time picker in the UI
| summarize by DeviceId
| limit 100

Azure Sphere 裝置遙測事件摘要

匯總過去一周 Azure Sphere 裝置所產生的每個事件類別目錄共用的餅圖，以監視整體裝置健康情況。

ASCDeviceEvents
| where OperationName == "DeviceTelemetryEvent" // Filter by time by adding " | where TimeGenerated > ago(7d) " for last 7 days of data or using time picker in the UI
| summarize count() by tostring(Properties.DeviceTelemetryEventCategory)
| render piechart

共用方式為