SCRM 2006 SCRS_ManagedNode_Dimension_View
SCRS_ManagedNode_Dimension_View lists all information about SMS managed computers.
SCRS_ManagedNode_Dimension_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| NodeKey | int | Not Null | Key that uniquely identifies a given managed node. |
| NodeEndTimeKey | int | Null values allowed | End of the time period that this row was last known valid. A |
| NodeEndDateKey | smallint | Null values allowed | End of the time period that this row was last known valid. A |
| NodeEndDateLineageKey | int | Null values allowed | References the DTS lineage of the package that first detected that this managed node no longer exists in the SMS site database. |
| NodeStartTimeKey | int | Not Null | Start of the time period that this row was known to be valid. Indicates the time when the item was first inventoried by SMS. |
| NodeStartDateKey | smallint | Not Null | Start of the time period that this row was known valid. Indicates the time when the item was first inventoried by SMS. |
| NodeStartDateLineageKey | int | Not Null | References the DTS lineage of the package that first detected that this managed node exists in the SMS site database. |
| ComputerType | nvarchar | Not Null | Computer type associated with the managed node. |
| ComputerName | nvarchar | Not Null | Name of computer, without a domain name. |
| ComputerNTDomainName | nvarchar | Null values allowed | The Windows NT-style domain name. |
| ComputerFullNTName | nvarchar | Null values allowed | The Windows NT-style fully qualified machine name. |
| ComputerDNSDomainName | nvarchar | Null values allowed | DNS-style domain name associated with the machine. |
| ComputerFullDNSName | nvarchar | Null values allowed | The DNS-style fully qualified machine name. |
| CPUFamily | int | Null values allowed | Processor family type using the following values:
|
| CPUManufacturer | nvarchar | Null values allowed | Name of the processor manufacturer. |
| CPUMaxClockSpeed | int | Null values allowed | Maximum speed of the processor in MHz. |
| CPUName | nvarchar | Null values allowed | Name of the processor. |
| CPUProcessorType | int | Null values allowed | Primary function of the processor, using the following values:
|
| CPURevision | int | Null values allowed | System revision level, which depends on the processor architecture. |
| CPUVersion | nvarchar | Null values allowed | Processor revision number, which depends on the architecture. For example, Model 2, Stepping 12. |
| BIOSManufacturer | nvarchar | Null values allowed | Name of the BIOS manufacturer. |
| BIOSName | nvarchar | Null values allowed | Name of the Windows BIOS. |
| BIOSReleaseDate | datetime | Null values allowed | Release date of the Windows BIOS. |
| BIOSSerialNumber | nvarchar | Null values allowed | Serial number of the Windows BIOS. |
| BIOSSMBIOSVersion | nvarchar | Null values allowed | BIOS version as reported by SMBIOS. This is not collected by SMS by default. |
| BIOSVersion | nvarchar | Null values allowed | The BIOS version description. |
| CustomerAsset | nvarchar | Null values allowed | Customer-defined asset information. |
| CustomerDescription | nvarchar | Null values allowed | Optional customer-defined description of this computer. |
| EnclosureSMBIOSAssetTag | nvarchar | Null values allowed | Asset tag number of the system enclosure. |
| KeyboardDescription | nvarchar | Null values allowed | Textual description of the keyboard. |
| KeyboardLayout | nvarchar | Null values allowed | Textual description of the keyboard layout. |
| KeyboardName | nvarchar | Null values allowed | Textual name of the keyboard. |
| MemoryTotalPhysicalMemory | bigint | Null values allowed | Total amount of physical memory reported to the operating system as available to it. This value does not necessarily indicate the true amount of physical memory. |
| MemoryTotalStoredInPageFile | bigint | Null values allowed | Total amount of data that can be stored in the operating system paging files; for example, 0 (zero) indicates that there are no paging files. This number does not represent the actual physical size of the paging file on disk. |
| MemoryTotalVirtualMemory | bigint | Null values allowed | Total amount of virtual memory. |
| MOMComputerType | int | Null values allowed | The name of the operating system manufacturer. |
| MOMAgent | int | Null values allowed | Version number of the operating system; for example, |
| MOMCollector | int | Null values allowed | Indicates whether the client is a virtual PC. |
| MOMDescription | nvarchar | Null values allowed | Indicates the Computer Type, as identified by MOM Agent on the client computer. |
| MOMLastContact | datetime | Null values allowed | Indicates whether the client is a MOM Agent. |
| MOMSMCInstanceId | bigint | Null values allowed | Indicates whether the client is a MOM Collector. |
| MotherboardPrimaryBusType | nvarchar | Null values allowed | Type of the primary motherboard bus. |
| MotherboardRevisionNumber | nvarchar | Null values allowed | Motherboard revision number. |
| MotherboardSecondaryBusType | nvarchar | Null values allowed | Motherboard secondary bus type. |
| OSBuildNumber | nvarchar | Null values allowed | The operating system build number. |
| OSCaption | nvarchar | Null values allowed | Short description of the operating system. The string includes the operating system version. For example, |
| OSCountryCode | nvarchar | Null values allowed | Code for the country/region that an operating system uses. Values are based on international phone dialing prefixes, which are also referred to as IBM country/region codes. The property can store up to six characters to define the country/region code value. For example, |
| OSServicePackVersion | nvarchar | Null values allowed | Indicates the latest service pack installed on a computer system. If no service pack is installed, the string is NULL. For example, |
| OSDescription | nvarchar | Null values allowed | Description of the Windows operating system. |
| OSInstallDate | datetime | Null values allowed | The date the operating system was installed on this node. |
| OSLanguage | int | Null values allowed | Language version of the operating system installed. |
| OSLastBootUpTime | datetime | Null values allowed | Operating system last start date and time. |
| OSLocale | nvarchar | Null values allowed | Language identifier used by the operating system. A language identifier is a standard international numeric abbreviation for a country/region. Each language has a unique language identifier (LANGID), a 16-bit value that consists of a primary language identifier and a secondary language identifier. |
| OSManufacturer | nvarchar | Null values allowed | Indicates the MOM Computer Description. |
| OSVersion | nvarchar | Null values allowed | Indicates the date of the last heartbeat for the MOM Agent. |
| OSWindowsDirectory | nvarchar | Null values allowed | Windows directory of the operating system. |
| PointingDeviceType | nvarchar | Null values allowed | Type of hardware used as pointing device. |
| SMSClientType | tinyint | Null values allowed | SMS client type:
|
| SMSClientVersion | nvarchar | Null values allowed | Version number of the SMS client installed on the computer. |
| SMSADSiteName | nvarchar | Null values allowed | Name of the Active Directory site where a computer resides. |
| SMSUniqueIdentifier | nvarchar | Null values allowed | Unique identifier used by SMS to identify a managed computer. |
| SystemDomainRole | int | Null values allowed | A SystemDomainRole property might show that a computer is a member workstation. It uses the following values:
|
| SystemManufacturer | nvarchar | Null values allowed | Name of the computer manufacturer. |
| SystemModel | nvarchar | Null values allowed | Product name that a manufacturer gives to a computer. |
| SystemNumberOfProcessors | int | Null values allowed | Number of enabled processors currently available on the computer system. |
| SystemType | nvarchar | Null values allowed | Operating system running on the Windows computer, using the following values:
|
| Virtual | int | Null values allowed | Virtual or physical computer. 1 - Virtual. Any other value - physical. |
| VirtualHostName | nvarchar | Null values allowed | Virtual machine host name, if this is a virtual machine client. |
| WorkstationLastHardwareScanDate | datetime | Null values allowed | Last time the inventory agent scanned the managed node. |
| WorkstationLastSoftwareScanDate | datetime | Null values allowed | Last time the software inventory agent scanned the managed node. |
| WorkstationLastHeartbeatDate | datetime | Null values allowed | Last time discovery data was reported by the managed node. |