External USB Drives

Discover USB Drives Within Your Environment

Discover potential security risks caused by external USB drives. While USB drives can be useful for transferring files. In a modern network environment, with the improvements to LAN speeds and shared drives USB drives have mostly been replaced. However, if USB drives are used they are also very useful to spread malware or spyware from a home office to a corporate network.
Detecting USB drives can be used to enforce company policies regarding USB drive usage, or to detect the source of potentially harmful files found.

Windows USB connected devices report

External USB Drives Report Query

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblFloppy.Manufacturer As [Drive Manufacturer],
  tblFloppy.Model As [Drive Model],
  tblFloppy.Size,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
  Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.State = 1 And tblFloppy.InterfaceType = N'USB'
Order By tblAssets.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting