Azure Data Factory - Self Hosted IR Status - Log Analytics query

Raghunandan Vaidya 1

Hi,
From adf.azure.com we can check the Self Hosted IR status (online, offline, etc), but if I want to query using KQL from Log analytics, how can I do it. Which category and metrics contain this detail.
Thank you!!

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2020-10-08T01:57:14.593+00:00
Hi @Raghunandan Vaidya ,

Welcome to Microsoft Q&A platform and thanks for your query. As per the ADF monitoring documentation, it is possible to get details of below tables but not sure about SHIR details.

ADFActivityRun

ADFPipelineRun

ADFTriggerRun

ADFSSISIntegrationRuntimeLogs

ADFSSISPackageEventMessageContext

ADFSSISPackageEventMessages

ADFSSISPackageExecutableStatistics

ADFSSISPackageExecutionComponentPhases

ADFSSISPackageExecutionDataStatistics

But you can monitor an integration runtime in ADF using powershell: Monitor an integration runtime in Azure Data Factory

I have reached out to internal team to confirm if it is possible to use KQL to get the status of SHIR from Log Analytics. I will keep you posted as soon as I have an update from the team.

Thank you for your patience
Raghunandan Vaidya 1 Reputation point

2020-10-08T08:02:59.977+00:00

Thank you for the reply. Yes, I see that there is a way to get the IR Status detail from PowerShell and REST API but I need it to be presented on Azure Dashboard, hence wanted to check if we can use KQL and pin the output to the Azure Dashboard.
It would be great if you can check if it is possible via kql.
Thanks!!

1 answer

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2020-10-09T23:51:40.31+00:00

Hi @Raghunandan Vaidya ,
Thanks for your response. After further investigation, noticed that we have IntegrationRuntimeAvailableNodeNumber which indicate the online node count per SHIR, could you please try leveraging this option?

https://learn.microsoft.com/azure/azure-monitor/platform/metrics-supported#microsoftdatafactoryfactories

If this doesn't help to achieve your requirement, I would recommend you to please do share your feedback/suggestion in ADF user voice forum: https://feedback.azure.com/forums/270578-azure-data-factory All the feedback shared in this forum are actively monitored and reviewed by ADF engineering team. Please do share the feedback link once it is posted so that others with similar idea can up-vote and comment on your suggestion which would increase the priority of feature implementation.

Hope this info helps.

Thank you
Please sign in to rate this answer.
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2020-10-12T22:35:08.68+00:00

Hi @Raghunandan Vaidya ,

Just checking to see if the info was helpful? If you have further query, please do let us know.
Also please do share the feature request link, once you have the posted the feedback in ADF user voice forum.

Thank you

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2020-10-13T19:28:24.803+00:00

Hi @Raghunandan Vaidya ,

We still have not heard back from you. Just wanted to check if the above info was helpful? Otherwise, let us know and we will continue to engage with you on the issue.

Thank you

Raghunandan Vaidya 1 Reputation point

2020-12-10T10:03:35.377+00:00

Hi,
sorry for the late reply. No your suggestion does not help, I have upvoted for feedback.

Niran Badichi 0 Reputation points

2023-06-19T15:18:17.3166667+00:00

Hi, how can i query this table ?

i can't see it on my list
Sign in to comment

Share via

Azure Data Factory - Self Hosted IR Status - Log Analytics query

1 answer