cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
The latest report for Firefox 100 & ESR 91.9 is now live.
2 Comments
LANGuy
Engaged Sweeper II
Thank you for this new report. I'm not understanding on how to modify this report for the new Firefox version 100.0.1 though. Can you help?
Esben_D
Lansweeper Employee
Lansweeper Employee
Bit late but for the future reference:

Len(tblSoftware.softwareVersion) -
Len(Replace(tblSoftware.softwareVersion, '.', '')) = 1


Counts the number of . (period) characters in the version number

Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 101


Takes the second number from the right (and makes it a bigint type). So if the version number is 100.0.1, the code above selects the 0 in the middle.

This should help you decipher the query, because firefox's versions come in different variations, there are quite a few where clauses.
There are versions with 1 period in it. Versions with 2 and also versions with 3 periods in it (thanks Microsoft store app).

New to Lansweeper?

Try Lansweeper For Free

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

Try Now