Condividi tramite


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