Writing SCCM Reports using SQL Joins
Posted by Eswar Koneti on August 30th, 2012
Joins ? In Simple terms they are used to Join more than 2 tables and give you required information.
while working with SCCM reports,we will use SQL Joins in most of the reports to get customized information (not part of default reports).
These joins are used to query data from two or more tables, based on a relationship between certain columns in these tables. It creates a set that can be saved as a table or used as is.
A JOIN is a means for combining fields from two tables by using values common to each. ANSI standard SQL specifies four types of JOIN: INNER, OUTER, LEFT, and RIGHT.
Here is nice Pictorial representation of using SQL Joins.You can keep it as reference when creating reports/collections on the need basis.
INNER JOIN : This Join used to get result when there is at least one match in both tables.
LEFT JOIN :This Join used to get all rows from the left table even if there are no matches in the right table.
RIGHT JOIN : This Join used to get all the rows from the right table, even if there are no matches in the left table
Full Join : This Join used to get all rows when there is a match in one of the tables.
February 13th, 2013 at 5:46 PM
Hi,
I am looking for SCCM2012 query for patch status from specific deployment and specific collection. I need the following details in my patch report with against each machine name
Total patch count in deployment
Total patch count installed
Total patch count missing
Total patch count not required
February 14th, 2013 at 7:39 AM
Did you check the default reports ? You should get something to proceed further.I can get back to you on this later once am done with this.