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

Date YYYY-MM-DD or DD.MM.YYYY.

Empty = today.

For unrecognised types.

type;years, one per line (e.g. storage;6).

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

  1. CSV header: name, purchase_date required; type, warranty_end, cost optional.
  2. Enter a reference date (empty = today), default life and, if needed, life per type (type;years).
  3. 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

InputValue
Hardware list (CSV)
name,type,purchase_date,warranty_end,cost
SRV-01,server,2019-06-01,2024-06-01,8000
SRV-02,server,2022-03-15,2027-03-15,9000
LT-11,laptop,2023-01-10,2026-01-10,1200
SW-CORE,switch,2018-09-01,,6000
FW-01,firewall,2021-12-01,2026-12-01,4000
Reference date2026-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

InputValue
Hardware list (CSV)
name;type;purchase_date
NAS-01;storage;15.04.2021
PC-22;desktop;01.09.2024
Reference date2026-11-22
Default life (years)5
Life per type
storage;6

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

Related service: Hardware Consulting

Systems online tools · See all online tools