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.
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