A register with the details that matter
Each asset carries an asset tag, name, category, serial number, status, purchase date and free-form notes. That is enough to answer both of the questions that actually come up: what do we own, and which specific unit is this.