Azure Analysis Service Cube Cos Process从日志分析

发布于 2025-02-13 01:54:11 字数 743 浏览 1 评论 0原文

我正在尝试从日志分析中获取所有Azure Analysis Services Cube Process状态，使用以下KQL在日志分析上，但始终获得零记录。

您能帮助哪个日志分析表和列列出立方体流程的状态。

let sessionIdInProgress = aas_engine
| where ['time'] > ago(1d)
//and operationName == 'ProgressReportBegin'
and  operationName == 'ProgressReportEnd'
| summarize by SessionID
| project SessionID;

aas_engine
| where ['time'] >ago(1d)
and SessionID !in ( sessionIdInProgress )
and operationName == 'ProgressReportCurrent'
| extend endTime = now()
| extend durationInHours = datetime_diff('hour', endTime, StartTime)
| extend durationInMinutes = datetime_diff('minute', endTime, StartTime)
| project SessionID, StartTime, durationInMinutes, durationInHours, operationName, resourceId

谢谢，梵

原文

I am trying to get all azure analysis services cube process status from Log analytics, using below KQL on Log analytics but getting zero records always.

Can you please help which Log analytics table and columns gives status of cube process.?

let sessionIdInProgress = aas_engine
| where ['time'] > ago(1d)
//and operationName == 'ProgressReportBegin'
and  operationName == 'ProgressReportEnd'
| summarize by SessionID
| project SessionID;

aas_engine
| where ['time'] >ago(1d)
and SessionID !in ( sessionIdInProgress )
and operationName == 'ProgressReportCurrent'
| extend endTime = now()
| extend durationInHours = datetime_diff('hour', endTime, StartTime)
| extend durationInMinutes = datetime_diff('minute', endTime, StartTime)
| project SessionID, StartTime, durationInMinutes, durationInHours, operationName, resourceId

Thanks,
Brahma

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

妳是的陽光 2025-02-20 01:54:11

我已经联系了Microsoft支持团队，他们帮助我从日志分析中获得了Azure Analysis服务Cube流程状态。

以下是样本KQL：

let CompletedConnectionID = aas_engine
| where ['time'] > ago(10h)
and EventClass == 'COMMAND_END' 
and TextData contains "RefreshType"
| summarize by ConnectionID
| project ConnectionID;

let CubeProcessActiveAAS = aas_engine
| where ['time'] > ago(10h)
and EventClass == 'COMMAND_BEGIN' 
and TextData contains "RefreshType"
and ConnectionID !in ( CompletedConnectionID )
| extend EndTime1 = case(isnull(EndTime), now(), EndTime )
| extend Status = case(isnull(EndTime), 'Inprogress', 'Completed' )
| extend durationInMinutes = datetime_diff('minute', EndTime1, StartTime)
| summarize by ServerName, StartTime,durationInMinutes,Status,ConnectionID

I have reached Microsoft support team and they helped me to get Azure Analysis Service Cube process status from Log analytics.

Below is sample KQL:

let CompletedConnectionID = aas_engine
| where ['time'] > ago(10h)
and EventClass == 'COMMAND_END' 
and TextData contains "RefreshType"
| summarize by ConnectionID
| project ConnectionID;

let CubeProcessActiveAAS = aas_engine
| where ['time'] > ago(10h)
and EventClass == 'COMMAND_BEGIN' 
and TextData contains "RefreshType"
and ConnectionID !in ( CompletedConnectionID )
| extend EndTime1 = case(isnull(EndTime), now(), EndTime )
| extend Status = case(isnull(EndTime), 'Inprogress', 'Completed' )
| extend durationInMinutes = datetime_diff('minute', EndTime1, StartTime)
| summarize by ServerName, StartTime,durationInMinutes,Status,ConnectionID

回复收藏 0 原文

~没有更多了~