MEMCM

Microsoft Endpoint Manager Environment Changes

Chatting with a new customer, and the common need came up, a formal document outlining the needed changes to implement Microsoft Endpoint Manager in a Configuration Manager only environment.  These changes are available on Microsoft’s Docs website, but found through various links and products.   This will be an attempt to centralize and simplify the change request. 

This post will cover the changes for Azure AD, Intune, and Configuration Manager to implement co-management and a cloud management gateway.   If your organization is implementing these solutions, below will be a guide for the Microsoft Endpoint Manage environment changes. 

Azure AD

The Intune application for Mobility (MDM and MAM) will get configured in Azure AD.  This will allow automatic enrollment. Here we limit the scope to our test group based on either an on-premises synchronized security group or an Azure AD security group. 

  1. Sign into https://portal.azure.com
  2. Go to Azure Active Directory
  3. Select Mobility (MDM and MAM)
    Azure AD Mobility MDM & MAM Settings
  4. If this is for production rollout select All. If for a pilot or proof of concept select Some and select to be targeted group(s)
    MDM Enrollment Configuration

Continue reading…

ConfigMgr Client Boot Time Power BI Report

In this installment of the Getting Started with ConfigMgr and Power BI; we create a simple client boot time report.  The ConfigMgr Client Boot Time Power BI Report gives the ability to drill down unique boot time configuration ranging from group policy to event viewer startup times.   

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
ConfigMgr Make Model Power BI Report
(this post)

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. 

The below sections outline creating the ConfigMgr Client Boot Time Power BI Report.  With attention to the SQL query used for pulling device’s boot configuration.  

ConfigMgr Client Boot Times Power BI
Continue reading…

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

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. 

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…

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)
ConfigMgr Make Model Power BI Report
ConfigMgr Client Boot Time Power BI Report

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…

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
ConfigMgr Make Model Power BI Report
ConfigMgr Client Boot Time Power BI Report

Power BI Template

Continue reading…