cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sryan
Engaged Sweeper III
An interesting idea here.

Lansweeper checks some kind of RSS feed and finds the latest version number of Java, Flash, Shockwave, etc.

It then updates an existing report that finds outdated software based on this latest version.

I personally would put that report on the dashboard so my team would know what needs updating.

Here is an example of something I currently use to check for Out of date Java versions.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Java 7 Update%' And
tblSoftware.softwareVersion != '7.0.550' And tblAssetCustom.State = 1
2 REPLIES 2
sryan
Engaged Sweeper III
I see your point. I think these reports will have to be kept and maintained in house then. It's just as much work for me to find out the versions as it would for you guys. Thank you for the reply.
Hemoco
Lansweeper Alumni
The only downside of this idea is that someone needs to keep to list up to date.