It happens from time to time that I have to export more than 10k logs from the
Application Insights, especially when I have to provide the logs to Sitecore Support. As you may know, there is a limit of 10k rows that you can export at once in
Application Insights UI.
Application Insights REST API the limit is much higher and it's 500k of rows. The
API returns logs with
JSON so we have to somehow format it, and in case we need more than 500k of log lines, we have to do another request and then concatenate the results.
I wrote a tool that just does that. It has three versions:
- Standalone Windows application,
- Windows PowerShell script,
- Script for Sitecore PowerShell Extension.
To use the tool you have to generate
REST API Key. Here is a link to documentation where you can read how to do it. To see the source code and installation instructions go to my GitHub repository.
The standalone version of the tool:
The SPE version of the tool: