Harddisk changes

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

Leave a Reply

Your email address will not be published. Required fields are marked *