SCRM 2006 SCRS_SMSSite_Dimension_View
SCRS_SMSSite_Dimension_View lists information about each SMS site.
SCRS_SMSSite_Dimension_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| SMSSiteKey | int | Not Null | Foreign key that uniquely identifies each product in the SC_SMSSiteDimension_Table. |
| SiteBuildNumber | int | Null values allowed | SMS build number. |
| SiteCode | nvarchar | Not Null | Unique site code that denotes the SMS site. |
| SiteEndTimeKey | int | Null values allowed | End of the time period that this row was known to be valid. A |
| SiteEndDateKey | smallint | Null values allowed | End of the time period that this row was known to be valid. A |
| SiteEndDateLineageKey | int | Null values allowed | Key that references the DTS lineage of the package that first detected that this SMS site entry had been deleted from the SMS site database. |
| SiteStartTimeKey | int | Not Null | Start of the time period that this row was known to be valid. Indicates time that SMS first created the item. |
| SiteStartDateKey | smallint | Not Null | Start of the time period that this row was known to be valid. Indicates time that SMS first created the item. |
| SiteStartDateLineageKey | int | Not Null | Key that references the DTS lineage of the package that first detected that this SMS site entry had been inserted into SMS ODB. |
| SiteInstallDir | nvarchar | Null values allowed | Directory in which SMS was installed. |
| SiteName | nvarchar | Null values allowed | Name of the SMS site. |
| SiteReportingSiteCode | nvarchar | Null values allowed | Parent SMS site code. This value might be blank. |
| SiteServerName | nvarchar | Null values allowed | Server name of the site on which SMS is installed. |
| SiteType | int | Null values allowed | Type of site, either primary or secondary, using the following values:
|
| SMSInstallationComment | nvarchar | Null values allowed | Optional comment associated with the SMS site installation. |
| SMSInstallationContact | nvarchar | Null values allowed | Contact associated with the SMS site installation. |
| SMSInstallationName | nvarchar | Null values allowed | Installation name associated with the SMS site. |