Model Query
SELECT
SMS_R_System.ResourceID,
SMS_R_System.ResourceType,
SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_R_System.Client
FROM
SMS_R_System
INNER JOIN SMS_G_System_COMPUTER_SYSTEM
ON SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
WHERE SMS_G_System_COMPUTER_SYSTEM.Model = “OptiPlex 3020”
Results: