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

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

How to Schedule Windows Reboot using Intune

In this guide, you will learn how to schedule Windows reboot using Intune. You can use Microsoft Intune to schedule a reboot of Windows 10/11 devices on a specific date and time. The steps covered in this guide will work on Windows 11 and Windows 10 devices enrolled in Intune. The idea of scheduling reboots on Windows devices is intriguing. Administrators can ensure that the device is restarted at a convenient time that minimizes user disruption by scheduling a reboot through the Schedule Reboot in Intune. All this can be achieved with a configuration policy in Intune. Scheduling Windows reboots is an essential task for maintaining the performance and security of your devices. Administrators can ensure that Windows device reboots happen on a specific date and time, all from a centralized location. With Intune, you have the flexibility to schedule daily or weekly reboots for your Windows devices or to have them reboot at a specific time and date. http://www.bestpop.co.kr/bbs/board.php?b...
Post a Comment
Read more