New Browser Version Reports

[Esben_D]

Hi,

As you might know, last year we created new reports for every new major browser version. To be more efficient and spam people less. We've spent the last month creating versions of these reports that are more future proof and should let you identify outdated versions without having to add a new report every single time. 

These reports work similar to the "Not highest OS" report. By using the highest version scanned in your environment, they are able to display devices that have a lower version. Do note that this functionality is only available on-prem. The Lansweeper site variants of the report provide a more general overview of devices with that specific browser.

You can find the new reports here:

https://www.lansweeper.com/resources/report/software/safari-version-audit/

https://www.lansweeper.com/resources/report/software/microsoft-edge-version-audit/ 

https://www.lansweeper.com/resources/report/software/mozilla-firefox-version-audit/

https://www.lansweeper.com/resources/report/software/google-chrome-version-audit/

[RebelSys]

Great, That saves time.  But, did you also change the url for the Report library?

The on-prem installation points to https://www.lansweeper.com/report and lands on a page with the message "Error establishing a database connection". the link should be https://www.lansweeper.com/resources/report.

[Mister_Nobody]

@Esben_D you can add coloring if versions are same

[Mister_Nobody]

@Esben_D is there recommendation to use_ or __ for aliases?

[Esben_D]

@RebelSys Could you please report this to support? As you can see if you browse to  https://www.lansweeper.com/report it automatically redirects, so I'm not sure how its giving you a DB error.

@Mister_Nobody I'm not sure coloring is possible, if it is it will likely be quite complex. I'm honestly not even sure if it is possible without creating custom DB tables to store each detected version and assign a color code to it.

For the Aliases, its just purely coincidental, you can use whatever you like AFAIK.

[Mister_Nobody]

@Esben_D I wanted such coloring:

Select Top 1000000 tblAssets.AssetID,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.AssetName,
  tblSoftwareUni.softwareName As Software,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tblSoftware.softwareVersion As Version,
  b.LatestVersion As [Highest Version Detected],
  tblSoftware.Lastchanged,
  tblAssets.Lastseen,
  Case
    When b.LatestVersion = tblSoftware.softwareVersion Then '#d4f4be'
  End As backgroundcolor
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join (Select __.SoftID,
      __.Major,
      __.Minor,
      __.Build,
      __.Revision,
      LatestVersion = __.softwareVersion
    From (Select *,
          r = Row_Number() Over (Partition By _.SoftID Order By _.Major Desc,
          _.Minor Desc, _.Build Desc, _.Revision Desc)
        From (Select Distinct tblSoftware.SoftID,
              Major = Convert(int,ParseName(tblSoftware.softwareVersion, 4)),
              Minor = Convert(int,ParseName(tblSoftware.softwareVersion, 3)),
              Build = Convert(int,ParseName(tblSoftware.softwareVersion, 2)),
              Revision = Convert(int,ParseName(tblSoftware.softwareVersion, 1)),
              tblSoftware.softwareVersion
            From tblSoftware
              Inner Join tblSoftwareUni On tblSoftware.SoftID =
                  tblSoftwareUni.SoftID
            Where tblSoftwareUni.softwareName Like ('%Microsoft Edge')) _) __
    Where __.r = 1) b On tblSoftware.SoftID = b.SoftID
Where tblSoftwareUni.softwareName Like ('%Microsoft Edge') And
  tblState.Statename = 'Active'