Try this:
SELECT v_UpdateInfo.ArticleID, v_UpdateInfo.BulletinID, v_UpdateInfo.Title,
v_StateNames.StateName, v_UpdateComplianceStatus.LastStatusCheckTime,
v_UpdateComplianceStatus.LastEnforcementMessageTime
FROM v_R_System INNER JOIN v_UpdateComplianceStatus ON
v_R_System.ResourceID = v_UpdateComplianceStatus.ResourceID INNER JOIN v_UpdateInfo ON
v_UpdateComplianceStatus.CI_ID = v_UpdateInfo.CI_ID INNER JOIN v_StateNames ON
v_UpdateComplianceStatus.LastEnforcementMessageID = v_StateNames.StateID
WHERE (v_StateNames.TopicType = 402) AND (v_R_System.Netbios_Name0 LIKE 'Computer1')
ORDER BY v_StateNames.StateName, v_UpdateInfo.DateLastModified
Referring from this doc: Sample queries for software updates in Configuration Manager
Best regards,
Cosmog Hong