As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) administrator, you will be asked to create reports. MECM Reporting really really SQL Server Reporting Services (SSRS) reporting. In some case it is Power BI Desktop or Power BI Report...
A user on Reddit ask How to query a Service status within a SQL query? They wanted to create a SQL Server Reporting Service (SSRS) Report with the results. They of course are using Microsoft Endpoint Manager Configuration Manage (MEMCM / MECM / SCCM) as the source for...
Before starting to write a SQL Server Reporting Services (SSRS) report, you need to create a SQL query that will be used within the report. I always recommend that you create your query within SQL Server Management Studio (SSMS). Microsoft Endpoint Configuration...
This question comes up from time to time, where someone want to query MEMCM using WQL and runs into problems. I have done allot of work with WQL recently. What you will find when you query WMI with WQL is that you will easily hit WMI timeouts or Quota Violation from...
This blog post is really meant for those who are better at writing SQL Server queries than at writing PowerShell scripts. I am one of those people, so recently I asked myself, “Why not use a SQL Server query to create a PowerShell script?” I did exactly that and this...
