Network Management System
Network Device Inventory, Port Management & Network Discovery
A web-based network management prototype designed to organize device inventory, manage network-port information, discover devices on a local network, and present network information through a centralized interface.
From Manual Tracking to Centralized Management
The project aimed to provide a more structured alternative to spreadsheet-based network-device tracking. It combined a web interface for managing device and port records with a scanning component intended to identify devices on the local network.
The system organizes network information and presents device status, IP-address details, port records, and a network-map interface in one place.
The screenshots in this case study verify the device inventory, port records, scanning interface, dashboard statistics, and network-map view. Reconciling scan results automatically against the inventory — with last-seen timestamps and stale-device handling — is documented in the project description as a design goal, not confirmed behavior of the prototype.
How the System Fits Together
Web Interface
PHP pages provide the dashboard, device management, port management, scanning interface, and network-map view.
Application Backend
PHP handles requests and application logic within an Apache/XAMPP environment.
MySQL Database
Stores device records, port information, and user-account data. The documented schema includes devices, ports, and users.
Python Scanning Component
The documented scanning implementation invokes Python from PHP and uses Nmap or ARP information to discover devices, extracting details such as IP and MAC addresses.
Results & Visualization
Scanning results are presented in the interface, while stored inventory data supports device and port management and dashboard statistics.
Results and stored inventory feed back into the web interface — dashboard statistics, device and port records, and the network-map view all render from these components.
Core System Features
Device Inventory
Organizes network-device records and their attributes, including device name, type, IP address, and status.
Port Management
Maintains port records associated with network devices, including port number, status, speed, VLAN information, and MAC address where available.
Network Discovery
The scanning component uses Python with Nmap or ARP information to identify devices and present discovery results, including available IP and MAC address details.
Dashboard & Status Visualization
Provides a centralized view of device statistics, active and inactive device status, and port-related information.
Network Map
Provides a location-oriented view of network areas and associated switch information, supported by a network diagram.
Database Design
Organizes device, port, and user information through a relational MySQL schema — captured from the phpMyAdmin interface of the documented database. A device connects to many ports; users hold accounts alongside the inventory tables.
The Schema in phpMyAdmin — Tables & Accounts
Ports Table
Port rows with number, status, device link, description, speed, VLAN ID and MAC address.
Users Table
Team accounts with hashed passwords — username, email and password values are blurred for privacy.
Working With the Records — Forms & Accounts
Adding a New Device
Create form capturing the new device's name, type, IP address, and starting status.
Editing a Device
Edit form for updating an existing device's name, IP address and status in place.
Adding a Port
Create form for a new port record — port number, state, device, speed, VLAN ID and MAC address.
Editing a Port
Edit form with prefilled port details — description, speed, VLAN ID and MAC address.
Personal Profile
Each operator's account page — name, email, role and join date.
Editing the Profile
Profile form for updating the operator's account details.
Designing the Management Workflow
The system was built as a team graduation project — a shared effort across its components. The areas below describe the documented implementation workflow of that team project rather than individually claimed responsibilities.
Data Modeling
Organize device and port information so that port records can be associated with their corresponding devices.
Discovery Integration
Connect the web application to a Python-based scanning script and process the available discovery output.
Inventory Management
Provide interfaces for viewing and maintaining device and port records.
Application Interface
Use PHP templates and web technologies to present network information through a centralized dashboard.
A Foundation for Network Visibility
The project demonstrates how a web application, a relational database, and network-discovery tooling can be combined to organize network information and provide a centralized management interface.
The system provides a foundation for extending device inventory and network visualization capabilities.
- Fully connected topology graph visualization of the network
- Scheduled background discovery runs
- Automatic reconciliation of scanned devices with the inventory (last-seen and stale-device states)
Lessons Learned
Relational Data Modeling
Designing devices and ports as related tables — and why a port record is what ties an upstream device to the switch it plugs into.
PHP and MySQL Integration
Building a working PHP/MySQL application inside Apache/XAMPP, from schema design to server-rendered templates.
Python-Based Network Discovery
Using Python with Nmap/ARP information to turn raw network probing into readable IP and MAC results.
Network Information Visualization
Turning rows of inventory data into dashboard statistics and a location-oriented map view operators can scan at a glance.