‎01-13-2018 10:45 AM
‎07-16-2019 06:19 PM
atimkayev wrote:
Dear friends,
Could you help me to create a report for LanSweeper with list of host names which affected by vulnerability MouseJack ?
Thanks in advance for your help!
‎01-15-2018 11:13 PM
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblPointingDevice.caption,
tblPointingDevice.Manufacturer
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
inner join [tblPointingDevice] on tblPointingDevice.assetid = tblassets.AssetID
Where tblPointingDevice.Manufacturer like '%Microsoft%' or tblPointingDevice.Manufacturer like '%dell%'or tblPointingDevice.Manufacturer like '%gigabyte%'
or tblPointingDevice.Manufacturer like '%AmazonBasics%'or tblPointingDevice.Manufacturer like'%hp%'or tblPointingDevice.Manufacturer like '%Lenovo%'or tblPointingDevice.Manufacturer like'%logitech%'
and tblPointingDevice.caption like '%mouse%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now