Desk 47. The helpdesk ticket says "monitor not working." You have no idea what's on desk 47 — which monitor model, whether it's on the known-bad-batch of units with the backlight failure, or whether this is a new problem or a recurring one. You walk over. It's a Dell P2419H. You could have known that before you left your desk if someone had bothered to maintain an asset register. Nobody did. You spend 20 minutes on something that should have been a two-minute swap confirmed against a database query.
The Audit That Makes Everyone Uncomfortable
Eight fields. Desk Number, Assigned To, Item Type, Product Number, Serial Number, MAC Address, Item Description, Date Assigned. This is the minimum viable IT asset register, and it covers the three scenarios that actually matter: physical identification, network identification, and accountability.
The MAC Address field is captured via barcode scanner, same as the Serial Number and Product Number. That's deliberate. Typing a 12-character hex string by hand at 1 AM during a security incident is how errors get introduced. Scanning the sticker on the side of the machine takes three seconds and produces a clean string. When your network monitoring flags an unknown MAC attempting to authenticate against the domain, you query the asset register against that MAC and either find the asset — which tells you exactly what device it is, where it sits, and who it's assigned to — or you don't find it, which is a much more alarming situation that you now know about because the data was there.
The Date Assigned field is the chronology. An asset assigned in March 2021 that has never been reassigned is three years old at assignment age. Combined with the Product Number, you can cross-reference manufacturer end-of-support dates. A batch of HP EliteBook 840 G5 units all assigned in the same quarter tells you when your refresh cycle is going to land, months before procurement starts panicking.
The Desk, Not the Person
Most asset registers are built around the person. This one leads with the Desk Number. That's a different philosophy and it turns out to be correct for office environments with hot-desking, desk swaps, or floor reorganizations.
When Sarah in finance moves to the marketing floor, the asset doesn't follow her automatically in most systems. In this register, you update Assigned To at desk 47 from Sarah to whoever replaces her, and you update desk 47's record to reflect the new occupant. The desk remains the anchor. The equipment at desk 47 hasn't moved. Only the human has.
This also means that a query on Assigned To showing blank or "unassigned" tells you exactly which desks have hardware sitting idle — which is information facilities management and IT procurement both want and never have clean access to.
Barcode Entry at Scale
The template uses barcode type for Product Number, Serial Number, and MAC Address simultaneously. A barcode scanner connected to the device can populate all three fields in sequence, one scan each, in the time it takes a technician to flip the machine over and read the asset sticker. That's deployment speed — useful during a floor buildout where you're registering 60 workstations in a day.
The Item Type field (PC, Docking Station, Monitor, Phone) is minimal but sufficient for the core office hardware stack. A filter on Item Type: Monitor with Date Assigned before a specific date gives you every monitor potentially in an aging cohort. Add a query against known-problematic product numbers and you have a proactive replacement list before the helpdesk tickets start stacking up.