Issues with some wmi class enumeration (USB, Partitions)

[Mister_Nobody]

LS 11-series has strange bug - hundreds of repeating objects on Windows Server.

a lot of duplicates  of Sentinel HASP Key in USB Devices  with same deviceid (no idea what is root cause)

a lot of duplicates of disk partitions (300-600x) (Probably disk mounted on folder is reason of bug or hot-add backup)

[Mister_Nobody]

Report to check USB Devices issue - Count of USB devices

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblUSBDevices.Name,
  tblUSBDevices.DeviceID,
  Count(tblUSBDevices.Name) count
From tblassets
  Inner Join tblUSBDevices On tblassets.AssetID = tblUSBDevices.AssetID
Group By tblassets.AssetID,
  tblassets.AssetName,
  tblUSBDevices.Name,
  tblUSBDevices.DeviceID
Having Count(tblUSBDevices.Name) > 10
Order By count Desc

[Mister_Nobody]

Name DeviceID count
Sentinel HL Key 5&7E7EB71&2&00 359
Sentinel HL Key 5&19ACAC2A&2&00 349
Sentinel HL Key 3&D21051D&0&00 312
Sentinel HL Key 3&15E09D40&0&00 312
SafeNet Inc. Sentinel HL Key 5&2BC9834&4&00 296
Sentinel HASP Key 5&FBFB16A&2&00 292
Sentinel HL Key 5&1ED7FF67&2&00 292
SafeNet Inc. Sentinel HL Key 5&34FF6824&6&00 291
Sentinel HASP Key 5&3B27112A&1&00 289
Sentinel HL Key 5&1245F7C8&1&00 289
Sentinel HL Key 5&15B3AFE0&0&00 101
Sentinel HL Key 5&F8C06DA&3&00 82
Sentinel HL Key 3&20828267&0&00 66
Sentinel HL Key 3&DC8D1C2&0&00 65
Sentinel HL Key 3&DC8D1C2&0&00 64
Sentinel HL Key 3&DC8D1C2&0&00 63
SafeNet Inc. Sentinel HL Key 5&F8C06DA&2&00 63

[Mister_Nobody]

Report to check partition issue - Disk: More than 20 partition

Select Top (1000000) tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  Count(tblDiskPartition.AssetID) As Partitions,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Firstseen As [Created at],
  tblAssets.Lastseen As [Last successful scan]
From tblDiskPartition
  Inner Join tblAssets On tblDiskPartition.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Outer Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID
Where tblAssetCustom.State = 1
Group By tsysOS.Image,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblDiskPartition.AssetID,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname,
  tblAssets.SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
Having Count(tblDiskPartition.AssetID) > 20
Order By tblAssets.AssetName,
  Partitions Desc