I would create a new report and add the Custom Table resource, which will allow you to choose the data that goes into the report.
I have a report for Cisco Inventory information that shows Physical Entities and Serial Numbers. I can't recall it if came stock from SolarWinds, or if I modified an existing canned report, or if I downloaded it from Thwack, or if I built it from scratch. I've had NPM since 2004--that's a lot of reports & upgrades & downloads to keep in the old memory banks.
Check & see if your NPM Reports section has something like this when you search your reports for "Inventory".
I also built/modified one for just 2960S switches:
This report comes with NPM/NCM, and should serve as a decent starting place for you:
This depends on which modules you have installed in your environment. If you are talking servers and have SAM, then the asset management information is in a different table than if you are talking network gear and have NPM or NCM. What modules are we working with here?
Sorry for the late response.
Here are our modules: