SCRM 2006 SCRS_SoftwareDistribution_Fact_View

SCRS_SoftwareDistribution_Fact_View describes what software is targeted and the nodes to which the software is distributed.

SCRS_SoftwareDistribution_Fact_View

Column	Type	Constraint	Description
AdvertisementKey	int	Not Null	Foreign key that references a unique advertisement in the Advertisement dimension.
AdvertisementStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that the advertisement was first inventoried by SMS.
AdvertisementStartDateKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that the advertisement was first inventoried by SMS.
AdvertisementStartDateTime	datetime	Not Null	Start of the time period that this row was known to be valid. Indicates date and time that the advertisement was first inventoried by SMS.
AdvertisementStartDateLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this advertisement entry had been inserted into SMS site database.
AdvertisementEndTimeKey	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.
AdvertisementEndDateKey	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 date that this row was known to be valid.
AdvertisementEndDateTime	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.
AdvertisementEndDateLineageKey	int	Null values allowed	Key that references the DTS lineage of the package that first detected that this advertisement entry no longer existed in the SMS site database.
AdvertisementStatusTimeKey	int	Not Null	Foreign key that references a particular time interval from Time dimension indicating the time of the day at which the last status of the advertisement was received.
AdvertisementStatusDateKey	int	Not Null	Foreign key that references a particular date from Date dimension indicating the day on which the last status of the advertisement was received.
AdvertisementActive	int	Null values allowed	Indicator for whether an advertisement is actively targeting the node.
LocationKey	int	Null values allowed	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.
PackageKey	int	Not Null	Foreign key that references a unique package in the Package dimension.
CollectionKey	int	Not Null	Foreign key that references a unique managed node in the Collection dimension.
SMSSiteKey	int	Not Null	Foreign key that references a unique SMS site in the SMS Site dimension.
UserKey	int	Not Null	Foreign key that references a unique user in the User dimension.
AdvertisementStatusKey	int	Not Null	Foreign key that references a particular Status Message Record from the Status Message dimension indicating the received status message for the advertisement.
AdvertisementExecutionResult	nvarchar	Null values allowed	Indicates the last execution result of Advertisement Installation.

See Also

Other Resources

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