Subselect Query for Reports (SQL)

By Garth Jones 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. Today’s blog post will show you how to create a subselect query in order to discover which PCs do not have Microsoft Project 2010 installed using T-SQL (generally called SQL) for...

Read More»

The Subselect Query

By Garth Jones In my blog posts from last week I talked about how queries are processed and how a Not Equal To operator is processed. In this blog post I will help you write a subselect query in order to determine what PCs are missing a specific type of software. A subselect query is made up of two parts:...

Read More»

How Queries Are Processed

By Garth Jones A question that comes up from time to time is about how to locate PCs that do not have a specific type of software installed. A common mistake is to think that you need to use either Not Equal To or Not Like within a query. However, by using these operators in your query the end result...

Read More»

Get the Most Accurate and Up-to-Date Data Using the v_R_System_Valid SQL Query in Configuration Manager 2012

By Garth Jones When you delete a PC from the System Center 2012 Configuration Manager (CM12) console it is NOT deleted from the database at the same time. Yes you read that right! The CM12 console does NOT delete a PC from the database right away. Depending on how you write your queries, this may affect your results and you...

Read More»