Counting Number of Files Uploaded in SFTP Server

TLDR - Quick Summary

What: Count files uploaded to SFTP server using CloudWatch Logs

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

Last 7 days: Replace ago(1d) with ago(7d)

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(*)