Forum Discussion

thophan's avatar
thophan
Icon for Microsoft rankMicrosoft
Jul 16, 2020

Cannot export queries

I'm trying to export the queries that I've saved in my AI Logs. Is there an easy way to export the list of queries themselves, not the results?

 

Thanks!

Azure Log Analytics
azure monitor

1 Reply

  • YossiY's avatar
    YossiY
    Icon for Microsoft rankMicrosoft
    Jul 29, 2020

    thophan hi,

    You can't export the queries from the portal, but you can do it fairly easily this way:

    1. Go to Saved Searches - List By Workspace REST, click 'Try it' button and fill the information for your workspace, then click 'Run'

    2. You already have all the queries in JSON format, but if you want it in table format for management, copy the list of saved queries and save it as JSON file (can save to text and change file type to .json)

    3. Open Excel and click 'Data' > 'Get Data' > 'From File' > 'From JSON and select your JSON file.

    4. it will load in PowerQuery where you can parse it and see your queries in a table.

     

    Yossi