O'Reilly logo

Mastering System Center Configuration Manager 2007 R2 by Christopher W. Urban, Ron D. Crumbaker, Chris Mosby

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required