IT Asset Management System with QR Codes

A comprehensive IT asset management system with QR code integration for tracking, checkout/checkin, warranty management, and reporting.

Features

• Asset Registration: Complete asset lifecycle management
• QR Code System: Generate and scan QR codes for quick asset identification
• Check-out/Check-in: Employee asset assignment with email notifications
• Warranty Tracking: Automated alerts for expiring warranties
• Reporting & Analytics: Comprehensive dashboards and reports
• Mobile Scanner: PWA-enabled mobile interface for scanning
• Search & Filters: Advanced search and filtering capabilities

Demo

2025-10-03.20-54-44.mp4

Technology Stack

• Backend: Python Flask
• Frontend: HTML, CSS, JavaScript (Bootstrap)
• Database: SQLite (development) / PostgreSQL (production)
• QR Codes: Python qrcode library
• PDF Generation: ReportLab
• Mobile: Progressive Web App (PWA)

Installation

1. Clone the repository
2. Install dependencies: pip install -r requirements.txt
3. Initialize database: python app.py --init-db
4. Run the application: python app.py
5. Access at: http://localhost:5000

Usage

1. Register Assets: Add new IT assets with auto-generated QR codes
2. Generate QR Labels: Create print-ready PDF labels
3. Check-out Assets: Scan QR codes to assign assets to employees
4. Track Warranties: Monitor warranty expiration dates
5. Generate Reports: Export asset data and analytics

API Endpoints

• GET /api/assets - List all assets
• POST /api/assets - Create new asset
• GET /api/assets/<id> - Get asset details
• PUT /api/assets/<id> - Update asset
• DELETE /api/assets/<id> - Delete asset
• POST /api/checkout - Check out asset
• POST /api/checkin - Check in asset
• GET /api/qr/<asset_tag> - Generate QR code
• GET /api/reports/assets - Asset reports

Database Schema

The system uses three main tables:

• assets: Core asset information
• checkout_history: Asset assignment tracking
• maintenance_log: Maintenance records

Mobile Usage

The system includes PWA capabilities for mobile scanning:

• Add to home screen for app-like experience
• Camera-based QR code scanning
• Offline capability with sync when online

License

MIT License