DetectedPatchState view

The Reporting2.DetectedPatchState view displays the state of a patch found on a machine.

Column Name	Data Type	Nullable	Description
Id	int		This is the unique identifier.
AssessedMachineStateId	int		The assessed machine state id. See [Reporting2].[AssessedMachineState].
PatchId	int		The patch id. See [Reporting2].[Patch].
ProductId	int		The product id. See [Reporting2].[Product].
InstalledOn	datetime	X	The date the patch was installed.
InstallStateId	int	X	The install state Id. See [Reporting2].[InstallState]