ASCDeviceEvents 數據表的查詢
如需在 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