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 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