My test database has External Modem, Internal Modem, and Null Modem

 

SELECT  MOD.DeviceType0,
Count(MOD.DeviceType0) AS ‘Count of DeviceType0’
FROM  v_GS_MODEM_DEVICE MOD
GROUP BY MOD.DeviceType0