SCRM 2006 SC_NodeModem_OUTRIGGER_View

2006-09-10

SC_NodeModem_OUTRIGGER_View lists hardware inventory for the modems on a managed node.

SC_NodeModem_OUTRIGGER_View

Column	Type	Constraint	Description
NodeModemKey	int	Not Null	Key that uniquely identifies a modem 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.
ModemEndTimeKey	int	Null values allowed	End of the time period that this row was known valid. A `NULL` value indicates this row contains the current information.
ModemEndDateKey	smallint	Null values allowed	End of the time period that this row was known valid. A `NULL` value indicates this row contains the current information.
ModemEndDateLineageKey	int	Null values allowed	Key that identifies lineage of the DTS package that last identified this entry. A current entry has a `NULL` end date and time and `NULL` lineage end date. This is a foreign key into SC_LineageDimension_Table.
ModemStartTimeKey	int	Not Null	Start of the time period that this row was known valid. Indicates the date that the item was first inventoried by SMS.
ModemStartDateKey	smallint	Not Null	Start of the time period that this row was known valid. Indicates the date that the item was first inventoried by SMS.
ModemStartDateLineageKey	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.
ModemAnswerMode	nvarchar	Null values allowed	Current auto-answer/call-back setting for the modem, using the following values: 1 Unknown 2 Other 3 Disabled 4 Manual Answer 5 Auto Answer 6 Auto Answer with Call-Back
ModemDeviceType	nvarchar	Null values allowed	Physical type of the modem, using the following values: Null Modem Internal Modem External Modem PCMCIA Modem Unknown
ModemMaxBaudRateToPhone	int	Null values allowed	Maximum settable communication speed for accessing the phone system, in bits per second.
ModemMaxBaudRateToSerialPort	int	Null values allowed	Maximum settable communication speed to the COM port for an external modem, in bits per second.
ModemModel	nvarchar	Null values allowed	Model of this POTS modem. For example, `Sportster 56K External`.
ModemProperties	nvarchar	Null values allowed	List of all the properties, and their values, for this modem.
ModemStringFormat	nvarchar	Null values allowed	Key that identifies the type of characters used for text passing through the modem, using the following values: ASCII string format DBCS string format UNICODE string format
ModemVoiceSwitchFeature	nvarchar	Null values allowed	Command string used to activate the voice capabilities of a voice modem. For example, `AT+V`.

See Also

Other Resources

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