so the strategy would seem to me to be having to identify them by device type, as well as either part# or description etc. from the article it might be tough. did you have a thought on how to do it?
Since I don't have those (that I could tell) I am not sure how they show up in your inventory.
Here is a guess at the report quick and dirty for ya.
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