Report that shows computers with specific software and the computers OU

[Luminastra]

I have tried to figur out how to make a report that shows me all computers with Office installed, and which OU the computer is located in - but i just cant seem to get anywhere - Any chance someone already made a report like this? and is willing to share?

[Hemoco · Accepted solution]

Please use the report below for this.

SELECT tsysOS.Image AS icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.FQDN, tblAssets.IPAddress, tblADComputers.OU, tblAssets.Firstseen,
tblAssets.Lastseen, tblSoftwareUni.softwareName, tblSoftware.softwareVersion, tblSoftwareUni.SoftwarePublisher, tblSoftware.Lastchanged
FROM tblAssets INNER JOIN
tsysOS ON tblAssets.OScode = tsysOS.OScode INNER JOIN
tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID INNER JOIN
tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID INNER JOIN
tblSoftwareUni ON tblSoftware.softID = tblSoftwareUni.SoftID LEFT OUTER JOIN
tblADComputers ON tblAssets.AssetID = tblADComputers.AssetID
WHERE (tblAssetCustom.State = 1) AND (tblSoftwareUni.softwareName LIKE N'Microsoft%Office%')