cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
aaapp_user
Engaged Sweeper
How would i set up an asset group to show the printers that are connected by usb and arent on the network
1 REPLY 1
CyberCitizen
Honored Sweeper
aaapp user wrote:
How would i set up an asset group to show the printers that are connected by usb and arent on the network


Not sure on Asset Group but there is a report for this.

Printer: Local USB Printers

Select Top 1000000 tsysOS.Image As Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.IPAddress As IP,
tblPrinters.Caption As Printer,
tblPrinters.Portname As [Printer Port],
tblPrinters.Capabilitydescriptions As [Printer Capabilities],
tblPrinters.Lastchanged
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where (tblPrinters.Portname Like 'DOT4%' Or tblPrinters.Portname Like 'USB%')
And tblPrinters.Local = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
Printer