LANSweeper : Unaligned Disk Report
The SQL below will display all disks, that are over 1GB in size and not a system boot disk, in an ‘un-aligned’ state.
Select Top 1000000 tblComputers.ComputerUnique, tblComputers.Computername, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, CAST(ROUND(((tblDiskPartition.size/1024)/1024)/1024,2,0) As Decimal(20,2)) As 'Size (GB)' , tblDiskPartition.StartingOffset, tblDiskPartition.DeviceID, CASE WHEN (tblDiskPartition.StartingOffset/4096 != ROUND(tblDiskPartition.StartingOffset/4096,0)) THEN 'FALSE' ELSE 'TRUE' END As 'Is Aligned?' From tblDiskPartition Inner Join tblComputers On tblDiskPartition.Computername = tblComputers.Computername Inner Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where tblDiskPartition.StartingOffset/4096 != ROUND(tblDiskPartition.StartingOffset/4096,0) and (tblDiskPartition.bootpartition = 0 or tblDiskPartition.BootPartition = NULL) and ROUND(((tblDiskPartition.size/1024)/1024)/1024,2) > 1 Group By tblComputers.ComputerUnique, tblComputers.Computername, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, Web40OSName.Compimage, tblComputers.Computer, tblDiskPartition.StartingOffset, tblDiskPartition.StartingOffset/4096, tblDiskPartition.size , tblDiskPartition.DeviceID Order By dbo.tblComputers.Computer, Count(dbo.tblDiskPartition.Computername) Desc