Having a spreadsheet with list of equipment is not an inventory. Nor can it be used for assurance. Inventory is a must.
Network Device Management (NDM) stores it all: chassis, module, and interface, including data on device name, DNS name, type, description, IPv4/IPv6 addresses, reference designator, vendor, PN, SN, HW version, SW version, firmware version, role, operational status, or any other custom parameter.