Mapping System Center - Service Manager properties to Configuration Manager database views
Important
This version of Service Manager has reached the end of support. We recommend you to upgrade to Service Manager 2022.
The hardware inventory feature in Configuration Manager gathers information about computers in the organization. In Service Manager, by using a Configuration Manager Connector, you can import that hardware inventory data from Configuration Manager. The tables in this appendix describe the mapping between Service Manager properties and column names of Configuration Manager database views.
Microsoft.SystemCenter.ConfigurationManager.DeployedComputer
The following table describes the mapping for the Microsoft.SystemCenter.ConfigurationManager.DeployedComputer type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0 |
| Microsoft.SystemCenter.ConfigurationManager.DeployedComputer | HardwareID [Key] | SCCM.Ext.vex_R_System.Hardware_ID0 |
| SMBIOS_UUID | SCCM.Ext.vex_R_System.SMBIOS_GUID0 | |
| SMBIOSAssetTag | SCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.SMBIOSAssetTag0 | |
| Manufacturer | SCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.Manufacturer0 | |
| Model | SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Model0 | |
| NumberOfProcessors | SCCM.Ext.vex_GS_COMPUTER_SYSTEM.NumberOfProcessors0 | |
| SystemType | SCCM.Ext.vex_GS_COMPUTER_SYSTEM.SystemType0 | |
| ChassisType | SCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.ChassisTypes0 | |
| SerialNumber | If SCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.SerialNumber0 is NULL, '00000000' or 'Not Available', then SCCM.Ext.vex_GS_PC_BIOS.SerialNumber0, else SCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.SerialNumber0 |
Microsoft.Windows.Computer
The following table describes the mappings for the Microsoft.Windows.Computer type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0 |
| Microsoft.Windows.Computer | PrincipalName (FQDN) [Key] | Constructed using SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0 or SCCM.Ext.vex_R_System.Netbios_Name0 and SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Domain0 or SCCM.Ext.vex_R_System.Resource_Domain_OR_Workgr0. If SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0 is null, SCCM.Ext.vex_R_System.Netbios_Name0 is used as name. If SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Domain0 is null, SCCM.Ext.vex_R_System.Resource_Domain_OR_Workgr0 is used as domain. |
| NetbiosComputerName | SCCM.Ext.vex_R_System.Netbios_Name0 | |
| NetbiosDomainName | SCCM.Ext.vex_R_System.Resource_Domain_OR_Workgr0 | |
| OffsetInMinuteFromGreenwichTime | SCCM.Ext.vex_GS_Computer_System.CurrentTimeZone0 | |
| IsVirtualMachine | SCCM.Ext.vex_GS_Computer_System.Model0, vex_GS_Manufacturer, that is, Model0 = "Virtual Machine" or "VMware Virtual Platform" OR Manufacturer="Microsoft Corporation" or "VMware, Inc" | |
| ActiveDirectorySite | SCCM.Ext.vex_R_System.AD_Site_Name0 | |
| LastInventoryDate | SCCM.Ext.Vex_GS_Workstation_Status.LastHWScan |
Microsoft.Windows.OperatingSystem
The following table describes the mappings for the Microsoft.Windows.OperatingSystem type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_OPERATING_SYSTEM.Caption0 |
| Microsoft.Windows.OperatingSystem | OSVersion | SCCM.Ext.vex_GS_OPERATING_SYSTEM.Version0 |
| BuildNumber | SCCM.Ext.vex_GS_OPERATING_SYSTEM.BuildNumber0 | |
| CSDVersion | SCCM.Ext.vex_GS_OPERATING_SYSTEM.CSDVersion0 | |
| InstallDate | SCCM.Ext.vex_GS_OPERATING_SYSTEM.InstallDate0 | |
| SystemDrive | SCCM.Ext.vex_GS_OPERATING_SYSTEM.SystemDirectory0 | |
| WindowsDirectory | SCCM.Ext.vex_GS_OPERATING_SYSTEM.WindowsDirectory0 | |
| PhysicalMemory | SCCM.Ext.vex_GS_OPERATING_SYSTEM.TotalVisibleMemorySize0 | |
| LogicalProcessors | SCCM.Ext.vex_GS_COMPUTER_SYSTEM.NmberOfProcessors0 | |
| CountryCode | SCCM.Ext.vex_GS_OPERATING_SYSTEM.CountryCode0 | |
| Locale | SCCM.Ext.vex_GS_OPERATING_SYSTEM.Locale0 | |
| Manufacturer | SCCM.Ext.vex_GS_OPERATING_SYSTEM.Manufacturer0 | |
| OSLanguage | SCCM.Ext.vex_GS_OPERATING_SYSTEM.OSLanguage0 | |
| MinorVersion | SCCM.Ext.vex_GS_OPERATING_SYSTEM.Version0 | |
| MajorVersion | SCCM.Ext.vex_GS_OPERATING_SYSTEM.Version0 |
Microsoft.Windows.Peripherals.LogicalDisk
The following table describes the mappings for the Microsoft.Windows.Peripherals.LogicalDisk type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_LOGICAL_DISK.Name0 |
| Microsoft.Windows.LogicalDevice | DeviceID [Key] | SCCM.Ext.vex_GS_LOGICAL_DISK.DeviceID0 |
| Name | SCCM.Ext.vex_GS_LOGICAL_DISK.Name0 | |
| Description | SCCM.Ext.vex.GS_LOGICAL_DISK.Description0 | |
| Microsoft.Windows.LogicalDisk | VolumeName | SCCM.Ext.vex_GS_LOGICAL_DISK.VolumeName0 |
| Microsoft.Windows.Peripherals.LogicalDisk | FileSystem | SCCM.Ext.vex_GS_LOGICAL_DISK.FileSystem0 |
| Compressed | SCCM.Ext.vex_GS_LOGICAL_DISK.Compressed0 | |
| Size | SCCM.Ext.vex_GS_LOGICAL_DISK.Size0 | |
| DriveType | SCCM.Ext.vex_GS_LOGICAL_DISK.DriveType0 | |
| FreeSpace | SCCM.Ext.vex_GS_LOGICAL_DISK.FreeSpace0 |
Microsoft.Windows.Peripherals.PhysicalDisk
The following table describes the mappings for the Microsoft.Windows.Peripherals.PhysicalDisk type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_DISK.Name0 |
| Microsoft.Windows.LogicalDevice | DeviceID [Key] | SCCM.Ext.vex_GS_DISK.DeviceID0 |
| Name | SCCM.Ext.vex_GS_DISK.Name0 | |
| Description | SCCM.Ext.vex.GS_DISK.Description0 | |
| Microsoft.Windows.PhysicalDisk | MediaType | SCCM.Ext.vex.GS_DISK.MediaType0 |
| PNPDeviceID | SCCM.Ext.vex.GS_DISK.PNPDeviceID0 | |
| Microsoft.Windows.Peripherals.PhysicalDisk | Caption | SCCM.Ext.vex.GS_DISK.Description0 |
| Index | SCCM.Ext.vex.GS_DISK.Index0 | |
| InterfaceType | SCCM.Ext.vex.GS_DISK.InterfaceType0 | |
| Manufacturer | SCCM.Ext.vex.GS_DISK.Manufacturer0 | |
| Model | SCCM.Ext.vex.GS_DISK.Model0 | |
| SCSIBus | SCCM.Ext.vex.GS_DISK.SCSIBus0 | |
| SCSILogicalUnit | SCCM.Ext.vex.GS_DISK.SCSILogicalUnit0 | |
| SCSIPort | SCCM.Ext.vex.GS_DISK.SCSIPort0 | |
| SCSITargetID | SCCM.Ext.vex.GS_DISK.TargetId0 | |
| Size | SCCM.Ext.vex.GS_DISK.Size0 | |
| TotalCylinders | SCCM.Ext.vex.GS_DISK.TotalCylinders0 | |
| TotalHeads | SCCM.Ext.Vex.GS_DISK.TotalHeads0 | |
| TotalSectors | SCCM.Ext.vex.GS_DISK.TotalSectors0 | |
| TotalTracks | SCCM.Ext.vex.GS_DISK.TotalTracks0 | |
| TracksPerCylinder | SCCM.Ext.vex.GS_DISK.TracksPerCylinder0 |
Microsoft.Windows.Peripherals.Processor
The following table describes the mappings for the Microsoft.Windows.Peripherals.Processor type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_PROCESSOR.Name0 |
| Microsoft.Windows.LogicalDevice | DeviceID [Key] | SCCM.Ext.vex_GS_PROCESSOR.DeviceID0 |
| Name | SCCM.Ext.vex_GS_PROCESSOR.Name0 | |
| Description | SCCM.Ext.vex.GS_PROCESSOR.Name0 | |
| Microsoft.Windows.Processor | Family | SCCM.Ext.vex.GS_PROCESSOR.Family0 |
| MaxClockSpeed | SCCM.Ext.vex.GS_PROCESSOR.MaxClockSpeed0 | |
| Type | SCCM.Ext.vex.GS_PROCESSOR.ProcessorType0 | |
| BrandID | SCCM.Ext.vex.GS_PROCESSOR.BrandID0 | |
| PCache | SCCM.Ext.vex.GS_PROCESSOR.PCache0 | |
| CPUKey | SCCM.Ext.vex.GS_PROCESSOR.CPUKey0 | |
| IsMobile (bool) | SCCM.Ext.vex.GS_PROCESSOR.IsMobile0 | |
| IsMultiCore (bool) | SCCM.Ext.vex.GS_PROCESSOR.IsMulticore0 | |
| Microsoft.Windows.Peripherals.Processor | Manufacturer | SCCM.Ext.vex.GS_PROCESSOR.Manufacturer0 |
| Speed | SCCM.Ext.vex.GS_PROCESSOR.NormSpeed0 | |
| DataWidth | SCCM.Ext.vex.GS_PROCESSOR.DataWidth0 | |
| Revision | SCCM.Ext.vex.GS_PROCESSOR.Revision0 | |
| Version | SCCM.Ext.vex.GS_PROCESSOR.Version0 |
Microsoft.Windows.Peripherals.NetworkAdapter
The following table describes the mappings for the Microsoft.Windows.Peripherals.NetworkAdapter type.
| Service Manager type | Service Manager property | Column name of Configuration Manager Database Views |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_NETWORK_ADAPTER.Name0 |
| Microsoft.Windows.LogicalDevice | DeviceID [Key] | SCCM.Ext.vex_GS_NETWORK_ADAPTER.DeviceID0 |
| Name | SCCM.Ext.vex_GS_NETWORK_ADAPTER.Name0 | |
| Description | SCCM.Ext.vex.GS_NETWORK_ADAPTER.Description0 | |
| Microsoft.Windows.NetworkAdapter | Bandwidth | SCCM.Ext.vex.GS_NETWORK_ADAPTER.Speed0 |
| MaxSpeed (int) | SCCM.Ext.vex.GS_NETWORK_ADAPTER.MaxSpeed0 | |
| ProductName | SCCM.Ext.vex.GS_NETWORK_ADAPTER.ProductName0 | |
| DefaultIPGateway | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0 | |
| DHCPHostName | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DHCPServer | |
| IPEnabled | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.IPEnabled0 | |
| Microsoft.Windows.Peripherals.NetworkAdapter | AdapterType | SCCM.Ext.vex.GS_NETWORK_ADAPTER.AdapterType0 |
| Index | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.Index0 | |
| Manufacturer | SCCM.Ext.vex.GS_NETWORK_ADAPTER.Manufacturer0 | |
| MACAddress | SCCM.Ext.vex.GS_NETWORK_ADAPTER.MACAddress0 | |
| ServiceName | SCCM.Ext.vex.GS_NETWORK_ADAPTER.ServiceName0 | |
| DHCPEnabled | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DHCPEnabled0 | |
| DHCPServer | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DHCPServer0 | |
| DNSDomain | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DNSDomain0 | |
| IPAddress | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0 | |
| IPSubnet | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.IPSubnet0 |
System.DeviceHasSoftwareItemInstalled
The following table describes the mappings for the System.DeviceHasSoftwareItemInstalled type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.ProductName0 |
| System.SoftwareItem | ProductName [Key] | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.ProductName0 |
| Publisher [Key] | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.Publisher0 | |
| VersionString [Key] | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.ProductVersion0 | |
| MajorVersion | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.VersionMajor0 | |
| MinorVersion | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.VersionMinor0 | |
| LocaleID | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.Language0 | |
| System.DeviceHasSoftwareItemInstalled | InstalledDate | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.InstalledDate0 |
| InstalledPath | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.InstalledLocation0 | |
| SerialNumber | SCCM.Ext.vex_GS_INSTALLED_SOFTWARE.ProductID0 | |
| IsVirtualApplication | SCCM.Ext.Vex_GS_INSTALLED_SOFTWARE.InstallType |
System.DeviceHasSoftwareUpdateInstalled
The following table describes the mappings for the System.DeviceHasSoftwareUpdateInstalled type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.SoftwareUpdate | Vendor [Key] | SCCM.Ext.vex_LocalizedCategoryInstances.CategoryInstanceName |
| Title [Key] | SCCM.Ext.vex_LocalizedCIProperties.DisplayName | |
| Microsoft.Windows.SoftwareUpdate | ArticleID | SCCM.Ext.vex_UpdateCIs.ArticleID |
| BulletinID | SCCM.Ext.vex_UpdateCIs.BulletinID | |
| SupportString | SCCM.Ext.vex_LocalizedCIProperties.CIInformativeURL | |
| Classification | SCCM.Ext.vex_LocalizedCategoryInstances.CategoryInstanceName | |
| System.DeviceHasSoftwareUpdateInstalled | InstallStatus | SCCM.Ext.vex_UpdateComplianceStatus.Status |
Microsoft.SystemCenter.ConfigurationManager.DCM_CI
The following table describes the mappings for the Microsoft.SystemCenter.ConfigurationManager.DCM_CI type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| Microsoft.SystemCenter.ConfigurationManager.DCM_CI | DisplayName | SCCM.Ext.vex_LocalizedCIProperties.DisplayName |
| UniqueID [Key] | SCCM.Ext.vex_ConfigurationItems.CI_UniqueID | |
| Description | SCCM.Ext.vex_LocalizedCIProperties.Description | |
| IsBaseline | SCCM.Ext.vex_ConfigurationItems.CIType_ID |
Microsoft.SystemCenter.ConfigurationManager.DCM_NoncompliantCI
The following table describes the mappings for the Microsoft.SystemCenter.ConfigurationManager.DCM_NoncompliantCI type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| Microsoft.SystemCenter.ConfigurationManager.DCM_NoncompliantCI | UniqueID [Key] | SCCM.Ext.vex_ConfigurationItems.CI_UniqueID |
| Baseline_UniqueID [Key] | SCCM.Ext.vex_ConfigurationItems.CI_UniqueID | |
| MaxNonComplianceCriticality [Key] | SCCM.Ext.vex_CICurrentComplianceStatus.MaxNoncomplianceCriticality |
System.Domain.User
The following table describes the mappings for the System.Domain.User type.
| Configuration Manager class | Configuration Manager database value | Service Manager property |
|---|---|---|
| System.Domain.User | Domain [Key] | Parse SCCM_Ext.vex_GS_SYSTEM_CONSOLE_USER |
| UserName [Key] | Parse SCCM_Ext.vex_GS_SYSTEM_CONSOLE_USER |
Microsoft.SystemCenter.ConfigurationManagergr.CollectionInf
The following table describes the mapping for the Microsoft.SystemCenter.ConfigurationManagergr.CollectionInf type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.ConfigItem | DisplayName | SCCM_Ext.vex_Collection.CollectionName |
| Microsoft.SystemCenter.ConfigurationManagergr.CollectionInf | Count | Count of computers in collection |
| CollID [Key] | SCCM_Ext.vex_Collection.CollID | |
| CollectionName | SCCM_Ext.vex_Collection.CollectionName | |
| CollectionID | SCCM_Ext.vex_Collection.CollectionID |
Microsoft.ConfigMgr.SoftwarePackage
The following table describes the mapping for the Microsoft.ConfigMgr.SoftwarePackage type.
| Service Manager type | Service Manager property | Column name of Configuration Manager database views |
|---|---|---|
| System.ConfigItem | DisplayName | SCCM_Ext.vex_Package.Name |
| Microsoft.ConfigMgr.SoftwarePackage | ID [Key] | SCCM_Ext.vex_Package.PackageID |
| Version | SCCM_Ext.vex_Package.Version | |
| Language | SCCM_Ext.vex_Package.Language | |
| Manufacturer | SCCM_Ext.vex_Package.Manufacturer | |
| Description | SCCM_Ext.vex_Package.Description |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for