→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
03-01-2017 09:31 PM
03-09-2017 11:11 PM
03-09-2017 09:54 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblUSBDevices.Name,
tblUSBDevices.Manufacturer,
tblUSBDevices.DeviceID,
tblUSBDevices.LastChanged
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblUSBDevices On tblAssets.AssetID = tblUSBDevices.AssetID
Where (tblUSBDevices.Name Like '%scan%') Or
(tblUSBDevices.Manufacturer Like '%fujitsu%')
Order By tblAssets.AssetName
03-08-2017 06:43 PM
03-08-2017 05:35 PM
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
03-08-2017 05:29 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now