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 Renew Secret keys in SCCM console

Learn how to renew the Entra app's secret key using Configuration Manager console While working in my SCCM lab recently, I realised the secret key for one of my Entra App registrations was expired. I received a console notification with the following message: “One or more Entra app secrets used by Cloud Services have expired. Renew to avoid service disruptions.” Configuration Manager allows you to renew the secret key for an Entra app with a few easy steps. You can also renew client secrets for apps in the Microsoft Entra admin center, which I will cover in a separate guide. You must renew the Microsoft Entra app’s secret key before the end of its validity period. If you let the key expire, Configuration Manager can’t authenticate with Microsoft Entra ID, which will cause your connected Azure/Entra services to stop working. In this tutorial, I will walk you through the procedure of renewing secret keys using SCCM console. You need to have at least the “Cloud Application Administrat...
Post a Comment
Read more