Differences

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

--- software:squirrel:reports [2025/02/26 17:03] – created support@smikar.com
+++ software:squirrel:reports [2025/03/26 13:44] (current) – 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_new_menu.png?400}} |
+| 🔍 Use the search bar to quickly find specific reports. | {{:software:squirrel:squirrel_reports.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 Activity**, **Storage**, and **Site-Specific**.
-  * **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 Activity 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 the number of files archived or restored during specific time frames:
-  * **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** – Total files archived in the past 24 hours
+- **Files Archived This Month** – Total files archived in the past 30 days
+- **Files Archived This Year** – Total files archived since the beginning of the year
+- **Files Restored Today** – Total files restored in the past 24 hours
+- **Files Restored This Month** – Total files restored in the past 30 days
+- **Files Restored This Year** – Total files restored since the beginning of the year
-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 storage usage (in GB) related to archiving and restoring:
-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)**
+- **Data Archived This Month (GB)**
+- **Data Archived This Year (GB)**
+- **Data Restored Today (GB)**
+- **Data Restored This Month (GB)**
+- **Data Restored This Year (GB)**
+---
+**🏷️ Site-Specific Reports**
+Track storage usage by individual SharePoint site:
+- **Data Archived by Site** – Shows storage archived per site across 1, 3, 6, and 12-month intervals
+- **Data Restored by Site** – Shows storage restored per site across the same time ranges
+----
+==== 📤 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).