Let’s help to analyze the Mozilla Firefox browser installation using SCCM—ConfigMgr Custom Report for Firefox Browser. Also, try to discover how to install the Firefox browser using SCCM.
Let’s try to create a custom report to find Mozilla Firefox versions installed on Windows 10 devices. You don’t have to enable software inventory to get the inventory for the Firefox browser installation.
Related post – Deploy Firefox using SCCM Step-by-Step Guide.
| Index |
|---|
| Custom Report for Firefox Browser |
| Results ConfigMgr Custom Report for Firefox Browser |
Custom Report for Firefox Browser
Let’s find out which Firefox browser is installed on Windows 10 devices. The following steps will help you create a custom report for Firefox browsers.
- Open the SQL Management Studio.
- Click on the New Query button.
- Select the CM_MEM database from the drop-down menu.
- MEM is the ConfigMgr site code.
Copy the following SQL query to find the Firefox browser.
- Click on the Execute button.
Select Distinct
v_R_System.Name0 as 'machine',
v_R_System.User_Name0 as 'username',
v_R_System.AD_Site_Name0 as 'Location',
v_R_System.Resource_Domain_OR_Workgr0 as 'Domain',
v_Add_Remove_Programs.DisplayName0 as 'displayname',
v_Add_Remove_Programs.Version0 as 'Version'
From v_R_System
Join v_Add_Remove_Programs on v_R_System.ResourceID = v_Add_Remove_Programs.ResourceID
Where v_Add_Remove_Programs.DisplayName0 Like '%Mozilla Firefox%'
and v_Add_Remove_Programs.DisplayName0 not Like '%update%'
and v_R_System.Active0 = '1'Let’s find the results of the query.
Results ConfigMgr Custom Report for Firefox Browser
Let’s export the report from SQL Management Studio to a CSV file.
| Machine | User Name | Location | Domain | Display Name | Version |
|---|---|---|---|---|---|
| PROD-WIN20 | NULL | Default-First-Site-Name | MEMCM | Mozilla Firefox 75.0 (x64 en-US) | 75 |
Resources
- Creating custom report models for Configuration Manager in SQL Server Reporting Services.
- FIX Firefox Installation Failed SCCM Reporting Issue| ConfigMgr
We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.
Author
Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.