Security Controls

PatchDeployment View

The Reporting2.PatchDeployment view displays patch deployment information.

Column Name Data Type Nullable Description
DeployId int   Identifies the deployment associated with this patch.
DetectedPatchStateId int   The detected patch state id.
DeployScheduledOn datetime X The date the patch was scheduled for deployment (local time).
DeployStartedOn datetime X

The date the patch installation started (GMT).

DeployEndOn datetime X The date the patch installation ended (GMT).
DeployStateId int X The deployment status Id. See [Reporting].[DeployState].

Content

You can run the following query to display DisplayStateID values and descriptions.

SELECT [Id]

,[Value]

,[Description]

FROM [Protect].[Reporting].[DeployState]


Was this article useful?