Apéndice C - asignación de System Center 2012 - Service Manager propiedades a vistas de base de datos del Administrador de configuración
Se aplica a: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager
La característica de inventario de hardware de Configuration Manager recopila información acerca de los equipos de la organización. En Service Manager puede utilizar un conector de Configuration Manager para importar los datos de inventario de hardware de Configuration Manager. Las tablas de este apéndice describen la asignación entre Service Manager Propiedades y los nombres de columna de Configuration Manager 2007 en vistas de base de datos.
Microsoft.SystemCenter.ConfigurationManager.DeployedComputer
La tabla siguiente describe la asignación de la Microsoft.SystemCenter.ConfigurationManager.DeployedComputer tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| 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 | |
| Fabricante | SCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.Manufacturer0 | |
| Modelo | 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 | Si SCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.SerialNumber0 es NULL, '00000000' o 'Not Available', entonces SCCM.Ext.vex_GS_PC_BIOS.SerialNumber0; de lo contrario, SCCM.Ext.vex_GS_SYSTEM_ENCLOSURE.SerialNumber0 |
Microsoft.Windows.Computer
La tabla siguiente describen las asignaciones para el Microsoft.Windows.Computer tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0 |
| Microsoft.Windows.Computer | PrincipalName (FQDN) [Key] | Se crea con SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0 o SCCM.Ext.vex_R_System.Netbios_Name0 y SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Domain0 o SCCM.Ext.vex_R_System.Resource_Domain_OR_Workgr0. Si SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Name0 es null, se utiliza SCCM.Ext.vex_R_System.Netbios_Name0 como nombre. Si SCCM.Ext.vex_GS_COMPUTER_SYSTEM.Domain0 es null, se utiliza SCCM.Ext.vex_R_System.Resource_Domain_OR_Workgr0 como dominio. |
| 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, es decir, Model0 = "Virtual Machine" o "VMware Virtual Platform", o bien, Manufacturer="Microsoft Corporation" o "VMware, Inc" | |
| ActiveDirectorySite | SCCM.Ext.vex_R_System.AD_Site_Name0 | |
| LastInventoryDate | SCCM.Ext.Vex_GS_Workstation_Status.LastHWScan |
Microsoft.Windows.OperatingSystem
La tabla siguiente describen las asignaciones para el Microsoft.Windows.OperatingSystem tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| 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 | |
| Configuración regional | SCCM.Ext.vex_GS_OPERATING_SYSTEM.Locale0 | |
| Fabricante | 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
La tabla siguiente describen las asignaciones para el Microsoft.Windows.Peripherals.LogicalDisk tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_LOGICAL_DISK.Name0 |
| Microsoft.Windows.LogicalDevice | DeviceID [Key] | SCCM.Ext.vex_GS_LOGICAL_DISK.DeviceID0 |
| Nombre | SCCM.Ext.vex_GS_LOGICAL_DISK.Name0 | |
| Descripción | 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 |
| Comprimido | SCCM.Ext.vex_GS_LOGICAL_DISK.Compressed0 | |
| Tamaño | 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
La tabla siguiente describen las asignaciones para el Microsoft.Windows.Peripherals.PhysicalDisk tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_DISK.Name0 |
| Microsoft.Windows.LogicalDevice | DeviceID [Key] | SCCM.Ext.vex_GS_DISK.DeviceID0 |
| Nombre | SCCM.Ext.vex_GS_DISK.Name0 | |
| Descripción | 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 |
| Índice | SCCM.Ext.vex.GS_DISK.Index0 | |
| InterfaceType | SCCM.Ext.vex.GS_DISK.InterfaceType0 | |
| Fabricante | SCCM.Ext.vex.GS_DISK.Manufacturer0 | |
| Modelo | 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 | |
| Tamaño | 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
La tabla siguiente describen las asignaciones para el Microsoft.Windows.Peripherals.Processor tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_PROCESSOR.Name0 |
| Microsoft.Windows.LogicalDevice | DeviceID [Key] | SCCM.Ext.vex_GS_PROCESSOR.DeviceID0 |
| Nombre | SCCM.Ext.vex_GS_PROCESSOR.Name0 | |
| Descripción | SCCM.Ext.vex.GS_PROCESSOR.Name0 | |
| Microsoft.Windows.Processor | Familia | SCCM.Ext.vex.GS_PROCESSOR.Family0 |
| MaxClockSpeed | SCCM.Ext.vex.GS_PROCESSOR.MaxClockSpeed0 | |
| Tipo | 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 | Fabricante | SCCM.Ext.vex.GS_PROCESSOR.Manufacturer0 |
| Velocidad | SCCM.Ext.vex.GS_PROCESSOR.NormSpeed0 | |
| DataWidth | SCCM.Ext.vex.GS_PROCESSOR.DataWidth0 | |
| Revisión | SCCM.Ext.vex.GS_PROCESSOR.Revision0 | |
| Versión | SCCM.Ext.vex.GS_PROCESSOR.Version0 |
Microsoft.Windows.Peripherals.NetworkAdapter
La tabla siguiente describen las asignaciones para el Microsoft.Windows.Peripherals.NetworkAdapter tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| System.Entity | DisplayName | SCCM.Ext.vex_GS_NETWORK_ADAPTER.Name0 |
| Microsoft.Windows.LogicalDevice | DeviceID [Key] | SCCM.Ext.vex_GS_NETWORK_ADAPTER.DeviceID0 |
| Nombre | SCCM.Ext.vex_GS_NETWORK_ADAPTER.Name0 | |
| Descripción | SCCM.Ext.vex.GS_NETWORK_ADAPTER.Description0 | |
| Microsoft.Windows.NetworkAdapter | Ancho de banda | 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 |
| Índice | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.Index0 | |
| Fabricante | 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 | |
| Dirección IP | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0 | |
| IPSubnet | SCCM.Ext.vex.GS_NETWORK_ADAPTER_CONFIGUR.IPSubnet0 |
System.DeviceHasSoftwareItemInstalled
La tabla siguiente describen las asignaciones para el System.DeviceHasSoftwareItemInstalled tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| 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
La tabla siguiente describen las asignaciones para el System.DeviceHasSoftwareUpdateInstalled tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| 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 | |
| Clasificación | SCCM.Ext.vex_LocalizedCategoryInstances.CategoryInstanceName | |
| System.DeviceHasSoftwareUpdateInstalled | InstallStatus | SCCM.Ext.vex_UpdateComplianceStatus.Status |
Microsoft.SystemCenter.ConfigurationManager.DCM_CI
La tabla siguiente describen las asignaciones para el Microsoft.SystemCenter.ConfigurationManager.DCM_CI tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| Microsoft.SystemCenter.ConfigurationManager.DCM_CI | DisplayName | SCCM.Ext.vex_LocalizedCIProperties.DisplayName |
| UniqueID [Key] | SCCM.Ext.vex_ConfigurationItems.CI_UniqueID | |
| Descripción | SCCM.Ext.vex_LocalizedCIProperties.Description | |
| IsBaseline | SCCM.Ext.vex_ConfigurationItems.CIType_ID |
Microsoft.SystemCenter.ConfigurationManager.DCM_NoncompliantCI
La tabla siguiente describen las asignaciones para el Microsoft.SystemCenter.ConfigurationManager.DCM_NoncompliantCI tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| 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
La tabla siguiente describen las asignaciones para el System.Domain.User tipo.
| Clase de Configuration Manager | Valor de la base de datos de Configuration Manager | Propiedad de Service Manager |
|---|---|---|
| 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
La tabla siguiente describe la asignación de la Microsoft.SystemCenter.ConfigurationManagergr.CollectionInf tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| System.ConfigItem | DisplayName | SCCM_Ext.vex_Collection.CollectionName |
| Microsoft.SystemCenter.ConfigurationManagergr.CollectionInf | Número | Número de equipos en la colección |
| CollID [Key] | SCCM_Ext.vex_Collection.CollID | |
| CollectionName | SCCM_Ext.vex_Collection.CollectionName | |
| CollectionID | SCCM_Ext.vex_Collection.CollectionID |
Microsoft.ConfigMgr.SoftwarePackage
La tabla siguiente describe la asignación de la Microsoft.ConfigMgr.SoftwarePackage tipo.
| Tipo de Service Manager | Propiedad de Service Manager | Nombre de columna de las vistas de base de datos de Configuration Manager |
|---|---|---|
| System.ConfigItem | DisplayName | SCCM_Ext.vex_Package.Name |
| Microsoft.ConfigMgr.SoftwarePackage | ID [Key] | SCCM_Ext.vex_Package.PackageID |
| Versión | SCCM_Ext.vex_Package.Version | |
| Lenguajes | SCCM_Ext.vex_Package.Language | |
| Fabricante | SCCM_Ext.vex_Package.Manufacturer | |
| Descripción | SCCM_Ext.vex_Package.Description |