declare @appname varchar(255) 
set @appname = 'name of application'

select 
ic.ComputerName,
ic.InventoryAgent,
ic.InventoryDate,
st.FullName as ApplicationName,
iieu.LastUsedDate,
iieu.NumberOfSessions
from InstalledSoftwareData isd 
join SoftwareTitle st on st.SoftwareTitleID = isd.SoftwareTitleID 
join SoftwareTitleInstallerEvidence stie on stie.SoftwareTitleID = st.SoftwareTitleID 
join ImportedInstallerEvidenceMapping iiem on iiem.InstallerEvidenceID = stie.InstallerEvidenceID 
join ImportedInstalledInstallerEvidenceUsage iieu on iieu.ComplianceConnectionID = iiem.ComplianceConnectionID and iieu.ExternalInstallerID = iiem.ExternalInstallerID 
join ImportedComputer ic on ic.ComplianceComputerID = isd.ComplianceComputerID and ic.ExternalID = iieu.ExternalID and ic.ComplianceConnectionID = iieu.ComplianceConnectionID 
where st.fullname = @appname
union 
select 
ic.ComputerName,
ic.InventoryAgent,
ic.InventoryDate,
st.FullName as ApplicationName,
ifeu.LastUsedDate,
ifeu.NumberOfSessions
from InstalledSoftwareData isd 
join SoftwareTitle st on st.SoftwareTitleID = isd.SoftwareTitleID 
join SoftwareTitleFileEvidence stfe on stfe.SoftwareTitleID = st.SoftwareTitleID 
join ImportedFileEvidenceMapping ifem on ifem.FileEvidenceID = stfe.FileEvidenceID
join ImportedInstalledFileEvidenceUsage ifeu on ifeu.ComplianceConnectionID = ifem.ComplianceConnectionID and ifeu.ExternalFileID = ifem.ExternalFileID
join ImportedComputer ic on ic.ComplianceComputerID = isd.ComplianceComputerID and ic.ExternalID = ifeu.ExternalID and ic.ComplianceConnectionID = ifeu.ComplianceConnectionID 
where st.fullname = @appname