select PRN.SystemName0, PRN.DeviceID0, PRN.Sharename0
from dbo.v_GS_PRINTER_DEVICE PRN
Where PRN.Sharename0 <> ”