Query to find all the machines with a specific software installed

select distinct v_R_System.Name0,v_R_System.ResourceID,v_R_System.ResourceType,
v_R_System.SMS_Unique_Identifier0,v_R_System.Resource_Domain_OR_Workgr0,
v_R_System.Client0,Add_Remove_Programs_DATA.DisplayName00,Add_Remove_Programs_DATA.Version00 from v_R_System inner join Add_Remove_Programs_DATA
on Add_Remove_Programs_DATA.MachineID = v_R_System.ResourceId
where Add_Remove_Programs_DATA.DisplayName00 like 'applicationnamehere'
and Add_Remove_Programs_DATA.Version00 like '%'
and v_r_system.Obsolete0 <> '1' and v_R_System.Client0=1