CODEWITHSUNDEEP
ssas-tabularazure-analysis-services
Brahmaiah Takkellapati
Brahmaiah Takkellapati

Reputation: 141

Azure analysis Service Cube process status from Log Analytics

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

Upvotes: 0

Views: 357

Answers (1)

Brahmaiah Takkellapati
Brahmaiah Takkellapati

Reputation: 141

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

Upvotes: 0

Related Questions