Notification

Icon
Error

Firefox 100 & ESR 91.9

Posted: Wednesday, May 4, 2022 12:54:39 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 2,187
0
Like
The latest report for Firefox 100 & ESR 91.9 is now live.
LANGuy
#1LANGuy Member Posts: 13  
posted: 5/18/2022 8:31:26 PM(UTC)
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
#2Esben.D Member Administration Original PosterPosts: 2,187  
posted: 6/1/2022 1:21:24 PM(UTC)
Bit late but for the future reference:

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


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

Code:
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).

Active Discussions

Lansweeper mail reports
by  Andy.S   Go to last post Go to first unread
Last post: 7/1/2022 2:38:18 PM(UTC)
Lansweeper Adding an "Employee ID" column to an asset report
by  ABaker  
Go to last post Go to first unread
Last post: 6/30/2022 3:06:54 PM(UTC)
Lansweeper Firefox 102 & ESR 91.11
by  Esben.D   Go to last post Go to first unread
Last post: 6/30/2022 8:12:07 AM(UTC)
Lansweeper Performance report not shows result
by  NoraD  
Go to last post Go to first unread
Last post: 6/28/2022 7:52:27 AM(UTC)
Lansweeper Duplicate AD Users
by  Randy Costa   Go to last post Go to first unread
Last post: 6/27/2022 5:25:04 PM(UTC)
Lansweeper Multiple Devices Owned by Users (asset relations)
by  Adrian Scott  
Go to last post Go to first unread
Last post: 6/22/2022 5:34:51 PM(UTC)