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.