Report Count Local Printers select Distinct PD.Name0, count(*) from dbo.v_GS_PRINTER_DEVICE PD Group by PD.Name0 Order by PD.Name0