Mastering System Center Configuration Manager 2007 R2

11.7. Basic SQL Commands

So far in the chapter you've seen how to create a new report from the console's New Report Wizard and how to import a report. The other option is to define the report using SQL scripting. This, of course, requires you to know the relevant SQL commands. In general, an understanding of SQL syntax is a huge asset for a Configuration Manager administrator, but not a requirement. However, within the scope of this book, we cannot cover SQL commands in depth. We suggest reading up on basic SQL commands so you can create very rich and powerful reports. Another way to learn is by simply opening existing reports and seeing how they are written.

Although we cannot cover every topic within SQL programming such as how to define queries ...