Vista without SP1 or SP2

Select
CS.Name0,
OS.Caption0,
OS.CSDversion0
From
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID
Where
OS.Caption0 like ‘%Vista%’
and OS.CSDversion0 is Null

Digg This

Leave a Reply

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