Counting Number of Files Uploaded in SFTP Server

Overview

Tracking the number of files uploaded to an SFTP server can be useful for monitoring activity, detecting anomalies, or generating reports. This guide explains how to count the number of uploaded files over specific time periods using Azure Log Analytics.

Azure Log Analytics Workspace

Steps to Count Uploaded Files

1. Access Log Analytics Workspace:

• Open Azure Monitor > Logs.
• Select the relevant Log Analytics Workspace.

2. Run a Query to Count Files Uploaded Yesterday:

AzureDiagnostics
| where Message contains "upload"
| where TimeGenerated > ago(1d)
    | summarize count()

3. Run a Query to Count Files Uploaded in the Last 7 Days:

AzureDiagnostics
| where Message contains "upload"
| where TimeGenerated > ago(7d)
    | summarize count()