SCRM 2006 SCRS_NodeVideoController_OUTRIGGER_View

SCRS_NodeVideoController_OUTRIGGER_View lists hardware inventory for the video cards on a managed node.

SCRS_NodeVideoController_OUTRIGGER_View

Column Type Constraint Description

NodeVideoControllerKey

int

Not Null

Uniquely identifies a video controller associated with the managed node referenced by NodeKey.

NodeKey

int

Not Null

Identifies the managed node associated with this entry. This is a foreign key into SC_ManagedNodeDimension_Table.

VideoControllerEndTimeKey

int

Null values allowed

End of the time period that this row was known to be valid. A NULL value indicates this row contains the current information.

VideoControllerEndDateKey

smallint

Null values allowed

End of the time period that this row was known to be valid. A NULL value indicates this row contains the current information.

VideoControllerEndDateLineageKey

int

Not Null

Identifies lineage of the DTS package that last identified this entry. A current entry will have a NULL end date/time and NULL lineage end date. This is a foreign key into SC_LineageDimension_Table.

VideoControllerStartTimeKey

int

Not Null

Start of the time period that this row was known to be valid. Indicates date when item was first inventoried by SMS.

VideoControllerStartDateKey

smallint

Not Null

Start of the time period that this row was known to be valid. Indicates date when item was first inventoried by SMS.

VideoControllerStartDateLineageKey

int

Not Null

Identifies lineage of the DTS package that first identified this entry. This is a foreign key into SC_LineageDimension_Table.

VideoControllerAdapterCompatibility

nvarchar

Not Null

Array of graphics and three-dimensional (3-D) capabilities of the video controller. This property is inherited from CIM_VideoController.

VideoControllerAdapterDACType

nvarchar

Not Null

Name or identifier of the digital-to-analog converter (DAC) chip. The character set of this property is alphanumeric.

VideoControllerAdapterRAM

int

Null values allowed

Memory size of the video adapter; for example, 64000.

VideoControllerCurrentBitsPerPixel

int

Null values allowed

Number of bits used to display each pixel.

VideoControllerCurrentHorizontalResolution

int

Null values allowed

Current number of horizontal pixels.

VideoControllerCurrentNumberOfColors

nvarchar

Not Null

Number of colors supported at the current resolution.

VideoControllerCurrentRefreshRate

int

Null values allowed

Frequency at which the video controller refreshes the image for the monitor. A value of 0 indicates the default rate is being used, while 0xFFFFFFFF indicates the optimal rate is being used.

VideoControllerCurrentScanMode

int

Null values allowed

Current scan mode, using the following values:

  • 1 Other
  • 2 Unknown
  • 3 Interlaced
  • 4 Non-Interlaced

VideoControllerCurrentVerticalResolution

int

Null values allowed

Current number of vertical pixels.

VideoControllerDeviceSpecificPens

int

Null values allowed

Current number of device-specific pens. A value of 0xffff means that the device does not support pens.

VideoControllerDriverDate

datetime

Null values allowed

Last modification date and time of the currently installed video driver.

VideoControllerDriverVersion

nvarchar

Null values allowed

Version number of the video driver.

VideoControllerInstalledDisplayDrivers

nvarchar

Not Null

Name of the installed display device driver.

VideoControllerVerticalResolution

int

Null values allowed

Vertical resolution of the video controller.

VideoControllerMode

int

Null values allowed

Current video mode.

VideoControllerModeDescription

nvarchar

Not Null

Current resolution, color, and scan mode settings of the video controller. For example, 1024 x 768 x 256 colors.

VideoControllerName

nvarchar

Not Null

Name of the video controller.

VideoControllerNumberOfColorPlanes

int

Null values allowed

Current number of color planes.

VideoControllerProcessor

nvarchar

Not Null

Freeform string describing the video processor.

VideoControllerSpecificationVersion

int

Null values allowed

Version number of the initialization data specification on which the structure is based.

VideoControllerEndDateLineageKey

int

Null values allowed

Key that identifies lineage of the DTS package that first identified this entry.

VideoEndDateTime

datetime

Not Null

End of the time period that this row was known to be valid. A NULL value indicates this row contains the current information.

VideoStartDateTime

datetime

Not Null

Start of the time period that this row was known to be valid. Indicates date that item was first inventoried by SMS.

See Also

Other Resources

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