Skip to main content

Use CMPivot Query to Find BIOS Details in SCCM

 Learn how to find BIOS details using CMPivot query such as BIOS version, manufacturer, on all your Windows devices managed by SCCM


This article will demonstrate how to use a CMPivot query to retrieve BIOS information, including manufacturer and version, for all of your Windows devices that are SCCM-managed.


While auditing an organization’s SCCM setup, I was asked if it was possible to obtain BIOS information such as the manufacturer and version of devices using SCCM. This organization wanted to upgrade the BIOS of devices that had not been updated in many years.


Yes, it is possible to retrieve the BIOS information from devices because we know SCCM collects hardware data from devices. A CMPivot query can reveal most of your device’s BIOS details, which is useful for an organization. This information can tell you how many of your devices are running a specific version of BIOS.

https://forum.goddesszex.dev/showthread.php?tid=13644

https://forum.21up.co.uk/showthread.php?tid=2779

https://forums.datanav.co.ke/showthread.php?tid=33823

https://foro.muelendhir.com/showthread.php?tid=25101

https://zonaseputarslot.com/showthread.php?tid=254&pid=1784#pid1784

https://www.thewbs.net/pages/forums/showthread.php?tid=3503&pid=3679#pid3679

https://sportsreptile.site/thread-8243.html

https://hondaikmciledug.co.id/HRIS/showthread.php?tid=3619

https://hawkinsmotorcoach.com/forums/thread-1846.html

https://anitapic.forum2go.nl/viewtopic.php?t=4430

https://anitapic.forum2go.nl/viewtopic.php?t=8091

https://anitapic.forum2go.nl/viewtopic.php?t=11485

https://anitapic.forum2go.nl/viewtopic.php?t=10890

https://forum.survival-readiness.com/viewtopic.php?t=15037

https://forum.survival-readiness.com/viewtopic.php?t=23919

https://forum.survival-readiness.com/viewtopic.php?t=8509

https://forum.survival-readiness.com/viewtopic.php?t=24559

https://www.eduli.net/forum.php?mod=viewthread&tid=4205&extra=

https://www.eduli.net/forum.php?mod=viewthread&tid=2459&extra=

https://www.eduli.net/forum.php?mod=viewthread&tid=3558&extra=

https://www.eduli.net/forum.php?mod=viewthread&tid=3607&extra=page%3D1


Examples of CMPivot queries that we have covered so far include:


  • Use SCCM CMPivot Query to Find Installed Patches in Days
  • Find Anti-malware Software Status using CMPivot Query in SCCM
  • Find Recently Used Applications using SCCM CMPivot Query
  • CMPivot Query to Find TPM Status and Details


Ways to gather the BIOS information


From what I know, there are multiple ways to determine the BIOS details of your device:


  • One can manually enter the BIOS mode on a device and find the manufacturer and version of the BIOS.
  • The built-in system information tool on Windows shows the BIOS version and the manufacturer.
  • When using SCCM, a SQL query can also help you check the BIOS details of your devices.
  • Lastly, a CMPivot query can quickly find out the BIOS information from your devices in SCCM.


CMPivot uses the KQL (Kusto Query Language) and it runs the query in real time on all currently connected devices in a selected collection.


List of BIOS Manufacturers


To use the CMPivot query to determine the BIOS manufacturer, you must first know the name of the manufacturer. You’ll need to enter the name of the BIOS manufacturer in the query before you run it.


Some of the more popular BIOS and motherboard vendors are as follows: Some of the more popular BIOS and motherboard vendors include:


  • American Megatrends (AMI)
  • Asus
  • Dell
  • Foxconn
  • Hewlett Packard (HP)
  • IBM
  • Phoenix Technologies
  • Ricoh
  • Insyde Software

http://www.googleseomastermind.com/viewtopic.php?p=169481

http://www.googleseomastermind.com/viewtopic.php?p=169993

http://www.googleseomastermind.com/viewtopic.php?p=169484

http://www.googleseomastermind.com/viewtopic.php?p=169479

https://flotte-plotter-otter.de/viewtopic.php?t=13311

