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