LANSweeper : Specific Software Deployment Report

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}