Software Development / Network Management

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.

01 / Objective

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.

i

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.

02 / System Architecture

How the System Fits Together

Evidence level:Visible in system screenshotsDocumented in project description
01

Web Interface

Visible in system screenshots

PHP pages provide the dashboard, device management, port management, scanning interface, and network-map view.

02

Application Backend

Documented in project description

PHP handles requests and application logic within an Apache/XAMPP environment.

03

MySQL Database

Visible in system screenshots

Stores device records, port information, and user-account data. The documented schema includes devices, ports, and users.

04

Python Scanning Component

Documented in project description

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.

05

Results & Visualization

Visible in system screenshots

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.

03 / Feature Showcase

Core System Features

Device records — name, type, IP and status.

Device Inventory

Organizes network-device records and their attributes, including device name, type, IP address, and status.

Port records — number, state, speed, VLAN ID and MAC.

Port Management

Maintains port records associated with network devices, including port number, status, speed, VLAN information, and MAC address where available.

Scan interface — discovered IP/MAC pairs on the local network.

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 — inventory counters and status distribution.

Dashboard & Status Visualization

Provides a centralized view of device statistics, active and inactive device status, and port-related information.

Network map — rooms, switches and the supporting diagram.

Network Map

Provides a location-oriented view of network areas and associated switch information, supported by a network diagram.

Schema diagram — devices ↔ ports (via device_id) ↔ users.

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 — active and inactive port records in the documented schema.

Ports Table

Port rows with number, status, device link, description, speed, VLAN ID and MAC address.

Users table — eight team accounts with hashed passwords; personal values redacted.

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.

04 / Contribution & Methodology

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.

01

Data Modeling

Organize device and port information so that port records can be associated with their corresponding devices.

02

Discovery Integration

Connect the web application to a Python-based scanning script and process the available discovery output.

03

Inventory Management

Provide interfaces for viewing and maintaining device and port records.

04

Application Interface

Use PHP templates and web technologies to present network information through a centralized dashboard.

05 / Outcome & Limitations

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.

Future work — not implemented in the documented prototype
  • 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)
06 / Key Takeaways

Lessons Learned

01

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.

02

PHP and MySQL Integration

Building a working PHP/MySQL application inside Apache/XAMPP, from schema design to server-rendered templates.

03

Python-Based Network Discovery

Using Python with Nmap/ARP information to turn raw network probing into readable IP and MAC results.

04

Network Information Visualization

Turning rows of inventory data into dashboard statistics and a location-oriented map view operators can scan at a glance.

Explore More Projects