LANSweeper : Unaligned Disk Report

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.

{code lang:sql title:”Unaligned Disk Report” lines:false hidden:false}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
{/code}