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

http://happy.prbookmarking.club/story.php?title=activate-windows-10- http://video.prbookmarking.club/story.php?title=norton-setup http://info.prbookmarking.club/story.php?title=office-comsetup%7Center-your-product-key http://codeapp.prbookmarking.club/story.php?title=mcafee-activate http://localseo.prbookmarking.club/story.php?title=activate-net http://seolink.prbookmarking.club/story.php?title=activate-roku http://prbookmarking.club/story.php?title=activate-office-2016-product-key http://paste.highbookmarks.club/story.php?title=activate-windows http://ppcteam.highbookmarks.club/story.php?title=activate-windows-10- http://ppcnet.highbookmarks.club/story.php?title=amc-comactivate-%7C-activate-amc-on-device- http://only.highbookmarks.club/story.php?title=ancestrydna-comactivate- http://map.highbookmarks.club/story.php?title=ancestrydna-comactivate- http://happy.seobookmarking.club/story.php?title=office-setu...
Post a Comment
Read more

Enable Windows Search Service on Windows Server

This article explains how to enable Windows search service on Windows server. The Windows Search service allows clients that are compatible with the search service to perform fast file searches on a server. When you install the Windows Search service on a server, you can use the Windows File Explorer to quickly search for files and file contents. The Windows Search service must be running to enable quick searching. The search service is also available for Windows 10 and Windows 11 users. This service provides content indexing, property caching, and search results for files, e-mail, and other content. On Windows 10/11, if you’re using Microsoft Visio to lookup for newly installed stencils, the Windows Search service should be running. Otherwise, you’ll encounter the error “Visio cannot provide fast search results because Windows Search is not running or is not configured properly for Visio. Please contact your system administrator.” http://staff.akkail.com/viewtopic.php?id=1727 http://s...
Post a Comment
Read more

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