SCRM 2006 SC_ServiceInstallation_FACT_View
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 |
| ServiceInstallationEndDateKey | smallint | Null values allowed | End of the time period that this row was valid. A |
| ServiceInstallationEndDateTime | datetime | Null values allowed | End of the time period that this row was valid. A |
| 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. |