cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RCOTechs
Engaged Sweeper
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
1 ACCEPTED SOLUTION
LanSweepUser
Engaged Sweeper
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

View solution in original post

2 REPLIES 2
RCOTechs
Engaged Sweeper
Thanks, that worked perfectly!
LanSweepUser
Engaged Sweeper
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now