Category: Queries

April 14, 2021
How to Get the Most Accurate Results from ConfigMgr

In order to get the most accurate results out of Microsoft Endpoint Manager Configuration Manager (MEMCM / ConfigMgr) you must first understand the three key elements of reporting. They are:…

Accurate Results from ConfigMgr - Total Number of Software Titles
April 7, 2021
How to Create a Prompted WQL Query

Did you know that you can write a prompted WQL query within the Microsoft Endpoint Manager Configuration Manager (MEMCM/ConfigMgr/MECM) console? Yes, you can! It is one of those nice features…

Prompted WQL Query - Create Query
January 21, 2021
How to Create Cascading Prompts

Prompts are extremely useful because with a prompt you can limit what is displayed within a report. You can get even more granular results when you add a second or…

Create Cascading Prompts - SysRole
January 13, 2021
How to Create a Collection Prompt Query

This is one of the most requested asks in the forums, “How can I add a collection to my report?” After a bit of toing and froing, what the person…

Collection Prompt Query - End Result - Featured Image
January 6, 2021
Accessing ConfigMgr Reports – Browser or Console

A long time ago, I learned while troubleshooting SQL Server Reporting Services (SSRS) reports, that your first step is always to open the report in a browser. Why? If it…

Run in Browser Option