→ 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: 
script_kitty
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
SuperDaveAPK
Engaged Sweeper II
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

View solution in original post

2 REPLIES 2
script_kitty
Engaged Sweeper II
This was really helpful, thanks so much!
SuperDaveAPK
Engaged Sweeper II
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