Share via


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