SCRM 2006 SCRS_SoftwareUpdate_Fact_View

SCRS_SoftwareUpdate_Fact_View lists software update applicability and distribution.

SCRS_SoftwareUpdate_Fact_View

Column	Type	Constraint	Description
SoftwareUpdateEndTimeKey	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.
SoftwareUpdateEndDateKey	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.
SoftwareUpdateEndDateTime	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.
SoftwareUpdateEndDateLineageKey	int	Null values allowed	Key that references the DTS lineage of the package that first detected that this software update no longer appeared in the SMS site database.
SoftwareUpdateStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that this software update was first inventoried by SMS.
SoftwareUpdateStartDateKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that this software update was first inventoried by SMS.
SoftwareUpdateStartDateTime	datetime	Not Null	Start of the time period that this row was known to be valid. Indicates date and time that this software update was first inventoried by SMS.
SoftwareUpdateStartDateLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this software update entry when it first appeared in the SMS site database.
SoftwareUpdateSMSInstallTimeKey	int	Null values allowed	Key that indicates the time of installation of this software update.
SoftwareUpdateSMSInstallDateKey	int	Null values allowed	Key that indicates date of installation of this software update.
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.
SoftwareUpdateApplicable	int	Not Null	Key that indicates whether an update is applicable to this node.
SMSSiteKey	int	Not Null	Foreign key that references a unique SMS site in the SMS Site dimension.
SoftwareUpdateKey	int	Not Null	Foreign key that references a unique Software Update Record in the Software Update dimension.
UserKey	int	Not Null	Foreign key that references a unique user in the User dimension.
SoftwareUpdateStatusTimeKey	int	Null values allowed	Foreign key that references a particular time interval from the Time dimension indicating the time of the day at which the last status of the software update was received.
SoftwareUpdateStatusDateKey	int	Null values allowed	Foreign key that references a particular date from the Date dimension indicating the day on which the last status of the software update was received.
SoftwareUpdateStatusKey	int	Not Null	Foreign key that references a particular Status Message Record from the Status Message dimension indicating the received status message for the software update.
SoftwareUpdateInstallationMethod	int	Null values allowed	Indicator for the installation method for the software update.
SoftwareUpdateDate	datetime	Null values allowed	Indicator for the date on which the software update was installed.

See Also

Other Resources

SCRM 2006 SMS Views
SCRM 2006 MOM Views