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