SCRM 2006 SCRS_ComputerDimension_View

SCRS_ComputerDimension_View lists computers, including MOM servers, clients with MOM agents, clients without MOM agents, and any other computer that serves as a source for events or alerts.

SCRS_ComputerDimension_View

Column	Type	Constraint	Description
ComputerDomain_PK	nvarchar(100)	Not Null	The computer's domain name.
ComputerID	uniqueidentifier	Not Null	A GUID identifying the computer.
ComputerName_PK	nvarchar(255)	Not Null	The name of the computer.
ComputerType	int	Not Null	The type of the computer. The following values are used: 0 — Unknown 1 — Windows NT Workstation 8 — Primary domain controller 16 — Backup domain controller 8192 — Non-Windows computer groups 32768 — Windows NT member servers 32793 — All Windows computers
DateTimeLastContacted	datetime	Null values allowed	The date and time the computer last contacted MOM.
Description	nvarchar(255)	Null values allowed	The description of the computer.
DNSName	nvarchar(512)	Null values allowed	If applicable, the computer's DNS name.
FullComputerName	nvarchar(512)	Null values allowed	The full name, including the domain name and computer name.
IsAgent	bit	Not Null	The flag indicating whether the computer is functioning as a MOM agent.
IsCollector	bit	Not Null	The flag indicating whether the computer is functioning as a MOM Consolidator.
SMC_InstanceID	bigint	Not Null	The surrogate key for this item.

See Also

Reference

SCRM 2006 SCRS_AlertFact_View
SCRM 2006 SC_ComputerRuleToProcessRuleGroupFact_View
SCRM 2006 SC_ComputerToComputerRuleFact_View
SCRM 2006 SC_EventFact_View
SCRM 2006 SC_SampledNumericDataFact_View

Other Resources

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