SCRM 2006 SCRS_SoftwareUpdate_Dimension_View

SCRS_SoftwareUpdate_Dimension_View lists each software update that can be distributed by SMS.

SCRS_SoftwareUpdate_Dimension_View

Column	Type	Constraint	Description
SoftwareUpdateKey	int	Not Null	Foreign key that uniquely identifies each product in the SC_SoftwareUpdateDimension_Table.
SoftwareUpdateLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected this software update in the SMS site database.
SoftwareUpdateBinPath	nvarchar	Not Null	Download path of the update binary. If the download path is not directly available, it is the update binary name.
SoftwareUpdateDatePosted	datetime	Null values allowed	Date that the update bulletin was first released.
SoftwareUpdateDateRevised	datetime	Null values allowed	Update time of the bulletin.
SoftwareUpdateBulletinId	nvarchar	Not Null	Bulletin identifier of the software update.
SoftwareUpdateInfoPath	nvarchar	Not Null	URL where more information can be found about this software update.
SoftwareUpdateLanguage	nvarchar	Not Null	Language version associated with the software update.
SoftwareUpdateLocaleId	int	Null values allowed	Locale identifier associated with the software update.
SoftwareUpdateProduct	nvarchar	Not Null	Product to which the software update applies.
SoftwareUpdateProductId	nvarchar	Not Null	Identifier of the product to which the software update applies.
SoftwareUpdateQNumbers	nvarchar	Not Null	Applicable Knowledge Base article number associated with the software update.
SoftwareUpdateRevisionNumber	int	Null values allowed	Revision number associated with the software update.
SoftwareUpdateScanAgent	nvarchar	Not Null	Scan package name associated with the software update.
SoftwareUpdateSummary	nvarchar	Not Null	Bulletin summary that describes an update.
SoftwareUpdateTimeAuthorized	datetime	Null values allowed	Time at which the software update is authorized by the administrator.
SoftwareUpdateTitle	nvarchar	Not Null	Title of the software update.
SoftwareUpdateType	nvarchar	Not Null	Scan type—for example, MBSA or Microsoft Office.
SoftwareUpdateUnattendSyntax	nvarchar	Not Null	Unattended syntax associated with the software update.
SoftwareUpdateUniqueUpdateId	nvarchar	Not Null	Unique identifier associated with the software update.
SoftwareUpdateUpdateFormat	tinyint	Null values allowed	Update format associated with the software update.
SoftwareUpdateUpdateParameters	nvarchar	Not Null	Update parameters associated with the software update.

See Also

Other Resources

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