ConfigMgr gathers and stores a large amount of data across many different tables in its database. This chapter has reviewed the most common and important data classes, as well as their corresponding SQL data views, which are also stored in the database. It has also discussed how to launch and connect to the ConfigMgr database as well as execute some sample queries, using the SQL Server Management Studio tool.
Many sample queries have been provided in this chapter. Some of these queries are fairly simple and others a bit more complex. Don’t worry about trying to understand how to write them just yet! Detailed explanations and examples about how to write SQL queries will be given in later chapters.