Forum Discussion

RCDevops777's avatar
RCDevops777
Copper Contributor
Jan 25, 2019
Solved

OMS Log Analytics query Function/alias creation via ARM template

Hi All,    I have created ARM templates for creating OMS Log Analytics Searches. I am trying to see if you can help me creating a function in via ARM template. Bascially  we want to create/update t...
azure monitor
Query Language
  • Stanislav_Zhelyazkov's avatar
    Stanislav_Zhelyazkov
    Jan 30, 2019

    Hi,

    For creating function you actually use the saved searches API.

    https://docs.microsoft.com/en-us/rest/api/loganalytics/savedsearches/createorupdate

    There is a slight change in the properties of the call.

    "properties": {
    "category": " Saved Search Test Category",
    "displayName": "Create or Update Saved Search Test",
    "query": "* | measure Count() by Computer",
"FunctionAlias" : "AllComputers",
    "version": 2
  }

    With that you create function.

    And it is just Log Analytics now. We do not use OMS anymore.

Vino55's avatar
Vino55
Icon for Microsoft rankMicrosoft
Feb 20, 2019

Hi Stanislav_Zhelyazkov,

 

Is it not possible to include saved query/functions as part of ARM template?

Basically my objective is to fetch data (In log analytics) from PowerBI using Rest API. 
Since we do not want to have complex queries as part of Rest API (for 2 reasons - customization at LA and Rest API limitation of 2KB length), we thought of using saved queries/functions and then call these saved queries from powerBI. 

Thanks.

Stanislav_Zhelyazkov's avatar
Stanislav_Zhelyazkov
MVP
Feb 20, 2019

I am not sure if I understand the question correctly but if you are talking about export to PowerBI feature I do not think why it wouldn't possible to use functions there. In basics that integration is basically executing query at specific period against the API and getting the data.

  • Vino55's avatar
    Vino55
    Icon for Microsoft rankMicrosoft
    Feb 20, 2019

    Thanks for the response.

     

     

    My question is 'Is it possible to export the saved queries via ARM template'?

     

    Before our customers use powerBI, they can deploy the ARM template. And after that they can use powerBI to call those functions through RestAPI.

    Thanks.

     

     

    • Stanislav_Zhelyazkov's avatar
      Stanislav_Zhelyazkov
      MVP
      Feb 20, 2019

      I do not know if the portal export feature works for these resources but if you have them deployed via ARM template to one environment you can deploy them to another very easily. The ARM template is your export.

Resources