Use the following query to find a specific applictaion and its deployment data, change the softwareName and softwarePublisher fields to suit.
{code lang:sql showtitle:false lines:false hidden:false}Select tblAssets.AssetName,
tblAssets.Domain,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblSoftwareuni.softwareName Like ‘%Helper Object%’ And tblSoftwareUni.SoftwarePublisher Like ‘%microsoft%’
Order By tblAssets.Domain, tblAssets.AssetUnique, tblSoftwareuni.softwareName{/code}