To catch all "Device Profiles" you have to use `device` table with `d.tkclass = 254`
SELECT d.pkid, d.name, d.description FROM device AS d WHERE d.tkclass = '254' AND d.name NOT LIKE 'ModelProfile%' ORDER BY d.name
This is an explanation of device types:
SELECT * FROM typeclass
Ohhh, Sorry, I didn't quite understand you. I think you can get the models you need from the `typemodel` table
SELECT tm.enum, tm.name FROM typemodel AS tm WHERE tm.name LIKE 'Cisco%' ORDER BY tm.name