Abstract
This project proposes Patch Management Tracker, a software initiative aimed at Information Technology learners. It combines PowerShell, SQL to deliver a functional prototype while reinforcing fundamentals. Budget and duration are estimates; actual costs vary by location and component choices.
Problem statement
Students in Information Technology often lack hands-on project ideas that connect theory with practice. Patch Management Tracker addresses a real-world need by applying PowerShell, SQL to solve a domain-specific problem.
Objectives
- Understand the core concepts behind Patch Management Tracker.
- Design and implement a working prototype using PowerShell, SQL.
- Evaluate performance and usability of the solution.
- Document findings and suggest improvements.
Key features
- Core functionality for Patch Management Tracker
- User-friendly interface or control mechanism
- Data logging or reporting where applicable
- Modular and extensible design
Implementation roadmap
- Research and requirement analysis
- System design and architecture
- Implementation of core modules
- Integration and testing
- Documentation and final report
Required hardware & software
- Laptop/PC
- Development IDE
- Required libraries and frameworks
Testing approach
Unit testing of individual modules, integration testing, and a basic usability/performance check. No fabricated experimental results are claimed.
Expected outcome
A functional software prototype demonstrating the feasibility of Patch Management Tracker, along with documentation.
Limitations
Prototype scope is limited; real-world deployment may require additional safety, scaling, and compliance considerations.
Future scope
Extend with advanced features, better UX, and integration with related systems.
Learning prerequisites
- Basic knowledge of PowerShell
- Basic knowledge of SQL