VIIndexing 數據表的查詢
如需在 Azure 入口網站 中使用這些查詢的相關信息,請參閱Log Analytics教學課程。 如需 REST API,請參閱 查詢。
索引作業失敗
顯示所有失敗索引作業的影片索引器帳戶記錄。
// Failed Indexing operations
// Display Video Indexer Account logs of all failed indexing operations.
VIIndexing
// | where AccountId == "<AccountId>" // to filter on a specific accountId, uncomment this line
| where Status == "Failure"
| summarize count() by bin(TimeGenerated, 1d)
| render columnchart
前10位使用者
摘要說明前10位使用者。
// Video Indexer top 10 users by operations
// Render timechart of top 10 users by operations, with an optional account id for filtering.
// Trend of top 10 active Upn's
VIIndexing
// | where AccountId == "<AccountId>" // to filter on a specific accountId, uncomment this line
| where OperationName in ("IndexingStarted", "ReindexingStarted")
| summarize count() by Upn
| top 10 by count_ desc
| project Upn
| join (VIIndexing
| where TimeGenerated > ago(30d)
| where OperationName in ("IndexingStarted", "ReindexingStarted")
| summarize count() by Upn, bin(TimeGenerated,1d)) on Upn
| project TimeGenerated, Upn, count_
| render timechart