select
    R.Name,
    OS.Caption,
    OS.CSDVersion
from 
    SMS_R_System R
    inner join SMS_G_System_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceId
where
    OS.CSDVersion is null
    and OS.Caption like “%Vista%”