‎03-20-2019 06:29 PM
‎03-20-2019 08:00 PM
‎03-20-2019 07:27 PM
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
(Select COUNT(*)
From tblUSBDevices
Where
tblUSBDevices.AssetID = tblAssets.AssetID
And tblUSBDevices.Name Like '%keyboard%'
And tblUSBDevices.Name Not Like '%Bluetooth%') As USBkeyboards
From
tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where
tblAssetCustom.State = 1
AND (Select COUNT(*)
From tblUSBDevices
Where
tblUSBDevices.AssetID = tblAssets.AssetID
And tblUSBDevices.Name Like '%keyboard%'
And tblUSBDevices.Name Not Like '%Bluetooth%') > 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now