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 · Accepted solution]

Clean job for usb devices:

 delete from tblUSBDevices where tblUSBDevices.LastChanged
  < (select max(intern.LastChanged) from tblUSBDevices as intern where intern.AssetID=tblUSBDevices.AssetID and intern.DeviceID=tblUSBDevices.DeviceID and intern.name=tblUSBDevices.name)

[Mister_Nobody]

Anybody have this problem?

[Mister_Nobody]

Report to check USB Devices issue - Duplicate USB devices

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblUSBDevices.Name,
  tblUSBDevices.DeviceID,
  Count(tblUSBDevices.DeviceID) count
From tblassets
  Inner Join tblUSBDevices On tblassets.AssetID = tblUSBDevices.AssetID
Group By tblassets.AssetID,
  tblassets.AssetName,
  tblUSBDevices.Name,
  tblUSBDevices.DeviceID
Having Count(tblUSBDevices.DeviceID) > 1
Order By tblassets.AssetName,
  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: duplicate partitions

Select Top 1000000 tblAssets.AssetName,
  tblDiskPartition.[Index],
  tblDiskPartition.DiskIndex,
  tblDiskPartition.Type,
  tblDiskPartition.Size,
  Count(tblDiskPartition.Win32_DiskPartitionid) count,
  tblAssets.AssetID
From tblDiskPartition
  Inner Join tblAssets On tblAssets.AssetID = tblDiskPartition.AssetID
Group By tblAssets.AssetName,
  tblDiskPartition.[Index],
  tblDiskPartition.DiskIndex,
  tblDiskPartition.Type,
  tblDiskPartition.Size,
  tblAssets.AssetID
Having Count(tblDiskPartition.Win32_DiskPartitionid) > 1