Asset management is the process of tracking and managing the lifecycle of IT assets: from purchase, through use, to disposal. In a factory with hundreds of employees and devices, asset management is not a luxury, it is the baseline for compliance, audit and capex optimization. The question is: is Excel enough? Usually it stops being enough once the asset count grows into several hundred. In this article I show what asset management looks like in a factory in practice, how QR codes improve inventory accuracy and why it is worth considering a dedicated tool (ManageEngine Asset Manager).
What asset management is and why it matters
Asset management is the end-to-end process of tracking IT hardware from purchase to disposal. It covers: inventory, location tracking, warranty tracking, depreciation calculation, SLA binding, end-of-life planning.
Why it matters in a factory: compliance (the auditor says: show me where every laptop is), finance (depreciation in the accounts), operations (who has which device), HR (a new employee assigned to an asset within 1 hour).
IT asset lifecycle stages
1. Purchase
- PO created in SAP/ERP
- Asset tracked from receipt (invoice, warranty start)
- Auto-create in ManageEngine CMDB
2. Deployment
- Assignment to an employee (mobile QR scan)
- Configuration (hostname, IP, software licenses)
- SLA binding (laptop serviced within 24h)
3. Maintenance
- Warranty tracking (alert 30 days before expiry)
- Service, upgrades, fixes linked to CMDB
- End-of-Life planning (Windows 10 support ends...)
4. Retirement
- Remove from CMDB, mark as retired
- Recycling, sale, destruction
- Audit trail: where the device went
Why Excel is not enough
| Aspect | Excel | Asset Manager (ManageEngine) |
|---|---|---|
| Asset limit | ~200 (then too slow) | 10,000+ |
| Change history | No (overwrites old data) | Yes (full audit trail) |
| Real-time updates | Manual, 1-day delay | Instant sync with CMDB |
| QR scan integration | No | Mobile app + scanner |
| Automated depreciation | Manual formula | Automatic, configurable |
QR codes - higher accuracy, shorter inventory
Inventory without QR: technicians walk around with an Excel list, entering data manually. The process is time consuming and error prone. Missing devices and duplicates are typical problems with a manual count.
Inventory with QR: a mobile scanner or the ManageEngine app, scan the QR code on each device, automatic update of location and status. Effect: a faster count and far smaller risk of mistakes than with manual entry.
Setup: print QR codes (asset number and ID from CMDB), a sticker on every device, short technician training, mobile scanner (if you do not have one, a smartphone with the app is enough). The implementation cost is low compared with the time saved on inventory.
Integration with CMDB and SLA
An asset in ManageEngine Asset Manager is auto-linked to the CMDB. When a laptop is sent for service: a help desk ticket plus an auto-link to the asset. Warranty expiry tracking: alert 30 days before end of life, auto-create a ticket to plan an upgrade.
SLA binding: laptop worth more than 5,000 PLN = 24h support SLA. Laptop under 2,000 PLN = 48h SLA. Auto-assign based on asset value or age.
Sample deployment scenario
The scenario below is illustrative. It shows a typical course of events, not the results of a specific customer.
Starting point: an old Excel file as the only record, part of the assets out of date or not listed at all, warranties not tracked, depreciation calculated manually, which regularly consumes team time.
Solution: ManageEngine Asset Manager. Typical course: (1) import data from Excel, (2) print and apply QR codes, (3) full inventory scan and training, (4) integration with CMDB.
Effect: full inventory visibility, automatic alerts on expiring warranties, depreciation calculated automatically instead of manually, a regular and fast inventory based on QR scanning.
The financial benefit comes mainly from recovered team time and better control of the IT asset base. The specific return on investment depends on the number of assets, license costs and rates. A credible calculation comes only after analyzing the real data of the company.
FAQ
What is asset management?
The process of tracking and managing the lifecycle of IT assets: from purchase, through use, to disposal. It includes inventory, warranty, depreciation, SLA binding, end-of-life planning.
Why is Excel not enough?
With more than 200 assets: no change history, duplicates, no real-time updates, no QR/mobile integration. ManageEngine: everything automated.
What is the asset lifecycle?
4-5 years: laptops (3-5), servers (5-7), switches (5-10). Depreciation: straight line. After 5 years: upgrade or recycling.
How do QR codes improve inventory?
QR codes with a scanner: scan and the system knows the location, owner and status of the asset. Inventory is therefore faster and less error prone than a manual count.
Does asset management integrate with CMDB and SLA?
Yes: asset is linked to CMDB, warranty expiry triggers an alert ticket, asset value drives SLA tier determination.
Related articles
CMDB for a manufacturing plant - how to manage IT and OT assets ManageEngine + Comarch ERP integration in Poland ITSM for manufacturing - the full guide200+ devices? Move from Excel to a real system.
Rotech Group will audit your current inventory and propose a migration plan to ManageEngine Asset Manager.
Book a consultation