What makes an asset register useful?

A useful asset register answers questions people actually ask. Can I find the equipment? Can I see what it supports? Can I tell when the record was last checked?

Before adding another column, it helps to ask who will fill it in and when they will use it. A small register that people maintain can be more useful than a detailed one they stop trusting.