View name:v_wus_upd_revision

Name	Type	Description
nRevisionID	paramInt	Revision database ID
strUpdateID	paramString	Global Microsoft Windows update ID. ANSI symbols.
nRevisionNumber	paramInt	Update revision number
nUpdateType	paramInt	Update type, see Software update type enum
nCategoryType	paramInt	Microsoft software update category type, see Software update category type enum
nUpdateClassification	paramInt	Microsoft software update classification, see Software update classification enum
strParentCategoryID	paramInt	Update identity ("strUpdateID") of the parent category (e.g., identity of "product family" category for a "product" category, or "company" for "product family")
wstrTitle	paramString	Title
wstrDescr	paramString	Description
tmCreationDate	paramDateTime	Revision release time
tmRegistrationDate	paramDateTime	Revision registration (in KSC database) time
bExpired	paramBool	Is the revision expired or not
imgXml	paramBinary	Update metadata BLOB (according to the [MS-WSUSSS] protocol)
bExplicitlyDeployable	paramBool	Is the update explicitly deployable or not
bIsPublic	paramBool	Is the update public or not
nEulaDbId	paramInt	Database ID of EULA related to the update revision
bEulaPresent	paramBool	Is the EULA present for the update or not
bEulaAccepted	paramBool	Is the update EULA accepted on the current virtual server or not
lMaxDownloadSize	paramLong	Expected maximal download size of the update
nMsrcSeverity	paramInt	Severity rating of the Microsoft Security Response Center (MSRC) bulletin associated with the update, see severity rating of the Microsoft Security Response Center (MSRC) bulletin associated with the update
strMSKB	paramString	Primary Microsoft Knowledge Base Article ID associated with the update
strKBArticleID	paramString	Microsoft Knowledge Base Article ID associated with the update (might result in multiple records)
strMSSB	paramString	Primary Microsoft Security Bulletin ID associated with the update
strSecurityBulletinID	paramString	Microsoft Security Bulletin ID associated with the update (might result in multiple records)
bCanRequestUserInput	paramBool	Is the update installation potentially interactive (can request user input)
InstallFlags	paramInt	Update installation flags bitmask, see Update installation flags
strMajorVersionName	paramString	Product major version human readable name
ProductName	paramString	Product family human readable name
nApprovementState	paramInt	Updates approvement management attributes, see Update approvement state enum
nIntegralDownloadState	paramInt	Integral download state (for all target hosts), see Update download state enum
nDownloadState	paramInt	Update download state, see Update download state enum
nNotInstalledCount	paramInt	Number of instances of not installed updates (applicable, running, etc.)
nApplicableCount	paramInt	Number of installations where the update is applicable (as a minor update)
nAssignedCount	paramInt	Number of installations where the update is assigned for installation by an existing task (but is not installing yet)
nInstallingCount	paramInt	Number of installations where the update is currently installing
nInstalledCount	paramInt	Number of installations where the update is successfully installed
nFailedCount	paramInt	Number of installations where the last known update installation state is "failed"
nNeedRebootCount	paramInt	Number of installations where the update installation is pending due to OS reboot request
nInstallState	paramInt	Update installation state, see Software update installation state enum
nTaskId	paramInt	Database ID of task having a rule to install the update directly
nTopTaskId	paramInt	Database ID of the top root group task having a rule to install the update directly
SupersededID	paramString	Update identity ("strUpdateID") of update, superseded by given update (results in multiple records)
SupersededRevisionID	paramInt	Revision identity ("nRevisionID") of update, superseded by given update
SupersedingRevisionID	paramInt	Revision identity ("nRevisionID") of update, superseding the given update
IsSuperseding	paramBool	If the update supersedes other update(s)
IsSuperseded	paramBool	If the update is superseded by other update(s)
bHasDependandPatches	paramBool	If some patches require this patch as a prerequisite
bHasPrerequisites	paramBool	If patch has any prerequisites
nMaxVulnSeverity	paramInt	Maximal vulnerability severity rating for all the vulnerability instances to be fixed by this update, see Vulnerability severity rating according to the Kaspersky classification
SeverityRating	paramInt	Vulnerability severity rating of a vulnerability instance to be fixed by this update on a given host, see Vulnerability severity rating according to the Kaspersky classification
VulnerabilityId	paramString	Identity (name) of a vulnerability to be fixed by this update on a given host
nVulnId	paramInt	Database identity of a vulnerability to be fixed by this update on a given host
strVulnUid	paramString	Unique identity of a vulnerability to be fixed by this update on a given host
nVulnDbId	paramString	Database identity of a vulnerability description
nVulnerabilityGlbId	paramLong	Global vulnerability identity in the updatable Kaspersky bases
tmTimestamp	paramDateTime	Last known update state change time from an appropriate host
szwHostFQDN	paramString	FQDN of an appropriate host
nAssignedTaskId	paramInt	Database identity of task assigned to install the update
bIsTaskAssignedPartly	paramBool	If the task identified by c_szwAssignedSysPatchTaskDbId is assigned to install patch not on all the hosts where it is applicable
KLHST_WKS_LID	paramLong	Appropriate host internal integer ID
KLHST_WKS_HOSTNAME	paramString	Appropriate host identity, see List of host attributes
KLHST_WKS_DN	paramString	Appropriate host display name, see List of host attributes
KLHST_WKS_WINHOSTNAME	paramString	Appropriate host netbios name, see List of host attributes
KLHST_WKS_IP	paramLong	Appropriate host IPv4 address (with network byte order), see List of host attributes. Obsolete, use KLHST_WKS_IP_LONG instead
KLHST_WKS_IP_LONG	paramLong	Host IP address (in little-endian byte order), see List of host attributes