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.

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