Have you searched Reports for "Inventory"? There are a number excellent pre-built Reports to choose from, and some may provide exactly the information you seek.
If you don't find what you need pre-built, simply build a new Report that includes the "show inventory" command, or copy/edit an existing report to include that option.
I have a "Physical Entities (Serial Number) v2" Report that I love for catching the serial numbers. If you don't have that, I can send you instructions for building it.
I also have one for Cisco Chassis ID's, and another I use for Cisco Card Data.
Yes, I would like to have those custom reports. I would appreciate if you could send the instruction.