I would like to convert a PowerShell script in to a C# application. The PowerShell script currently queries data from AD and MS Lync and runs a SQL query against the a monitoring database.
I would like to move this functionality in to a C# application the maintains the same functionality with these added features:
- Beautiful HTML5 Web interface - simple, intuitive and easy to use
- The current CSV output should be displayed in the web page, but also have the option to export to CSV
- The data should be able to be filtered and sorted on any of the data
- Have a settings page for configuration and import of rate cards etc
- Ability to select AD attributes for a user to add to the report output e.g currently the script is hard coded to pull "Company" and "Department" from the users AD attributes
- Improve the SQL queries performance. Its currently very slow and poorly written (by myself with little SQL skills)
- Have an installer with deployment wizard
- Option to use embedded web server or deploy to IIS
- Option to use local SQL (SQL Express or similar that meets performance needs) or deploy to existing SQL backend
- Data query can be run on a schedule
- Historic data is kept and can be reported on
- Handle very large amounts of records (this is phone call records so can be millions)
More info and pics attached, scripts attached. You can also learn more about the Open Source project here - [login to view URL]
Any questions let me know