SELECT USB.Name0, Count(USB.Name0) AS ‘Count’
FROM v_GS_USB_CONTROLLER USB
GROUP BY USB.Name0