Report for out of date Firefox

[RCOTechs]

Hey all, I want to create a report that details all of the computers with out of date Firefox (where firefox <27.0). What is the best way to word that report?

-Nate

[RCOTechs]

Thanks, that worked perfectly!

[LanSweepUser · Accepted solution]

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblFileVersions.Found,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName,
tblFileVersions.Filesize,
tblFileVersions.Lastchanged
From tblAssets
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where tblFileVersions.FilePathfull Like '%firefox.exe' And
tblFileVersions.FileVersion Not Like '27.0%' And tblAssets.Assettype = -1
Order By tblAssets.AssetName

Try this...

I added a small bit of code (And
tblFileVersions.FileVersion Not Like '27.0%') to the "Files: Firefox version" Report already located in Lansweeper

You'll have to edit it a bit if you want/need more info/fields in the report though.

Hope it helps 😉
Grtz