Out of Date Software Report by Machine Name?

[script_kitty]

Hi kind of a newb with LS so here goes my question:

is there a way to build a report that displays all the out of date installed software by machine name?

Hope my question makes sense and thanks in advance

[script_kitty]

This was really helpful, thanks so much!

[SuperDaveAPK · Accepted solution]

Kinda. You need to create a report for each software and the version criteria.

Here's my report for showing all machines with Flash less than the current version. Just edit the software name and versions for other any other applications you want to report.

Select Top 1000000 tblAssets.AssetID,
tblAssets.Domain,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate,
tblAssets.Lastseen,
tblAssets.Username,
tblAssets.IPAddress
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblSoftwareUni.softwareName Like '%adobe flash player%ActiveX%' And
tblSoftware.softwareVersion < '26.0.0.131%' And tblSoftware.softwareVersion
Not Like '26.0.0.131%' And tsysAssetTypes.AssetTypename = 'Windows' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblSoftwareUni.softwareName