TechNet
Table of contents
TOC
Collapse the table of content
Expand the table of content

Appendix C - Mapping System Center 2016 - Service Manager Properties to Configuration Manager Database Views

Bill Anderson|Last Updated: 7/1/2016
|
4 Contributors

Applies To: System Center 2016 Technical Preview - Service Manager

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 typeService Manager propertyColumn name of Configuration Manager database views
System.EntityDisplayNameSCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0
Microsoft.SystemCenter.ConfigurationManager.DeployedComputerHardwareID [Key]SCCM.Ext.vex_R_System.Hardware_ID0
SMBIOS_UUIDSCCM.Ext.vex_R_System.SMBIOS_GUID0
SMBIOSAssetTagSCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.SMBIOSAssetTag0
ManufacturerSCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.Manufacturer0
ModelSCCM.Ext.vex_GS_COMPUTER_SYSTEM.Model0
NumberOfProcessorsSCCM.Ext.vex_GS_COMPUTER_SYSTEM.NumberOfProcessors0
SystemTypeSCCM.Ext.vex_GS_COMPUTER_SYSTEM.SystemType0
ChassisTypeSCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.ChassisTypes0
SerialNumberIf 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 typeService Manager propertyColumn name of Configuration Manager database views
System.EntityDisplayNameSCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0
Microsoft.Windows.ComputerPrincipalName (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.
NetbiosComputerNameSCCM.Ext.vex_R_System.Netbios_Name0
NetbiosDomainNameSCCM.Ext.vex_R_System.Resource_Domain_OR_Workgr0
OffsetInMinuteFromGreenwichTimeSCCM.Ext.vex_GS_Computer_System.CurrentTimeZone0
IsVirtualMachineSCCM.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"
ActiveDirectorySiteSCCM.Ext.vex_R_System.AD_Site_Name0
LastInventoryDateSCCM.Ext.Vex_GS_Workstation_Status.LastHWScan

Microsoft.Windows.OperatingSystem

The following table describes the mappings for the Microsoft.Windows.OperatingSystem type.

Service Manager typeService Manager propertyColumn name of Configuration Manager database views
System.EntityDisplayNameSCCM.Ext.vex_GS_OPERATING_SYSTEM.Caption0
Microsoft.Windows.OperatingSystemOSVersionSCCM.Ext.vex_GS_OPERATING_SYSTEM.Version0
BuildNumberSCCM.Ext.vex_GS_OPERATING_SYSTEM.BuildNumber0
CSDVersionSCCM.Ext.vex_GS_OPERATING_SYSTEM.CSDVersion0
InstallDateSCCM.Ext.vex_GS_OPERATING_SYSTEM.InstallDate0
SystemDriveSCCM.Ext.vex_GS_OPERATING_SYSTEM.SystemDirectory0
WindowsDirectorySCCM.Ext.vex_GS_OPERATING_SYSTEM.WindowsDirectory0
PhysicalMemorySCCM.Ext.vex_GS_OPERATING_SYSTEM.TotalVisibleMemorySize0
LogicalProcessorsSCCM.Ext.vex_GS_COMPUTER_SYSTEM.NmberOfProcessors0
CountryCodeSCCM.Ext.vex_GS_OPERATING_SYSTEM.CountryCode0
LocaleSCCM.Ext.vex_GS_OPERATING_SYSTEM.Locale0
ManufacturerSCCM.Ext.vex_GS_OPERATING_SYSTEM.Manufacturer0
OSLanguageSCCM.Ext.vex_GS_OPERATING_SYSTEM.OSLanguage0
MinorVersionSCCM.Ext.vex_GS_OPERATING_SYSTEM.Version0
MajorVersionSCCM.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 typeService Manager propertyColumn name of Configuration Manager database views
System.EntityDisplayNameSCCM.Ext.vex_GS_LOGICAL_DISK.Name0
Microsoft.Windows.LogicalDeviceDeviceID [Key]SCCM.Ext.vex_GS_LOGICAL_DISK.DeviceID0
NameSCCM.Ext.vex_GS_LOGICAL_DISK.Name0
DescriptionSCCM.Ext.vex.GS_LOGICAL_DISK.Description0
Microsoft.Windows.LogicalDiskVolumeNameSCCM.Ext.vex_GS_LOGICAL_DISK.VolumeName0
Microsoft.Windows.Peripherals.LogicalDiskFileSystemSCCM.Ext.vex_GS_LOGICAL_DISK.FileSystem0
CompressedSCCM.Ext.vex_GS_LOGICAL_DISK.Compressed0
SizeSCCM.Ext.vex_GS_LOGICAL_DISK.Size0
DriveTypeSCCM.Ext.vex_GS_LOGICAL_DISK.DriveType0
FreeSpaceSCCM.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 typeService Manager propertyColumn name of Configuration Manager database views
System.EntityDisplayNameSCCM.Ext.vex_GS_DISK.Name0
Microsoft.Windows.LogicalDeviceDeviceID [Key]SCCM.Ext.vex_GS_DISK.DeviceID0
NameSCCM.Ext.vex_GS_DISK.Name0
DescriptionSCCM.Ext.vex.GS_DISK.Description0
Microsoft.Windows.PhysicalDiskMediaTypeSCCM.Ext.vex.GS_DISK.MediaType0
PNPDeviceIDSCCM.Ext.vex.GS_DISK.PNPDeviceID0
Microsoft.Windows.Peripherals.PhysicalDiskCaptionSCCM.Ext.vex.GS_DISK.Description0
IndexSCCM.Ext.vex.GS_DISK.Index0
InterfaceTypeSCCM.Ext.vex.GS_DISK.InterfaceType0
ManufacturerSCCM.Ext.vex.GS_DISK.Manufacturer0
ModelSCCM.Ext.vex.GS_DISK.Model0
SCSIBusSCCM.Ext.vex.GS_DISK.SCSIBus0
SCSILogicalUnitSCCM.Ext.vex.GS_DISK.SCSILogicalUnit0
SCSIPortSCCM.Ext.vex.GS_DISK.SCSIPort0
SCSITargetIDSCCM.Ext.vex.GS_DISK.TargetId0
SizeSCCM.Ext.vex.GS_DISK.Size0
TotalCylindersSCCM.Ext.vex.GS_DISK.TotalCylinders0
TotalHeadsSCCM.Ext.Vex.GS_DISK.TotalHeads0
TotalSectorsSCCM.Ext.vex.GS_DISK.TotalSectors0
TotalTracksSCCM.Ext.vex.GS_DISK.TotalTracks0
TracksPerCylinderSCCM.Ext.vex.GS_DISK.TracksPerCylinder0

Microsoft.Windows.Peripherals.Processor

The following table describes the mappings for the Microsoft.Windows.Peripherals.Processor type.

Service Manager typeService Manager propertyColumn name of Configuration Manager database views
System.EntityDisplayNameSCCM.Ext.vex_GS_PROCESSOR.Name0
Microsoft.Windows.LogicalDeviceDeviceID [Key]SCCM.Ext.vex_GS_PROCESSOR.DeviceID0
NameSCCM.Ext.vex_GS_PROCESSOR.Name0
DescriptionSCCM.Ext.vex.GS_PROCESSOR.Name0
Microsoft.Windows.ProcessorFamilySCCM.Ext.vex.GS_PROCESSOR.Family0
MaxClockSpeedSCCM.Ext.vex.GS_PROCESSOR.MaxClockSpeed0
TypeSCCM.Ext.vex.GS_PROCESSOR.ProcessorType0
BrandIDSCCM.Ext.vex.GS_PROCESSOR.BrandID0
PCacheSCCM.Ext.vex.GS_PROCESSOR.PCache0
CPUKeySCCM.Ext.vex.GS_PROCESSOR.CPUKey0
IsMobile (bool)SCCM.Ext.vex.GS_PROCESSOR.IsMobile0
IsMultiCore (bool)SCCM.Ext.vex.GS_PROCESSOR.IsMulticore0
Microsoft.Windows.Peripherals.ProcessorManufacturerSCCM.Ext.vex.GS_PROCESSOR.Manufacturer0
SpeedSCCM.Ext.vex.GS_PROCESSOR.NormSpeed0
DataWidthSCCM.Ext.vex.GS_PROCESSOR.DataWidth0
RevisionSCCM.Ext.vex.GS_PROCESSOR.Revision0
VersionSCCM.Ext.vex.GS_PROCESSOR.Version0

Microsoft.Windows.Peripherals.NetworkAdapter

The following table describes the mappings for the Microsoft.Windows.Peripherals.NetworkAdapter type.

Service Manager typeService Manager propertyColumn name of Configuration Manager Database Views
System.EntityDisplayNameSCCM.Ext.vex_GS_NETWORK_ADAPTER.Name0
Microsoft.Windows.LogicalDeviceDeviceID [Key]SCCM.Ext.vex_GS_NETWORK_ADAPTER.DeviceID0
NameSCCM.Ext.vex_GS_NETWORK_ADAPTER.Name0
DescriptionSCCM.Ext.vex.GS_NETWORK_ADAPTER.Description0
Microsoft.Windows.NetworkAdapterBandwidthSCCM.Ext.vex.GS_NETWORK_ADAPTER.Speed0
MaxSpeed (int)SCCM.Ext.vex.GS_NETWORK_ADAPTER.MaxSpeed0
ProductNameSCCM.Ext.vex.GS_NETWORK_ADAPTER.ProductName0
DefaultIPGatewaySCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0
DHCPHostNameSCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DHCPServer
IPEnabledSCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.IPEnabled0
Microsoft.Windows.Peripherals.NetworkAdapterAdapterTypeSCCM.Ext.vex.GS_NETWORK_ADAPTER.AdapterType0
IndexSCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.Index0
ManufacturerSCCM.Ext.vex.GS_NETWORK_ADAPTER.Manufacturer0
MACAddressSCCM.Ext.vex.GS_NETWORK_ADAPTER.MACAddress0
ServiceNameSCCM.Ext.vex.GS_NETWORK_ADAPTER.ServiceName0
DHCPEnabledSCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DHCPEnabled0
DHCPServerSCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DHCPServer0
DNSDomainSCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.DNSDomain0
IPAddressSCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0
IPSubnetSCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.IPSubnet0

System.DeviceHasSoftwareItemInstalled

The following table describes the mappings for the System.DeviceHasSoftwareItemInstalled type.

Service Manager typeService Manager propertyColumn name of Configuration Manager database views
System.EntityDisplayNameSCCM.Ext.vex_GS_INSTALLED_SOFTWARE.ProductName0
System.SoftwareItemProductName [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
MajorVersionSCCM.Ext.vex_GS_INSTALLED_SOFTWARE.VersionMajor0
MinorVersionSCCM.Ext.vex_GS_INSTALLED_SOFTWARE.VersionMinor0
LocaleIDSCCM.Ext.vex_GS_INSTALLED_SOFTWARE.Language0
System.DeviceHasSoftwareItemInstalledInstalledDateSCCM.Ext.vex_GS_INSTALLED_SOFTWARE.InstalledDate0
InstalledPathSCCM.Ext.vex_GS_INSTALLED_SOFTWARE.InstalledLocation0
SerialNumberSCCM.Ext.vex_GS_INSTALLED_SOFTWARE.ProductID0
IsVirtualApplicationSCCM.Ext.Vex_GS_INSTALLED_SOFTWARE.InstallType

System.DeviceHasSoftwareUpdateInstalled

The following table describes the mappings for the System.DeviceHasSoftwareUpdateInstalled type.

Service Manager typeService Manager propertyColumn name of Configuration Manager database views
System.SoftwareUpdateVendor [Key]SCCM.Ext.vex_LocalizedCategoryInstances.CategoryInstanceName
Title [Key]SCCM.Ext.vex_LocalizedCIProperties.DisplayName
Microsoft.Windows.SoftwareUpdateArticleIDSCCM.Ext.vex_UpdateCIs.ArticleID
BulletinIDSCCM.Ext.vex_UpdateCIs.BulletinID
SupportStringSCCM.Ext.vex_LocalizedCIProperties.CIInformativeURL
ClassificationSCCM.Ext.vex_LocalizedCategoryInstances.CategoryInstanceName
System.DeviceHasSoftwareUpdateInstalledInstallStatusSCCM.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 typeService Manager propertyColumn name of Configuration Manager database views
Microsoft.SystemCenter.ConfigurationManager.DCM_CIDisplayNameSCCM.Ext.vex_LocalizedCIProperties.DisplayName
UniqueID [Key]SCCM.Ext.vex_ConfigurationItems.CI_UniqueID
DescriptionSCCM.Ext.vex_LocalizedCIProperties.Description
IsBaselineSCCM.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 typeService Manager propertyColumn name of Configuration Manager database views
Microsoft.SystemCenter.ConfigurationManager.DCM_NoncompliantCIUniqueID [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 classConfiguration Manager database valueService Manager property
System.Domain.UserDomain [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 typeService Manager propertyColumn name of Configuration Manager database views
System.ConfigItemDisplayNameSCCM_Ext.vex_Collection.CollectionName
Microsoft.SystemCenter.ConfigurationManagergr.CollectionInfCountCount of computers in collection
CollID [Key]SCCM_Ext.vex_Collection.CollID
CollectionNameSCCM_Ext.vex_Collection.CollectionName
CollectionIDSCCM_Ext.vex_Collection.CollectionID

Microsoft.ConfigMgr.SoftwarePackage

The following table describes the mapping for the Microsoft.ConfigMgr.SoftwarePackage type.

Service Manager typeService Manager propertyColumn name of Configuration Manager database views
System.ConfigItemDisplayNameSCCM_Ext.vex_Package.Name
Microsoft.ConfigMgr.SoftwarePackageID [Key]SCCM_Ext.vex_Package.PackageID
VersionSCCM_Ext.vex_Package.Version
LanguageSCCM_Ext.vex_Package.Language
ManufacturerSCCM_Ext.vex_Package.Manufacturer
DescriptionSCCM_Ext.vex_Package.Description
© 2016 Microsoft