VIAudit 資料表的查詢

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

視訊索引器依帳戶標識碼稽核

顯示帳戶的稽核事件 （AccountId = <Guid ID>），並依使用者 UPN 選擇性篩選。

VIAudit
| where AccountId == "<AccountId>"  // please fill in the accountId <Guid>
// | where Upn == "<Upn>" // to to filter on a specific user upn, uncomment this line
| limit 100

影片索引器依作業稽核前 10 名使用者

依作業轉譯前10位用戶的時間圖，並具有篩選的選擇性帳戶標識碼。

// Trend of top 10 active Upn's
VIAudit
// | where AccountId == "<AccountId>"  // to filter on a specific accountId, uncomment this line
| where TimeGenerated > ago(30d)
| summarize count() by Upn
| top 10 by count_ desc
| project Upn
| join (VIAudit
| where TimeGenerated > ago(30d)
| summarize count() by Upn, bin(TimeGenerated,1d)) on Upn
| project TimeGenerated, Upn, count_
| render timechart

影片索引器稽核剖析的錯誤訊息

顯示具有選擇性帳戶標識碼的稽核失敗事件以進行篩選。

// Project failures with detailed error message.
VIAudit
// | where AccountId == "<AccountId>"  // to filter on a specific accountId, uncomment this line
| where  Status == "Failure"
| parse Description with "ErrorType: " ErrorType ". Message: " ErrorMessage ". Trace" *
| project TimeGenerated, OperationName, ErrorMessage, ErrorType, CorrelationId, _ResourceId

影片索引器稽核失敗的作業

顯示所有失敗作業嘗試的稽核記錄，並依帳戶標識碼和使用者 UPN 選擇性篩選。

VIAudit
// | where AccountId == "<AccountId>"  // to filter on a specific accountId, uncomment this line
// | where Upn == "<Upn>" // to to filter on a specific user upn, uncomment this line
| where Status == "Failure"
| limit 100