SCRM 2006 SCRS_SMSSite_Dimension_View

Article
09/10/2006

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 `NULL` value indicates this row contains the current information.
SiteEndDateKey	smallint	Null values allowed	End of the time period that this row was known to be valid. A `NULL` value indicates this row contains the current information.
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: 1 Secondary 2 Primary
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.

See Also

Other Resources

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