cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mister_Nobody
Honored Sweeper II

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)

13 REPLIES 13
Mister_Nobody
Honored Sweeper II

Anybody have this problem?

Mister_Nobody
Honored Sweeper II

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

 

 

 

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
Honored Sweeper II

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

 

 

 

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now