Default Browser and Version

[Esben_D]

To scan the default browser, you'll first need to scan the correct registry key. Take a look at the "Scanning Registry values" Kb article if you need more information on how to do so.

Make sure the following registry key and value is scanned by Lansweeper:

• Rootkey: HKEY_CURRENT_USER
  
• Regpath: Software\Microsoft\Windows\Shell\Associations\UrlAssociations\https\UserChoice
  
• Regvalue: ProgId

Once you've rescanned your assets, run the report below. Instructions to add this report to your Lansweeper installation can be found here: https://www.lansweeper.com/forum/yaf_postst9882_How-to-run-a-report.aspx

The report will only provide a browser version for the following browsers:

• Google Chrome
  
• Mozilla Firefox
  
• Internet Explorer
  
• Opera
  
• Safari

If needed, you can modify the report to add support for the browser used in your network.

Select Distinct Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  Case
    When SubQuery1.Valuename Is Not Null And SubQuery1.Valuename <> ''
    Then 'Yes'
    Else 'No'
  End As [Registry Value Found],
  Case
    When SubQuery1.Value Like 'Chrome%' Then 'Google Chrome'
    When SubQuery1.Value Like 'Firefox%' Then 'Mozilla Firefox'
    When SubQuery1.Value Like 'AppX%' Then 'Microsoft Edge'
    When SubQuery1.Value Like 'IE%' Then 'Internet Explorer'
    When SubQuery1.Value Like '%Safari%' Then 'Safari'
    When SubQuery1.Value Like '%Opera%' Then 'Opera'
    Else SubQuery1.Value
  End As [Default Browser],
  Case
    When SubQuery1.Value Like 'Chrome%' Then ChromeSubquery.softwareVersion
    When SubQuery1.Value Like 'Firefox%' Then FirefoxSubquery.softwareVersion
    When SubQuery1.Value Like 'IE%' Then IESubquery.softwareVersion
    When SubQuery1.Value Like '%Safari%' Then SafariSubquery.softwareVersion
    When SubQuery1.Value Like '%Opera%' Then OperaSubquery.softwareVersion
    Else ''
  End As [Browser Version],
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  TsysLastscan.Lasttime As LastRegistryScan,
  SubQuery1.Lastchanged As LastRegistryChange,
  Case
    When TsysLastscan.Lasttime < GetDate() - 1 Then
      'Last registry scan more than 24 hours ago! Scanned registry information may not be up-to-date. Try rescanning this machine.'
  End As Comment
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
  Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
  Left Join (Select Top 1000000 tblRegistry.AssetID,
        tblRegistry.Regkey,
        tblRegistry.Valuename,
        tblRegistry.Value,
        tblRegistry.Lastchanged
      From tblRegistry
      Where
        tblRegistry.Regkey Like
        '%Software\Microsoft\Windows\Shell\Associations\UrlAssociations\https\UserChoice' And tblRegistry.Valuename = 'ProgId') SubQuery1 On SubQuery1.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblSoftware.softwareVersion,
        tblAssets.AssetID
      From tblAssets
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Chrome%') ChromeSubquery On
    ChromeSubquery.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblSoftware.softwareVersion,
        tblAssets.AssetID
      From tblAssets
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Firefox%') FirefoxSubquery On
    FirefoxSubquery.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblSoftware.softwareVersion,
        tblAssets.AssetID
      From tblAssets
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Internet Explorer%') IESubquery On
    IESubquery.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblSoftware.softwareVersion,
        tblAssets.AssetID
      From tblAssets
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Safari%') SafariSubquery On
    SafariSubquery.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblSoftware.softwareVersion,
        tblAssets.AssetID
      From tblAssets
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Opera%') OperaSubquery On
    OperaSubquery.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And TsysWaittime.CFGname = 'registry'
Order By tblAssets.Domain,
  tblAssets.AssetName

[RCorbeil]

Based on my inventory Chromium Edge seems to be recorded in Add/Remove Programs, but Legacy Edge isn't, so no joy pulling that without going through some extra gymnastics.

To your question , hlee@fugro.com, adding Microsoft Edge to the recognized list should be straightforward enough.

First, add one more subquery to connect to the Edge version info:

  Left Join (Select Top 1000000 tblSoftware.softwareVersion,
        tblAssets.AssetID
      From tblAssets
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName = 'Microsoft Edge') MSEdgeSubquery On
    MSEdgeSubquery.AssetID = tblAssets.AssetID

(I don't use LIKE '%Microsoft Edge%' because my inventory would return "Microsoft Edge Beta" and "Microsoft Edge Update" as results. The few machines that have Chromium Edge installed show the software name as "Microsoft Edge".)

Now that you're pulling the Microsoft Edge version info, edit the CASE that returns the browser version number and add a reference to MS Edge:

  Case
    When SubQuery1.Value Like 'Chrome%' Then ChromeSubquery.softwareVersion
    When SubQuery1.Value Like 'Firefox%' Then FirefoxSubquery.softwareVersion
    When SubQuery1.Value Like 'IE%' Then IESubquery.softwareVersion
    When SubQuery1.Value Like '%Safari%' Then SafariSubquery.softwareVersion
    When SubQuery1.Value Like '%Opera%' Then OperaSubquery.softwareVersion
    When SubQuery1.Value = 'Microsoft Edge' Then MSEdgeSubquery.softwareVersion
    Else ''
  End As [Browser Version],

[Noobmode]

FYI, if you use the PolicyPak Browser Router tool to set the default browser, the key that shows up is PPBRNURL. It won't show the desired browser information due to how PolicyPak handles the default browser settings.

https://www.policypak.com/knowledge-base/browser-router-tips-and-tricks/what-is-meant-by-default-browser-within-policypak-browser-router.html

[BES_IT]

This also reports Microsoft Edge just without the version number which you didn't mention.

[Esben_D]

BES_IT wrote:
This also reports Microsoft Edge just without the version number which you didn't mention.

I listed the browsers for which it will provide a version. Since there is no connection between custom registry data and the software data, it has to be matched by name.
Also Edge is not part of the "Add & Remove Software" on Windows, so it's currently not scanned.

[hlee]

Esben.D wrote:

BES_IT wrote:
This also reports Microsoft Edge just without the version number which you didn't mention.

I listed the browsers for which it will provide a version. Since there is no connection between custom registry data and the software data, it has to be matched by name.
Also Edge is not part of the "Add & Remove Software" on Windows, so it's currently not scanned.

Hi Esben.D, thanks for creating the report! Is it possible to add the new Microsoft Edge Chromium since it is now showing in Add & Remove Software list, with the version number for this report? That would be very helpful. Thanks!