SCRM 2006 SCRS_NodeMonitor_OUTRIGGER_View

SCRS_NodeMonitor_OUTRIGGER_View lists hardware inventory for the video monitors on a managed node.

SCRS_NodeMonitor_OUTRIGGER_View

Column	Type	Constraint	Description
NodeMonitorKey	int	Not Null	Key that uniquely identifies a monitor associated with the managed node referenced by NodeKey.
NodeKey	int	Not Null	Key that identifies the managed node associated with this entry. This is a foreign key into SC_ManagedNodeDimension_Table.
MonitorEndTimeKey	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.
MonitorEndDateKey	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.
MonitorEndDateLineageKey	int	Null values allowed	Key that 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.
MonitorStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates date that item was first inventoried by SMS.
MonitorStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates date that item was first inventoried by SMS.
MonitorStartDateLineageKey	int	Not Null	Key that identifies lineage of the DTS package that first identified this entry. This is a foreign key into SC_LineageDimension_Table.
MonitorDisplayType	int	Null values allowed	Type of desktop monitor or CRT, using the following values: 0 Unknown 1 Other 2 Multiscan Color 3 Multiscan Monochrome 4 Fixed Frequency Color 5 Fixed Frequency Monochrome
MonitorManufacturer	nvarchar	Not Null	Name of the monitor manufacturer.
MonitorPixelsPerXLogicalInch	smallint	Null values allowed	Resolution along the category (x) axis (horizontal direction) of the monitor in pixels per logical inch.
MonitorPixelsPerYLogicalInch	smallint	Null values allowed	Resolution along the value (y) axis (vertical direction) of the monitor in pixels per logical inch.
MonitorScreenHeight	smallint	Null values allowed	Logical height of the display in screen coordinates.
MonitorScreenWidth	smallint	Null values allowed	Logical width of the display in screen coordinates.
MonitorType	nvarchar	Not Null	Type of monitor—for example, NEC 5FGp.

See Also

Other Resources

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