SELECT
a.LastErrorCode as "Error",
b.Name0,
b.Last_Logon_Timestamp0,
c.Caption0,
d.WUServer0
FROM v_UpdateScanStatus a
inner join v_R_System b on a.ResourceID = b.ResourceID
inner join v_GS_OPERATING_SYSTEM c on a.ResourceID = c.ResourceID
inner join v_GS_WSUSSettings_WSUSServer0 d on a.ResourceID = d.ResourceID
where a.LastErrorCode!= '0'
order by Error ASC