Forum Discussion

Devin Lambert's avatar
Devin Lambert
Copper Contributor
Jul 11, 2018

Querying ApplicationInsights

How should we be querying ApplicationInsights?

 

I don't get Intellisense this way. 

app("Sitecore Production").traces

 

The Schema isn't consistent this way. 

ApplicationInsights
| traces

 

And this just doesn't work at all unless I am in the Application Insights Analytics portal (https://analytics.applicationinsights.io)

traces 

 

Devin

7 Replies

  • Devin,

     

    If you're querying exclusively Application Insights, please use option 3 (querying from within Application Insights).

     

    If you're querying a combination of Log Analytics and Application Insights, please use option #1 from within either the AI or LA portals. IntelliSense support is something high on our backlog, together with a better unification between the two services. Expect to see features around this in the coming months.

     

    Option 2 should be considered outdated. I'd turn off the Application Insights connector to both avoid the schema confusion, as well as save yourself some costs from dual-ingesting the data. This feature was originally created as a stop-gap before we had cross-AI-and-LA queries available.

    • Anonymous's avatar
      Anonymous

      Hello, 

      How would I write the query if I wanted to use it for azure alerts, to query though dependencies? I'm currently trying option one listed above, but it is returning an error.

      • pavan kumar's avatar
        pavan kumar
        Copper Contributor

        Looks like the data is not been captured in the LA from the VM, please check the following:

         

        1. Check if the data is been captured in LA, try with the basic queries to see the data.

        2.Agent is properly installed ? if not try to reinstall it in the VM.

        3. Check the Internet connectivity in the VM to communicate also port 443 should be opened as by default the internet access is restricted.

         

        Hope this should give help you.

Resources