https://flotte-plotter-otter.de/viewtopic.php?t=42319

https://flotte-plotter-otter.de/viewtopic.php?t=34307

https://flotte-plotter-otter.de/viewtopic.php?t=35791

https://tucmas.fi/phpBB/viewtopic.php?t=91230

https://tucmas.fi/phpBB/viewtopic.php?t=95469

https://tucmas.fi/phpBB/viewtopic.php?t=112504

https://tucmas.fi/phpBB/viewtopic.php?t=132758

http://www.66682999.com/redirect.php?fid=2&tid=1157625&goto=nextnewset

http://www.66682999.com/redirect.php?fid=2&tid=377586&goto=nextoldset

http://www.66682999.com/viewthread.php?tid=1406396&extra=page%3D581&frombbs=1

http://www.66682999.com/viewthread.php?tid=776152

https://winda.top/viewtopic.php?f=17&t=390950

https://winda.top/viewtopic.php?f=17&t=396176

https://winda.top/viewtopic.php?f=17&t=537656

https://winda.top/viewtopic.php?f=17&t=114559


Find BIOS details using CMPivot Query


Here is how you can find the BIOS details of your device using a CMPivot query: Launch the SCCM console and navigate to Assets and Compliance > Overview > Device Collections. Right-click a device collection and select Start CMPivot.


Once the CMPivot tool launches, switch to the Query tab and enter the below query to find the BIOS details.

Comments

Post a Comment

Popular posts from this blog

top bookmarks

https://www.crazybacklink.com/post/255694/Ancestrydna-com-activate-Ancestry-DNA-activation-code https://www.ridents.com/post/193120/AMC-com-Activate-Activate-AMC-on-Device-AMC-Activation https://www.linksbeat.com/post/159024/Ancestrydna-com-activate-How-To-Activate-AncestryDNA-Test http://www.ferventing.com/post/176686/office-setup-Enter-product-key http://www.lucidhut.com/post/158360/office-com-setup-Office-Setup-Install-Office-setup http://www.hubcage.com/post/160505/www-office-com-setup https://www.kenplanet.com/post/164530/Activate-Windows-10-8-1-7-Vista-XP-Enter-a-Product-key https://www.shutkey.com/post/139570/Activate-Office-2016 https://www.mbacklinks.com/post/221345/Activate-Office-2016-with-Product-key http://bookbond.dabookmarks.club/story.php?title=activate-office-
1 comment
Read more

top bookmarks

http://smoart.samaysawara.in/story.php?title=ancestrydna-comactivate- http://global.dealsclassified.online/story.php?title=office-setup-6 http://bitcoinstalk.seorankhub.online/story.php?title=office-comsetup-4 https://tuffsocial.com/office-setup-enter-product-key/ https://www.bibsonomy.org/url/bde0d87407e9535db2420b737780c79c https://www.linkedin.com/feed/update/urn:li:activity:6546306890496901121 https://www.flybacklinks.com/post/182265/Activate-Office-2016 https://yashasvisharma.tumblr.com/post/185651004089/activate-office-2016-with-product-key https://diigo.com/0ev9sx http://www.folkd.com/detail/activate-windows.net
Post a Comment
Read more

Install Windows App using Intune: A Step-by-Step Guide

This guide will walk you through the steps to install Windows app using Intune. The new Windows App replaces the apps for Azure Virtual Desktop and Windows 365, simplifying the way to get to the Windows experience you know and love. You can use the Windows App on various platforms and form factors, including desktops and laptops, tablets, smartphones, and through a web browser. When using a web browser on a desktop or laptop, you can connect without having to download and install any software. Until now, you had to use separate apps to connect to your devices hosted in the Microsoft Cloud. Microsoft devised an excellent solution and released a single app known as the Windows app to securely connect to Windows devices and apps on your preferred device, including: https://bbs.identityv.jp/forum.php?mod=viewthread&tid=2299704 https://bbs.identityv.jp/forum.php?mod=viewthread&tid=2431352 https://forums.cyclone-hosting.net/showthread.php?tid=95 https://www.komerican3.com/forum/osan-...
Post a Comment
Read more