|
| Client provides monitoring and maintenance of computers and network devices to a number of customers. They monitor numerous organizations' network devices such as servers, routers, firewalls, and workstation pc's. Their customers pay them a monthly fee for this service and one of the promised deliverables to our customer for this fee is a monthly report that summarizes their network "health". They call this report the Executive Report or Network Health Report. In this report, they analyze a number of network metrics such as: |
- Status of Windows updates or patches for servers & workstations
- Free disk space on hard drives
- Anti-Virus protection - are virus signatures up to date or out of date
- Internet uptime
- Server uptime
- Backup success or failure
- Open and recently closed service tickets Nucentric has worked on while supporting their network.
|
|
| The objective of this project is to monitor network devices and collect data about the status of network device. The Executive Report is built using Visual Studio and SQL Reporting Services. |
|
| The report is designed to be a 1-page summary for non-technical customers such as a small business owner to show them that our Client is doing a good job supporting and maintaining their network. |
|
- Customer Info
- System Status
- Security Status
- System Availability
- Service Requests
- Disk Utilization
- Patch Management
|
|
The Executive Report uses 2 primary systems from which it gets its data:
- Kaseya – This is a system that our client uses to monitor network devices and collect data about the status of network device. We also use Kaseya for patching servers and workstations, remote control support, etc.
- Connectwise – This is a system that our Client uses for service ticket management, employee’s time tracking and customer billing. The “Service Requests” section at the bottom of the report gets data from ConnectWise to display recently opened and closed service tickets.
|
|
| In the Anti-Virus section of the Executive Report, the user may run a sub-report displaying the detail of the Anti-Virus status for that customer. |
|
| In order to gather the data necessary report on status of anti-virus, we had to create a script that runs on all of our “managed” pc’s and servers that checks for the virus signature version and date. The script is deployed to all “managed” pc’s and server via Kaseya. We install the Kaseya software agent on each of these “managed” pc’s and this allows us to deploy scripts such as this Anti-Virus script to each of the managed pc’s. The purpose of the AV Master script is so that one script can be executed on all client machines and collect data on every AV product that is installed. |
|
| Tools & Technologies:ASP.NET, SQL Reporting Services, Framework2.0, XML, Web Services and SQL server 2005 |
| Development Model:3-Tier distributed deployment model |