v_xr_computerpatchcompliance

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ClientID INT 10 0
LocationID INT 10 0
LocationName VARCHAR 50 null
LocationArea VARCHAR 52 √ null
ComputerID INT 10 0
ComputerName VARCHAR 50 null
ComputerIsServer TINYINT 3 null
ComputerIsVirtual INT 10 0
ComputerOS VARCHAR 255 √ null
ComputerServicePack DECIMAL 5,2 null
ComputerServicePackName VARCHAR 255 null
ComputerOSFullVersion VARCHAR 255 null
ComputerDateOSStart DATETIME 19 null
ComputerDateAgentAdded DATETIME 19 null
ComputerDateAddedLT DATETIME 19 null
PatchTotalApproved INT 10 null
PatchCompliance DOUBLE 22 null
PatchDateLastScanned DATETIME 19 null
PatchDateLastPatched DATETIME 19 null
ComputerDateLastContact DATETIME 19 null
PatchRiskNoPatchInventory INT 10 null
PatchRiskPendingReboot INT 10 null
PatchCriticalInstallCount INT 10 null
PatchCriticalFailedCount INT 10 null
PatchCriticalNotAttemptedCount INT 10 null
PatchImportantInstallCount INT 10 null
PatchImportantFailedCount INT 10 null
PatchImportantNotAttemptedCount INT 10 null
PatchModerateInstallCount INT 10 null
PatchModerateFailedCount INT 10 null
PatchModerateNotAttemptedCount INT 10 null
PatchLowInstallCount INT 10 null
PatchLowFailedCount INT 10 null
PatchLowNotAttemptedCount INT 10 null
PatchUnspecifiedInstallCount INT 10 null
PatchUnspecifiedFailedCount INT 10 null
PatchUnspecifiedNotAttemptedCount INT 10 null
PatchCvssHighInstallCount INT 10 null
PatchCvssHighFailedCount INT 10 null
PatchCvssHighNotAttemptedCount INT 10 null
PatchCvssMediumInstallCount INT 10 null
PatchCvssMediumFailedCount INT 10 null
PatchCvssMediumNotAttemptedCount INT 10 null
PatchCvssLowInstallCount INT 10 null
PatchCvssLowFailedCount INT 10 null
PatchCvssLowNotAttemptedCount INT 10 null

View Definition

Possibly Referenced Tables/Views