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 NULL value indicates this row contains the current information. A date value indicates the last date that this row was known valid.
NodeEndDateKey	smallint	Null values allowed	End of the time period that this row was last known valid. A NULL value indicates this row contains the current information. A date value indicates the last date that this row was known valid.
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: 1 Other 2 Unknown 3 8086 4 80286 5 80386 6 80486 7 8087 8 80287 9 80387 10 80487 11 Pentium brand 12 Pentium Pro 13 Pentium II 14 Pentium processor with MMX technology 15 Celeron 16 Pentium II Xeon 17 Pentium III 18 M1 Family 19 M2 Family 24 K5 Family 25 K6 Family 26 K6-2 27 K6-3 28 AMD Athlon Processor Family 29 AMD Duron Processor 30 AMD2900 Family 31 K6-2+ 32 Power PC Family 33 Power PC 601 34 Power PC 603 35 Power PC 603+ 36 Power PC 604 37 Power PC 620 38 Power PC X704 39 Power PC 750 48 Alpha Family 49 Alpha 21064 50 Alpha 21066 51 Alpha 21164 52 Alpha 21164PC 53 Alpha 21164a 54 Alpha 21264 55 Alpha 21364 64 MIPS Family 65 MIPS R4000 66 MIPS R4200 67 MIPS R4400 68 MIPS R4600 69 MIPS R10000 80 SPARC Family 81 SuperSPARC 82 microSPARC II 83 microSPARC IIep 84 UltraSPARC 85 UltraSPARC II 86 UltraSPARC IIi 87 UltraSPARC III 88 UltraSPARC IIIi 96 68040 97 68xxx Family 98 68000 99 68010 100 68020 101 68030 112 Hobbit Family 120 Crusoe TM5000 Family 121 Crusoe TM3000 Family 128 Weitek 130 Itanium Processor 144 PA-RISC Family 145 PA-RISC 8500 146 PA-RISC 8000 147 PA-RISC 7300LC 148 PA-RISC 7200 149 PA-RISC 7100LC 150 PA-RISC 7100 160 V30 Family 176 Pentium III Xeon 177 Pentium III Processor with Intel SpeedStep Technology 178 Pentium 4 179 Intel Xeon 180 AS400 Family 181 Intel Xeon processor MP 182 AMD AthlonXP Family 183 AMD AthlonMP Family 184 Intel Itanium 2 185 AMD Opteron Family 190 K7 200 IBM390 Family 201 G4 202 G5 250 i860 251 i960 260 SH-3 261 SH-4 280 ARM 281 StrongARM 300 6x86 301 MediaGX 302 MII 320 WinChip 350 DSP 500 Video Processor
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: 1 Other 2 Unknown 3 Central Processor 4 Math Processor 5 DSP Processor 6 Video Processor
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, 4.0.
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, Microsoft Windows XP Professional Version = 5.1.2500.
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, 1 (United States).
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, Service Pack 3.
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: 0 or 1=Computer 2=Device
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: 0 Standalone Workstation 1 Member Workstation 2 Standalone Server 3 Member Server 4 Backup Domain Controller 5 Primary Domain Controller
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: X86-based PC MIPS-based PC Alpha-based PC Power PC SH-x PC StrongARM PC 64-bit Intel PC 64-bit Alpha PC Unknown X86-Nec98 PC Virtual
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.

See Also

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures