Subselect Query for Reports (SQL)

Subselect Query for Reports (SQL)

by | Sep 18, 2014 | ConfigMgr, How-To

This post is a continuation of my series about how queries are processed. Please start with the first blog post in this series for more details. As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) reports, which is really SQL Server...
The Subselect Query

The Subselect Query

by | Sep 17, 2014 | ConfigMgr, How-To

Earlier, in my blog posts from last week I talked about how queries are processed and how a Not Equal To operator is processed. At any rate, in this blog post I will help you to write a subselect query in order to determine what PCs are missing a specific type of...
How a Not Equal To Query is Processed

How a Not Equal To Query is Processed

by | Sep 11, 2014 | ConfigMgr, How-To

During and building on yesterday’s blog post about how a query is processed this post will show you how a query processes the Not Equal To operator. I should start out by saying Not Equal to is also shown with query as “Not (…=…)” or as...
Disabled Software Metering Rules Are a Good Thing!

Disabled Software Metering Rules Are a Good Thing!

by | Jul 22, 2014 | ConfigMgr

In a previous blog post entitled, “Total Usage for All Metered Software Programs Query Matches the Executable Name,”. Reporting will show results for Disabled Software Metering Rules rules. I closed off that blog post by saying that this was in fact a good thing. So...