ConfigMgr Make Model Power BI Report

In this installment of the Getting Started with ConfigMgr and Power BI; we create a simple hardware report.  The ConfigMgr Make Model Power BI Report gives the ability to drill down unique hardware configurations.  Ranging from make and model, BIOS versions, and operating system version.  

This post is part of a series of posts in my “Getting Started with ConfigMgr and Power BI”

Getting Started with ConfigMgr and Power BI
Core ConfigMgr Queries for Power BI
(this post)
ConfigMgr Client Boot Time Power BI Report

[su_note note_color=”#90bcc9″ text_color=”#ffffff”]Please considered that I don’t take 100% credit for the below queries.  These are made up from multiple sources in our community.  Without the community this may have not been possible. [/su_note]

The below sections outline creating the ConfigMgr Make Model Power BI Report.  With attention to the SQL query used for pulling device’s hardware information.  

ConfigMgr Make Model Power BI Report

Continue reading