Select
CS
.Name0,
HD
.DeviceID0,
HD
.Index0,
HD
.Size0,
HHD
.Size0
from
dbo
.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_DISK HD on CS.ResourceID = HD.ResourceID join dbo.v_HS_DISK HHD on CS.ResourceID = HHD.ResourceID
Where
HD
.Size0 <> HHD.Size0 And HD.DeviceID0 = HHD.DeviceID0 and HD.Index0 = HHD.Index0
Recent Comments