→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Luminastra
Engaged Sweeper
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?

1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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%')

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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%')