# Plant IT and OT Asset Inventory Worksheet

> Source: https://netray.co/tools/plant-it-asset-inventory-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable asset register for servers, network gear, PLCs, HMIs and workstations, with Purdue zone, support dates and replacement budget.

## Category

erp-operations

## Industry

Discrete Manufacturing

## Audience

- IT manager
- OT engineer
- Asset manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Asset ID

**Key:** asset_id

**Type:** text

#### Description

**Key:** name

**Type:** text

#### Type

**Key:** type

**Type:** select

**Options:**

- Server
- Switch
- Firewall
- PLC
- HMI
- Workstation
- Thin client
- Label printer
- Handheld scanner
- Other

#### Purdue zone

**Key:** zone

**Type:** select

**Options:**

- L0-1 Field and control
- L2 Supervisory
- L3 Site operations
- L3.5 DMZ
- L4-5 Enterprise

#### Owner

**Key:** owner

**Type:** text

#### OS or firmware

**Key:** software

**Type:** text

#### Vendor support ends

**Key:** support_end

**Type:** date

#### Age

**Key:** age

**Type:** number

**Unit:** years

#### Planned life

**Key:** life

**Type:** number

**Unit:** years

#### Life remaining

**Key:** remaining

**Type:** number

**Expr:** life - age

**Format:** decimal

**Unit:** years

#### Qty

**Key:** qty

**Type:** number

#### Replacement cost each

**Key:** cost

**Type:** number

**Format:** currency

#### Replacement budget

**Key:** ext

**Type:** number

**Expr:** qty * cost

**Format:** currency

**Rows:**

#### ERP database server

**Asset id:** SRV-001

**Type:** Server

**Zone:** L4-5 Enterprise

**Owner:** IT

**Software:** Windows Server 2019

**Support end:** 2029-01-09

**Age:** 4

**Life:** 5

**Qty:** 1

**Cost:** 18000

#### MES application server

**Asset id:** SRV-014

**Type:** Server

**Zone:** L3 Site operations

**Owner:** Operations IT

**Software:** Windows Server 2016

**Support end:** 2027-01-12

**Age:** 7

**Life:** 6

**Qty:** 1

**Cost:** 12000

#### Cell 4 managed switch

**Asset id:** SW-022

**Type:** Switch

**Zone:** L2 Supervisory

**Owner:** Controls

**Software:** Vendor firmware 15.2

**Support end:** 2026-12-31

**Age:** 8

**Life:** 10

**Qty:** 2

**Cost:** 2200

#### Plant to enterprise firewall pair

**Asset id:** FW-003

**Type:** Firewall

**Zone:** L3.5 DMZ

**Owner:** Network

**Software:** Vendor OS 7.2

**Support end:** 2028-06-30

**Age:** 3

**Life:** 7

**Qty:** 2

**Cost:** 9500

#### Line 2 PLC

**Asset id:** PLC-110

**Type:** PLC

**Zone:** L0-1 Field and control

**Owner:** Controls

**Software:** Firmware 20.011

**Support end:** 2030-01-01

**Age:** 9

**Life:** 15

**Qty:** 1

**Cost:** 7500

#### Line 2 operator HMI

**Asset id:** HMI-045

**Type:** HMI

**Zone:** L2 Supervisory

**Owner:** Controls

**Software:** Windows 10 IoT

**Support end:** 2026-10-14

**Age:** 6

**Life:** 8

**Qty:** 3

**Cost:** 3200

**Totals:**

#### Total units

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total replacement budget

**Key:** ext

**Agg:** sum

**Format:** currency

#### Lowest life remaining

**Key:** remaining

**Agg:** min

**Format:** decimal

**Summary:**

#### Average budget per asset line

**Key:** avg_ext

**Expr:** sum_ext / count

**Format:** currency

#### Asset lines

**Key:** lines

**Expr:** count

**Format:** integer

**Notes:** Add one row per asset or per identical group. Sort by vendor support end date to find end-of-life items, and by zone to see which Purdue levels hold the oldest equipment. Negative life remaining means the asset is past its planned life.

## Content

**Intro:** You cannot patch, segment, insure or replace what you do not know you have. This worksheet is a practical asset register for a manufacturing plant that covers both IT (servers, workstations) and OT (PLCs, HMIs, industrial switches), tagged with Purdue zone and support dates, and exports to Excel.

**Sections:**

#### How to use the worksheet

**Body:** Replace the sample rows with your own. Walk the server room, control cabinets and production cells, and record each asset once with a stable ID. Fill in zone, owner, software or firmware version and the vendor support end date from the vendor's lifecycle page. Planned life and age give a remaining-life figure per row, and quantity times replacement cost gives a budget. Export to Excel and sort or filter by the columns that matter to you.

**Bullets:**

- Start with the most critical lines, then expand
- Use the asset tag on the device as the ID
- Record firmware versions, not just model names

#### What to record and why

**Body:** The minimum useful set is identity, location or zone, owner, software version, support end and cost. Zone shows whether a device sits in the plant or the enterprise network, which feeds segmentation work. Owner makes sure someone answers for patching. Support end dates reveal operating systems that will soon lose security updates, which is a recurring issue with HMIs on old Windows versions. The replacement cost line helps turn a technical problem into a budget request.

#### Reading the results

**Body:** Sort by life remaining to see what needs budget in the next one to three years. Sort by support end to see what will stop receiving vendor fixes. Group by zone to find old equipment in sensitive layers, for example an unsupported HMI at Level 2. The total replacement budget is a rough planning figure, not a quote. Treat a PLC at ten years old differently from a laptop at ten years old, because the replacement effort and risk differ by far more than the price.

#### Common mistakes

**Body:** A one-off spreadsheet that nobody updates is the main failure, so name an owner and a review date, ideally tied to change management. Another is inventorying only IT devices and leaving out OT assets that vendors maintain. Teams also forget virtual machines and cloud services, which belong in a separate sheet or additional rows. If you can, compare the register against a network scan or switch MAC tables to find devices nobody listed.

**Cta:** If you want your asset register to feed ERP maintenance and spares planning, Netray can help connect it to your ERP asset module. Ask for a short scoping call.

**Faq:**

#### How is an OT asset inventory different from an IT one?

**Answer:** OT assets such as PLCs and HMIs often lack agents, scan poorly and are maintained by vendors or controls engineers, so inventory needs walkdowns and passive discovery. They also have longer lifecycles and firmware rather than regular patches.

#### How often should the inventory be updated?

**Answer:** Review at least yearly, and update whenever equipment is installed, moved or retired. Linking it to change management is the most reliable way to keep it current.

#### Should software licenses be included?

**Answer:** Track them in a separate sheet or add columns if you prefer one register. The key link is software or firmware version per device, since that decides patching and support status.

#### Can this replace a CMDB or asset management tool?

**Answer:** For a single plant or a start, yes. Larger companies with many sites outgrow a spreadsheet and need a CMDB or OT asset discovery tool. The worksheet is also a good requirements list when evaluating those tools.

## Search terms

it asset inventory template excel, ot asset inventory template, manufacturing it asset register, plant asset inventory worksheet, hardware inventory spreadsheet, it asset inventory manufacturing, industrial asset inventory template, network asset list template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json