I was able to make the report you want easily in Report Writer. The field you are looking for is Machine Type. I copied the Report writer code and passed it in a web based Report using a Custom Table. I pressed Preview Results, and saw the correct info. So, feel free to copy this for your report.
SELECT TOP 10
Nodes.Caption AS NodeName, Nodes.Vendor AS Vendor, Nodes.MachineType AS Machine_Type
WHERE ( (Nodes.Vendor = 'Cisco') )
ORDER BY 2 ASC, 3 ASC
Do you have NCM?
Yes, We do have NPM. The report above is just part of the nodes table, so NCM shouldn't be necessary. But I can't say for sure since I am not coming from a non-NCM perspective. What was the result you got when you tried the SQL script above?
If you want to see what is in the actual table, and then choose columns from the table, enter this SQL script, and then preview the data, scroll left-right, the table is long.
It looks like, perhaps, the correct MIBs are not loaded to discover the model number. If you go into the SolarWinds customer portal, you can find the updated MIB database. Download that, load it to the server, then rediscover the device and see if that info is populated. If so, go to the Jobs and run the Hardware Inventory job or the Cisco inventory job, or whatever you want.
Hope that works for you,