- Using Data Classes and SQL Views
- Using Tools for Creating Reports
- Demonstrating SQL Server Management Studio
- Summary
Demonstrating SQL Server Management Studio
The purpose of this section is to help you become familiar with the SQL Server Management Studio tool discussed in this chapter. You will create and execute a query and look at views.
Creating and Executing a Query
Follow these steps to create and execute a query:
Open SQL Server Management Studio and connect to your ConfigMgr database server. See the “Connecting to the ConfigMgr Database Server” section of this chapter for detailed information on how to perform this step.
Using the dropdown list of available databases, change the database to your ConfigMgr site database.
Open a new query by clicking New Query in the SQL Server Management Studio menu bar.
Open the PatchReport.txt file provided in the online content for this book (see Appendix C for information) and then copy and paste the contents to the new query page.
Click Execute to execute the query.
Review the results.
Looking at Views
Follow these steps to look at a view:
Using the Object Explorer, expand the Databases folder and the ConfigMgr database.
Drill down into Views and note the available columns for the following table views:
dbo.v_R_System
dbo.v_GS_Computer_System
dbo.v_Add_Remove_Programs