Tag: MEMCM

How to Create a Power BI Report using Configuration Manager Data for Devices Pending a Reboot
Microsoft / Guide

How to Create a Power BI Report using Configuration Manager Data for Devices Pending a Reboot

by Anthony Powell - Leave a Comment

Creating a query for Power BI from the System Center Configuration Manager (SCCM) database to identify devices pending a reboot involves several steps. Below is a detailed approach, including the SQL query to extract the relevant data. 1. Understand the SCCM Database Structure The SCCM database contains several tables and views. Key tables/views for this query include: 2. Query to …

How to Create a Power BI Report using Configuration Manager Data for Devices Pending a Reboot Read More
SCCM SUP OOBE ZDP
System Center / Guide / Microsoft

SCCM SUP OOBE ZDP (Out-of-Box Experience Zero Day Patch)

by Andrew Armstrong - Leave a Comment

If you are using SCCM to update your Microsoft devices, then you may have noticed the large amount of Products that are available under the Software Update Point (SUP) configuration. I’ve struggled to find good explanations for each of the products so my plan is to find out as much information as I can for each product and I will …

SCCM SUP OOBE ZDP (Out-of-Box Experience Zero Day Patch) Read More
Reporting on Office 365 Channels with SQL Query
System Center / Microsoft

Reporting on Office 365 Channels with SQL Query

by Andrew Armstrong - Leave a Comment

If you’re responsible for managing Office 365 deployments within your organization, having visibility into which channels your devices are using is crucial for effective administration and maintenance. With the help of SQL queries, you can extract pertinent information from Configuration Manager data, allowing you to generate insightful reports or visualize data using tools like Power BI. In this blog post, …

Reporting on Office 365 Channels with SQL Query Read More