This project connects with an existing SQL database and FSRM (File Server Resource Manager) server in order to save trend information for FSRM quotas.
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.
- Visual Studio 2017
- .NET Framework 4.5.2
- SQL Server Instance
- Clone the repository
git clone https://github.com/drockwood94/FSRMTrends.git
- Launch the project
FSRMTrends.sln
in Visual Studio 2017 - Build the project with
Ctrl+Shift+B
-
Create a new database with whatever name you intend to use
eg: FSRMTrendData
-
Grant the user you intend to use access to the database
-
Populate the Database
- EITHER Use Visual Studio to publish the included SQL Database Project
- OR Create the following tables:
- Dates
- Date (PK, datetime, notnull)
- QuotaPaths
- QuotaPath (PK, nvarchar(255), not null)
- Sizes
- QuotaPaths (PK, FK, nvarchar(255), not null)
- Date (PK, FK, datetime, not null)
- Size (Numeric(38,0), null)
- Usages
- QuotaPath (PK, FK, nvarchar(255), not null)
- Date (PK, FK, datetime, not null)
- UsageBytes (numeric(38,0, null)
- Dates
-
Determine the proper SQL connection string for your use case (including authentication)
Launch the app without any command line switches to bring up the GUI. App settings are user-level and currently need to be set in Settings->Options...
Ensure that the SQL Server is set up beforehand (refer to the Getting Started)
- Update Quotas
FSRMTrends.exe /updateQuotas
- Important note: Quotas are not updated on any sort of schedule automatically. An easy method to run this flag on a schedule is to use task scheduler.