Let’s find out the SCCM CMPivot browser related queries default list of browsers installed on a device. ConfigMgr CMPivot Browser Related Queries discussed in the post are – Find Default Browser and List of Browsers Installed. The Configuration Manager CMPivot helps to get real-time data from online devices.
The ConfigMgr CMPivot provides real-time data based on fast channel architecture. ConfigMgr CMPivot tool allows us to quickly assess the state of devices. This CMPivot query can run only against online devices.
CMPivot Troubleshooting & Log files details are available in the following blog post. The post includes CMPivot architecture and communication details as well. 👉SCCM CMPivot Architecture Fast Channel Making | ConfigMgr.
Start CMPivot Tool
- Navigate to the device collection against which you want to run the CMPivot query.
- Select All Systems device collection.
NOTE! – In a production environment with more than many devices, I don’t recommend using All System collection. Instead, use the collection with a smaller number of devices to try out the query.
- Right-Click on All Systems collection.
- Select Start CMPivot.
- CMPivot Query tool got launched.
- Get familiarized with new query language and CMPivot tool.
- Copy any of the following queries as per the requirement.
- Check out the Run Query button from the SCCM CMPivot tool.
Browsers Installed on the Device
The SMSDefaultBrowser is the main entity used in the query to find out the browser applications installed on the Windows 10 device. As you can see in the following are browser apps installed on the device PROD-WIN20.
Chrome Msedge MicrosoftEdgeCP Firefox Opera iExplore
Default Browser Using CMPivot
Let’s find out the default browser using the CMPivot entity SMSDefaultBrowser. As you can see below in the screen capture, the default browser on my Windows 10 device is MSEdgeHTM (Microsoft new Edge).
Resources
- CMPivot for real-time data in Configuration Manager
- ConfigMgr Microsoft Edge Chromium SQL Query | Custom Report | SCCM
- SCCM CMPivot Query Patches Installed in Last 90 Days | ConfigMgr https://www.anoopcnair.com/sccm-cmpivot-query-patches-installed-in-last-90-days-configmgr/
Nice article. Do you know if MS has any plans to support this feature for Intune only devices?
I have no clue about that … if there is a strong business case … my suggestion would be to raise a user voice
Hello,
I did a CMPivot on SMSDefaultBrowser for a collection of 38,000 machines and the event 4104 became a threat on the security console passing from millions to billions… Any idea what is going on?
Is the collection too big?
Any restrictions on CMPivot SMSDefaulBrowser?
Thanks,
DOm