User Tools

Site Tools

Trace:
software:squirrel:reports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
software:squirrel:reports [2025/02/26 17:03] – created support@smikar.comsoftware:squirrel:reports [2025/08/28 16:28] (current) – [📂 Available Reports] support@smikar.com
Line 1: Line 1:
-**Reporting in Squirrel**+===== 📊 Reporting in Squirrel =====
  
-Squirrel now includes a Reporting feature that provides detailed insights into archived and restored files. Users can generate reports on demand to track storage usage, file activity, and historical data trends.+The [[https://www.smikar.com/squirrel/|Squirrel]] platform includes a powerful **Reporting** feature that provides real-time visibility into archive and restore activity across your SharePoint environment. These reports help administrators monitor usage, track historical trends, and support compliance and storage planning.
  
-**Accessing Reports**+You can generate reports on-demand and export them as CSV files for further analysis in Excel or other reporting tools.
  
-|Navigate to the Reports section in the Squirrel Admin panel. | | +----
-|Use the search bar to find specific reports.| | +
-|Click the Run Report button next to the desired report.| | +
-|The report will be generated and automatically exported as a CSV file for easy analysis.| |+
  
-**Available Reports**+==== 📁 Accessing Reports ====
  
-Reports are categorized into File Activity Reports and Storage Reports:+| 🧭 Navigate to the **Reports** section in the Squirrel Admin panel. | {{:software:squirrel:squirrel_reports_sidepanel_light.png?200}} | 
 +| 🔍 Use the search bar to quickly find specific reports. | {{:software:squirrel:squirrel_reports_light.png?400}} | 
 +| ▶️ Click **Run Report** next to the desired report to generate it. | | 
 +| 📥 The report will be downloaded automatically as a **CSV file** for analysis. | |
  
-**File Activity Reports**+----
  
-  * **Files Archived Today** – Number of files archived in the last 24 hours. +==== 📂 Available Reports ====
-  * **Files Archived This Month** – Number of files archived in the past 30 days. +
-  * **Files Archived This Year** – Number of files archived in the current year. +
-  * **Files Restored Today** – Number of files restored in the last 24 hours. +
-  * **Files Restored This Month** – Number of files restored in the past 30 days. +
-  * **Files Restored This Year** – Number of files restored in the current year.+
  
-**Storage Reports**+Reports are grouped into three categories: **File Reports**, **Storage Reports**, and **Site Data Reports**.
  
-  * **Data Archived Today (GB)** – Total storage archived in the last 24 hours. +---
-  * **Data Archived This Month (GB)** – Total storage archived in the last 30 days. +
-  * **Data Archived This Year (GB)** – Total storage archived in the current year. +
-  * **Data Restored Today (GB)** – Total storage restored in the last 24 hours. +
-  * **Data Restored This Month (GB)** – Total storage restored in the last 30 days. +
-  * **Data Restored This Year (GB)** – Total storage restored in the current year.+
  
-**Site-Specific Reports**+**📄 File Reports**
  
-  * **Data Archived by Site** – View archived storage per site over different time periods (1 month, 3 months, 6 months, and 12 months). +These reports track file archiving and restoring activity, along with details by type and size:
-  * **Data Restored by Site** – View restored storage per site over different time periods (1 month, 3 months, 6 months, and 12 months). +
  
-**CSV Export Feature**+- **Files Archived Today** – Lists the number of files archived in the last 24 hours   
 +- **Files Archived This Month** – Lists the number of files archived in the last 30 days   
 +- **Files Archived This Year** – Lists the number of files archived in the current year   
 +- **Files Restored Today** – Lists the number of files restored in the last 24 hours   
 +- **Files Restored This Month** – Lists the number of files restored in the last 30 days   
 +- **Files Restored This Year** – Lists the number of files restored in the current year   
 +- **Files Archived by Extension** – Lists the number of files archived by file extension (e.g., .docx, .pdf, .xlsx)   
 +- **Storage by File Type** – Shows total GB of storage used by each file type   
 +- **Large Files Report (Top 100)** – Identifies the 100 largest files over 100MB in size  
  
-Every report automatically exports to a CSV file, allowing users to download and analyze the data in Excel or other tools. +---
-CSV files can be used for trend analysis, audits, and compliance tracking.+
  
-**How to Use Reports**+**💾 Storage Reports**
  
-Reports provide a high-level summary of archival and restoration trends. +These reports track total storage archived or restored, measured in gigabytes (GB): 
-Use these reports to monitor SharePoint storage consumption and plan for future storage needs. + 
-Regularly review reports to ensure compliance with data retention policies.+- **Data Archived Today (GB)** – Total amount of storage archived in the last 24 hours   
 +- **Data Archived This Month (GB)** – Total amount of storage archived in the last 30 days   
 +- **Data Archived This Year (GB)** – Total amount of storage archived in the current year   
 +- **Data Restored Today (GB)** – Total amount of storage restored in the last 24 hours   
 +- **Data Restored This Month (GB)** – Total amount of storage restored in the last 30 days   
 +- **Data Restored This Year (GB)** – Total amount of storage restored in the current year   
 + 
 +--- 
 + 
 +**🌐 Site Data Reports** 
 + 
 +These reports break down archiving and restoring activity per SharePoint site: 
 + 
 +- **Data Archived by Site (Last 30 Days)** – Displays the amount of data archived (GB) per site over the last 30 days   
 +- **Data Archived by Site (Last 90 Days)** – Lists the amount of data archived (GB) per site over the past 90 days   
 +- **Data Archived by Site (Last 180 Days)** – Lists the amount of data archived (GB) per site over the past 180 days   
 +- **Data Archived by Site (Last 365 Days)** – Lists the amount of data archived (GB) per site over the past year   
 +- **Data Restored by Site (Last 30 Days)** – Displays the amount of data restored (GB) per site over the last 30 days   
 +- **Data Restored by Site (Last 90 Days)** – Lists the amount of data restored (GB) per site over the past 90 days   
 +- **Data Restored by Site (Last 180 Days)** – Lists the amount of data restored (GB) per site over the past 180 days   
 +- **Data Restored by Site (Last 365 Days)** – Lists the amount of data restored (GB) per site over the past year   
 + 
 +---- 
 + 
 +==== 📤 CSV Export Feature ==== 
 + 
 +All reports export as **CSV files**, allowing for: 
 + 
 +- External analysis using Excel, Power BI, or similar tools   
 +- Internal reporting to IT leadership or compliance teams   
 +- Long-term storage trend tracking and capacity planning   
 +- Support for audits and governance reviews   
 + 
 +---- 
 + 
 +==== 📈 Best Practices for Using Reports ==== 
 + 
 +- Review reports regularly to ensure you're meeting data retention goals   
 +- Identify spikes or drops in archiving activity to refine your policy thresholds   
 +- Use storage trend data to forecast SharePoint growth and budget Azure costs   
 +- Track site-specific usage to identify departments or teams with heavy data movement   
 + 
 +---- 
 + 
 +Need help interpreting report data or building automated workflows with CSV exports? Contact [support@smikar.com](mailto:support@smikar.com).
  
software/squirrel/reports.1740549808.txt.gz · Last modified: 2025/02/26 17:03 by support@smikar.com