While working with System Center Configuration Manager (SCCM), attaining familiar with the DB structure is a very important part of achieving management and reporting. In this blog, we will discuss how to find the SCCM database name, the location of its WSUS database, and where to find your SCCM database.
What is the SCCM Database?
SCCM uses a SQL Server database to store all configuration and inventory details. This database is vital for controlling clients, installing applications, and keeping the system healthy. Identifying your SCCM database name is the beginning phase of competent management of your environment.
Finding the SCCM Database Name
To find the SCCM database name, do the following:
- SQL Server Management Studio (SSMS):
- Open SSMS and connect to the SQL Server illustration that has SCCM installed.
- In the Object Explorer menu, click on the Databases node. You are supposed to see a database type that usually begins with the prefix of CM_ with the site code after it (e.g. CM_S01).
- SCCM Console:
- Go to the SCCM console.
- Go to Administration > Site Configuration > Sites.
- Click your site, and you will see the database name in the properties under the Database section.
Locating the SCCM WSUS Database
SCCM employed WSUS in order to control the software update process. The WSUS database is also situated in the SQL server and the location is as follows:
- Default Location
- In SCCM installation, WSUS database is by default, set up in the same SQL Server as the SCCM database unless otherwise specified. The WSUS database commonly is called SUSDB.
- To do this, see the WSUS Configuration:
- Run the WSUS console.
- Go to Varieties > WSUS Server Configuration.
- You can see here the database settings which will show where the WSUS database is.
Summary
Finally, the knowledge of where to find the database name and to check the database location of WSUS is very decisive for organized SCCM management. You can be on the road of solving the problem, receiving repair or conducting upgrades at any time, knowing this data will expedite your process.
Through SQL Server Management Studio and the SCCM console, you are able to access the details you need for the health of your SCCM environment in no time. Always make sure your documentation is up to date with these key details so that the system can run smoothly.
