Counting Number of Files Uploaded in SFTP Server
TLDR - Quick Summary
What: Count uploaded files over time periods using Cloud Logging
Location: GCP Console > Operations > Logging > Logs Explorer
Query:
jsonPayload.message:"upload" AND timestamp >= "YYYY-MM-DDT00:00:00Z"Use Case: Activity monitoring, anomaly detection, reporting
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 GCP Cloud Logging.
GCP Cloud Logging
Steps to Count Uploaded Files
- Access Cloud Logging:
- Open
Google Cloud Console>Operations>Logging>Logs Explorer.
- Run a Query to Count Files Uploaded Yesterday:
jsonPayload.message:"upload" AND timestamp >= "2025-02-11T00:00:00Z" AND timestamp < "2025-02-12T00:00:00Z"
- Run a Query to Count Files Uploaded in the Last 7 Days:
jsonPayload.message:"upload" AND timestamp >= "2025-02-05T00:00:00Z"