Notification

Icon
Error

All USB devices connected - Need a report to any usb device connected to any system on the network

Posted: Monday, July 6, 2020 5:27:47 PM(UTC)
earmor

earmor

Member Original PosterPosts: 2
0
Like
Hello, I am new to Lansweeper so I apologize in advance if this has already been answered. I need to run a report for ever usb device that is connected to a system on out network. The only exclusion would be mice and keyboards. I could not find how to run the report or create it, could you help me please?
RC62N
#1RC62N Member Posts: 450  
posted: 7/6/2020 6:40:58 PM(UTC)
Add tblUSBDevices to your report, then pick the fields from that table that you want to see. E.g.
Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblUSBDevices.Name,
  tblUSBDevices.Manufacturer
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblUSBDevices On tblAssets.AssetID = tblUSBDevices.AssetID
Where
  tblAssetCustom.State = 1
  AND tblUSBDevices.Name NOT LIKE '%mouse%'
  AND tblUSBDevices.Name NOT LIKE '%keyboard%'
earmor
#2earmor Member Original PosterPosts: 2  
posted: 7/7/2020 1:35:37 PM(UTC)
Thank you, this has helped tremendously

Active Discussions

Lansweeper Software List by Computer/Server Name
by  Andy.S  
Go to last post Go to first unread
Last post: Yesterday at 8:06:43 AM(UTC)
Lansweeper Asset: Duplicate Serial Number (Built-in)
by  brodiemac-too   Go to last post Go to first unread
Last post: 8/5/2020 1:28:56 PM(UTC)
Lansweeper A Simple Report (or so I thought)
by  Andy.S  
Go to last post Go to first unread
Last post: 8/5/2020 11:30:45 AM(UTC)
Lansweeper Paid Report Writer Service
by  endyk   Go to last post Go to first unread
Last post: 8/4/2020 11:56:20 AM(UTC)
Lansweeper Multiple Computers per User
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/30/2020 12:43:38 PM(UTC)
Lansweeper Workstations with No AV
by  brodiemac-too   Go to last post Go to first unread
Last post: 7/29/2020 7:44:53 PM(UTC)
Lansweeper AV Audit Report
by  RC62N  
Go to last post Go to first unread
Last post: 7/29/2020 5:17:42 PM(UTC)