Forum Discussion

Brady Evans's avatar
Brady Evans
Copper Contributor
Jan 12, 2018
Solved

Invoke-LogAnalyticsQuery only returns Tables JSON Array and not Results Array

I'm trying to use the new PowerShell based API (Invoke-LogAnalyticsQuery - see below) and the return payload only includes the Tables array and not the Results array as documented..     import-...
azure monitor
Powershell and Rest API
  • Meir_Mendelovich's avatar
    Meir_Mendelovich
    Jan 14, 2018

    Hi Brady,

     

    First, I must comment on your query. You should avoid queries that has 'search * | where Type =='. Instead the query below should just be: 'Heartbeat | take 10'. Search * is very inefficient way to use the system.

     

    Regarding the results array. I ran the same code but didn't managed to reproduce. I got both tables and results.

     

    Sorry

    Meir

Mark Massad's avatar
Mark Massad
Icon for Microsoft rankMicrosoft
Feb 03, 2018

And please provide a signed version of Invoke-LogAnalyticsQuery.  Changing execution policies is not a good practice.  This command is fragile too - lots of bad gateways.  Makes it challenging to piece together data.  Thank you.

Ace Eldeib's avatar
Ace Eldeib
Brass Contributor
Feb 03, 2018

Thanks for the feedback Mark. We are working to provide a better set of cmdlets integrated with Azure Powershell, which will be available from the PowerShell gallery. They should be available in the next release of AzureRM PowerShell module. These should have better stability and will be signed. 

Resources