Knowledge Base

Find answers to common questions about Cloudmersive products and services.



Cloudmersive Storage Protection Azure Log Analytics Integration Query Best Practices
1/4/2023 - Cloudmersive Support


Cloudmersive Storage Protection analytics when sent to Azure Log Analytics are by default stored in a table named ApplicationLog_CL.

To query all logs, you can run the following query in Azure Log Analytics:

ApplicationLog_CL

To query only logs for transactions where the scan result was Clean, you can run the following query:

ApplicationLog_CL
| where parse_json(tostring(parse_json(Message).ScanResult)).CleanResult == true

To query only logs for transactions where the scan result was Infected, you can run the following query:

ApplicationLog_CL
| where parse_json(tostring(parse_json(Message).ScanResult)).CleanResult == false

To query only logs for transactions where the scan failed due to technical reasons, you can run the following query:

ApplicationLog_CL
| where parse_json(tostring(parse_json(Message).ScanResult)).Successful == false

To query for logs for a specific file name, you can run the following query:

ApplicationLog_CL
| where parse_json(Message).FileName == "hello.docx"

800 free API calls/month, with no expiration

Get started now! or Sign in with Google

Questions? We'll be your guide.

Contact Sales