admin 管理员组

文章数量: 1086019

I have to run kusto query for my ADX cluster to get some data from Database from my Runbook. currently rest of the commands/scripts in my runbook are in Powershell, but I am not able to find PowersShell module for Kusto query. So i was trying to use Add-Type to load Kusto types from Kusto.Data.dll. But I am not able to add types. it fails to load System.Runtime.dll and System.Data.Common.dll and some other system dll. Kindly suggest how to fix the error? do i have to copy/upload these system dlls also?

Is there any other way to read data from ADX cluster using Kusto query from Runbook?

I have to run kusto query for my ADX cluster to get some data from Database from my Runbook. currently rest of the commands/scripts in my runbook are in Powershell, but I am not able to find PowersShell module for Kusto query. So i was trying to use Add-Type to load Kusto types from Kusto.Data.dll. But I am not able to add types. it fails to load System.Runtime.dll and System.Data.Common.dll and some other system dll. Kindly suggest how to fix the error? do i have to copy/upload these system dlls also?

Is there any other way to read data from ADX cluster using Kusto query from Runbook?

  • azure-powershell
  • azure-automation
  • azure-runbook
Share Improve this question asked Mar 27 at 12:08 user9297554user9297554 4811 gold badge11 silver badges27 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 0

It is not directly possible to use Add-type or Kusto data dlls in automation accounts. Instead, you can use Az.Kusto module as it allows querying ADX clusters by importing it into the runbook or automation account configuration.

Path: Automation account >> Shared Resources >> Modules >> Az.Kusto

Once you visit the above path, click on Add a module as shown below to add a module from PowerShell Gallery.

Search for the Kusto module called Az.Kusto and select the latest version release, click on select and import. It further imports the module successfully.

Reference SO worked by me for the similar issue.

本文标签： Azure automation runbook powershell to run Azure Data Explorer cluster data queryStack Overflow

版权声明：本文标题：Azure automation runbook powershell to run Azure Data Explorer cluster data query - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://roclinux.cn/p/1744091103a2532049.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。