Assessed Machine State View

The Reporting2.AssessedMachineState view displays all assessments performed on a machine.

Column Name	Data Type	Nullable	Description
Id	int		The unique identifier.
MachineId	int	X	The machine id of this assessment. See [Reporting2].[Machine].
PatchScanId	int	X	The patch scan id of this assessment. See [Reporting2].[PatchScan].
IPAddress	nvarchar(45)	X	The IP address of this machine. This will be displayed in IPV4 or IPV6 format.
AssessedOn	datetime	X	The assessment date.