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\_ADD\_REMOVE\_PROGRAMS\_64 on SMS\_G\_System\_ADD\_REMOVE\_PROGRAMS\_64.ResourceId = SMS\_R\_System.ResourceId where SMS\_G\_System\_ADD\_REMOVE\_PROGRAMS\_64.DisplayName like "%KB4012213%"

Results: