IT Operations, Risk and Audit · #96
Online Hardware Lifecycle Refresh Planner
Derives from the inventory which device needs refreshing when, and the yearly refresh budget.
- Data is processed in your browser and not sent to a server
- Export: CSV
Tool
What does this tool do?
Servers out of warranty and switches past their life increase failure risk and time to find parts, while the refresh budget is usually requested at the last minute. The tool applies a default life per type (server 5, laptop 4, switch 7 years …), calculates refresh date and status, checks warranty end and gives a yearly count/budget summary.
How to use it
- CSV header:
name, purchase_daterequired;type, warranty_end, costoptional. - Enter a reference date (empty = today), default life and, if needed, life per type (
type;years). - Press Run; download the list as CSV.
Fields
- Hardware list (CSV)
- Date YYYY-MM-DD or DD.MM.YYYY.
- Reference date
- Empty = today.
- Default life (years)
- For unrecognised types.
- Life per type
- type;years, one per line (e.g. storage;6).
Worked example
| Input | Value |
|---|---|
| Hardware list (CSV) | |
| Reference date | 2026-11-22 |
| Default life (years) | 5 |
Expected result: As of 22 November 2026 SRV-01 (2024) and SW-CORE (2025) are past their refresh date; FW-01 is due in 9 days, SRV-02 and LT-11 within 12 months. SRV-01 and LT-11 are out of warranty. 3 devices in 2026, 2 in 2027.
Plan extended warranty or accelerated refresh for overdue devices. The yearly summary can go straight into the budget request; the cost column is purchase cost, not refresh cost; update it with current prices.
Second scenario
| Input | Value |
|---|---|
| Hardware list (CSV) | |
| Reference date | 2026-11-22 |
| Default life (years) | 5 |
| Life per type | |
Expected result: With storage life set to 6 years NAS-01's refresh moves from April 2026 to April 2027 (within 12 months); PC-22 is due in 2029.
Method and assumptions
Refresh date = purchase date + life (by type, else default). Status: past = overdue; within 365 days = due. Age = (reference − purchase) / 365.25. Warranty before the reference date = expired.
Default lives: server 5, laptop/notebook 4, desktop/pc 5, switch/router 7, firewall 5, storage/nas 5, ups 8, battery 4, ap 5, printer 5, phone 4 years.
Using the result and troubleshooting
Plan overdue and 12-month devices by budget period; compare refresh vs keeping the existing device with the TCO tool.
Limits and common mistakes
- Lives are common rules of thumb; usage intensity, vendor end-of-support (EoS/EoL) dates and end of security updates must be checked separately.
Frequently asked questions
Why is vendor end-of-life separate?
A vendor may end support and security updates before a device reaches its life. For critical network and security devices the EoL date is what really drives refresh.
Related tools and service
- Asset Inventory CSV CleanerMakes inventory tables merged from different sources uniform and duplicate-free.
Related service: Hardware Consulting