SCRM 2006 SC_ServiceInstallation_FACT_View

2006-09-10

SC_ServiceInstallation_FACT_View describes which services have been installed on managed nodes in an enterprise.

SC_ServiceInstallation_FACT_View

Column	Type	Constraint	Description
ServiceInstallationEndTimeKey	int	Null values allowed	End of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A non-`NULL` value indicates the last time that this row was known to be valid.
ServiceInstallationEndDateKey	smallint	Null values allowed	End of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A non-`NULL` value indicates the last date that this row was known to be valid.
ServiceInstallationEndDateTime	datetime	Null values allowed	End of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A date value indicates the last date and time that this row was known to be valid.
ServiceInstallationEndDateLineageKey	int	Null values allowed	References the DTS lineage of the package that first detected that this service installation entry no longer existed in the SMS site database.
ServiceInstallationStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that the service was first inventoried by SMS.
ServiceInstallationStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates time that the service was first inventoried by SMS.
ServiceInstallationStartDateTime	datetime	Null values allowed	Start of the time period that this row was known to be valid. Indicates date and time that the service was first inventoried by SMS.
ServiceInstallationStartDateLineageKey	int	Not Null	References the DTS lineage of the package that first detected that this service installation entry had been inserted into SMS site database.
LocationKey	int	Not Null	Foreign key that references a unique node location in the Node Location dimension.
NodeKey	int	Not Null	Foreign key that references a unique managed node in the Managed Node dimension.
ServiceKey	int	Not Null	Foreign key that references a unique service in the Service dimension.
SMSSiteKey	int	Not Null	Foreign key that references a unique SMS site in the SMS Site dimension.

See Also

Other Resources

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