select
    CS.Name0,
    PSE.title0,
    PSE.TimeApplied0
from
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_GS_PATCHSTATEEX PSE on CS.ResourceID = PSE.ResourceID