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 AWS CloudWatch.

AWS CloudWatch Logs

Steps to Count Uploaded Files

1. Access CloudWatch Logs:

• Navigate to AWS Management Console.
• Open CloudWatch > Logs > Log Groups.

2. Run a Query to Count Files Uploaded Yesterday:

fields @message
| filter @message like "upload"
| filter @timestamp > ago(1d)
    | stats count(*)

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

fields @message
| filter @message like "upload"
| filter @timestamp > ago(7d)
| stats count(*)