Software Update View Reference
There is no official Software Update View classification, but because several views contain information directly related to software updates, they have been grouped together and will be referred to as the report views.
Software Update Views
The software update views contain information such as the resource ID for all systems where updates are applicable, update ID, article numbers associated with the update, path to more information for the update, update scanner name, and so forth. Most of the views in this category are also listed in the Inventory View Reference section because they contain hardware inventory information, but are relevant for the software update views section as well. These views will most likely be joined with other views by using the ResourceID column. The UpdateID, QNumbers, or ID columns will likely be used for the remaining views in this section. The software update views are listed and described in the following table.
Software Update View |
Description |
|---|---|
v_GS_PATCHSTATE |
Lists all software updates that are, or have been, applicable to each resource. The view contains the resource ID, update source path, patch ID, associated article number, date posted, what product the patch updates, scan agent used, status, time applied, and so forth. The view can be joined to other views by using the ResourceID, GroupID, ID0, or QNumbers0 columns. |
v_GS_PATCHSTATEEX |
Lists everything from v_GS_PATCHSTATE as well as product ID, revision number, and update ID. The view can be joined to other views by using the ResourceID, GroupID, ID0, QNumbers0, ProductID0, or UpdateID0 columns. |
v_GS_PatchStatus |
Lists all software updates that are, or have been, applicable to each resource. The view contains the resource ID, patch ID, patch title, associated article number, what product the patch updates, language, last status for installation, and so forth. The view can be joined to other views by using the ResourceID, ID, or QNumbers columns. |
v_GS_PatchStatusEx |
Lists everything from v_GS_PatchStatus as well as product ID and update ID. The view can be joined to other views by using the ResourceID, ID, QNumbers, ProductID, or UniqueUpdateID columns. |
v_GS_SCANPACKAGEVERSION |
Lists the software updates scan tools installed on resources by scan type, resource ID, group ID, revision ID, package ID, package version, time of last update, and so forth. The view can be joined to other views by using the ResourceID or PackageID0 columns. |
v_UpdateBundles |
Lists bundled updates by bundle ID and component ID. The view can be joined to other views by using the BundleID or ComponentID columns. |
v_UpdatePrograms |
Lists the programs for all software updates. The view lists the update ID, package ID, program name, package type, and package version. The view can be joined to other views by using the UpdateID, PackageID, or ProgramName columns. |
v_UpdateRelations |
Lists software updates that are related to another software update. The view contains the update ID, relation to another update, and the related update's ID. The view can be joined to other views by using the UpdateID or RelatedUpdateID columns. |