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