AZMSOperationalLogs 資料表的查詢

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

發佈主題的成功資料

發佈 OperationLogs 主題的成功資料。

AZMSOperationalLogs
| extend TopicName = tostring(split(_ResourceId, "/")[10])
| where Provider =~ "EventHub"
| where isnotnull(TopicName) and Status == "Succeeded"
| project TopicName, _ResourceId, EventName, Status, Caller, _SubscriptionId
| summarize by TopicName, EventName

發佈訂閱的失敗資訊

發佈訂閱的管理動作失敗資訊。

AZMSOperationalLogs
| extend SubInfo = _SubscriptionId
| where Provider =~ "EventHub"
| where isnotnull(SubInfo) and Status != "Succeeded"
| project SubInfo, _ResourceId, EventName, Status, Caller
| summarize by SubInfo, EventName

發佈命名空間的失敗資訊

發佈命名空間的管理動作失敗資訊。

AZMSOperationalLogs
| extend NamespaceName = tostring(split(_ResourceId, "/")[8])
| where Provider =~ "EventHub"
| where isnotnull(NamespaceName) and Status != "Succeeded"
| project NamespaceName, _ResourceId, EventName, Status, Caller, _SubscriptionId
| summarize by NamespaceName, EventName

發佈主題的成功資料

發佈伺服器匯流排中 CRUD 作業主題的成功資料。

AZMSOperationalLogs
| extend TopicName = tostring(split(_ResourceId, "/")[10])
| where Provider =~ "ServiceBus"
| where isnotnull(TopicName) and Status == "Succeeded"
| project TopicName, _ResourceId, EventName, Status, Caller, _SubscriptionId
| summarize by TopicName, EventName

發佈主題的失敗資訊

發佈主題的管理動作失敗資訊。

AZMSOperationalLogs
| extend TopicName = tostring(split(_ResourceId, "/")[10])
| where Provider =~ "ServiceBus"
| where isnotnull(TopicName) and Status != "Succeeded"
| project TopicName, _ResourceId, EventName, Status, Caller, SubscriptionId
| summarize by TopicName, EventName

發佈訂閱的失敗資訊

發佈訂閱的管理動作失敗資訊。

AZMSOperationalLogs
| extend SubInfo = _SubscriptionId
| where Provider =~ "ServiceBus"
| where isnotnull(SubInfo) and Status != "Succeeded"
| project SubInfo, _ResourceId, EventName, Status, Caller
| summarize by SubInfo, EventName

發佈命名空間的失敗資訊

發佈命名空間的管理動作失敗資訊。

AZMSOperationalLogs
| extend NamespaceName = tostring(split(_ResourceId, "/")[8])
| where Provider =~ "ServiceBus"
| where isnotnull(NamespaceName) and Status != "Succeeded"
| project NamespaceName, _ResourceId, EventName, Status, Caller, _SubscriptionId
| summarize by NamespaceName, EventName