Database Reference
In-Depth Information
Getting ready
You must have deployed a System Center 2012 Configuration Manager environment. The
environment must have the Reporting Services Point role enabled and functional. Addition-
ally, you must have system discovery and inventory enabled.
The account you use to perform the steps in this recipe must have access to the SQL Server
with read access to the Configuration Manager database. The steps use the Microsoft SQL
Server Management Studio (MSSMS) tool.
The recipe's goal is to create a query that returns the NetBIOS name of all the computers
and the operating system name. The views in the database that contain this information are
listed in the following table:
View name
Column
Additional information
Netbios_Name0
This view contains the details for all computers discovered. The view has a unique identi-
fier column called
ResourceID
.
V_R_System
This view contains a list of all operating systems discovered by the hardware inventory
process. The name of the computer is not listed in this view, instead the
ResourceID
identifier is used.
V_GS_OPERATING_SYSTEM Caption0
