Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies To: System Center Service Manager 2010 SP1
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 display the mapping between Service Manager properties and column names of Configuration Manager 2007 database views.
The following table describes the mapping for 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to scsmdocs@microsoft.com.