Registry: Firefox version (Built-in)

[Daniel_B]

List of computers with Firefox version information

Pre-requisite: Scanning the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Mozilla\Mozilla Firefox, RegValue CurrentVersion, is enabled under Configuration\Custom Scanning


Meets all the following criteria:
- Active asset
- Windows asset
- Firefox installed

Sorted on:
- Asset name

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblRegistry.Regkey,
  tblRegistry.Valuename,
  tblRegistry.Value,
  tblRegistry.Lastchanged
From tblAssets
  Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Regkey Like '%mozilla firefox' And tblAssets.Assettype = -1
Order By tblAssets.AssetName