Core ConfigMgr Queries for Power BI

In this next installment for Getting Started with ConfigMgr and Power BI; we will walk through creating a set of core ConfigMgr queries for Power BI.  We will first pull in in your devices, then your collections, and collection members.  These are the foundation queries for every device query afterwards. 

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
(this post)

Please considered that I don’t take 100% credit for the post series queries.  These are made up from multiple sources in our community.  Without the community this may have not been possible. 

Core ConfigMgr Queries for Power BI

Continue reading “Core ConfigMgr Queries for Power BI”

Getting Started with ConfigMgr and Power BI

Welcome to the first series of blogs I plan on doing to help you adopt Power BI into your Configuration Manager (ConfigMgr) environment.  This post will outline getting started with ConfigMgr and Power BI.  Specifically creating your initial template.  We will start by creating Power BI parameters to store your ConfigMgr database server and name.  Finally creating two simple template files, a Direct Query and Import.  

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

(this post)
Core ConfigMgr Queries for Power BI

Power BI Template

Continue reading “Getting Started with ConfigMgr and Power BI”

Configuration Manager (SCCM) Power BI Reporting

I would like to introduce you to the next generation of endpoint reporting we created at Ascent Solutions.  System Center Configuration Manager (SCCM) vNext Reporting with Microsoft Power BI. Microsoft Power BI is the insight engine that your organization needs.  Not with just Configuration Manager reporting, but extending out into your cloud, data center, ITSM, ITAM, and even your security vulnerability scanning appliance. 

Does your organization have a grip on client reporting health, let alone if your getting the latest Windows updates deployed.  These are tough questions to ask new customer’s when we need to properly plan a new roll out.  

This video takes you through some developed possibilities.  These solutions are in constant development. I am adding new insights weekly to these reports. Microsoft’s Power BI give us no limits into your organizational IT makeup, including but, not even close, limited to, Microsoft Operations Management Suite, Azure SQL, Amazon RedShift, Oracle, and MySQL, and etc….

Continue reading “Configuration Manager (SCCM) Power BI Reporting”