|
|
|
|
vPatchStatusByAgent |
Describes the patch status of an individual agent machine. |
|
Column Name |
Type |
Purpose |
Machine_GroupID |
varchar(201), null |
A concatenated representation of the machine id and the group id to which it is associated |
agentGuid |
numeric(26,0), not null |
Unique 26 digit random number identifying this agent. Master record stored in machNameTab. |
MachineId |
varchar(201), null |
Machine Name used for each agent |
ComputerName |
varchar(80), null |
holds the computer name found in the OS |
ReverseGroupName |
varchar(100), null |
Machine group, then organization the machine is assigned to. |
GroupName |
varchar(100), not null |
Organization, then machine group the machine is assigned to. |
OperatingSystem |
varchar(16), null |
Operating system of the computer. |
OSInformation |
varchar(150), null |
Operating system information |
CurrentUser |
varchar(100), null |
Currently logged on user. |
LastLoggedOnUser |
varchar(100), null |
Previously logged on user. |
LastCheckinTime |
datetime(3), not null |
Date/time the agent last checked in. |
LastRebootTime |
datetime(3), null |
Date/time the agent machine last rebooted. |
totalPatches |
int(10), not null |
total patches reported for agentGuid |
installed |
int(10), not null |
total installed patches reported for agentGuid |
missingApproved |
int(10), not null |
total missing approved patches reported for agentGuid |
missingDenied |
int(10), not null |
total missing denied/ignored patches reported for agentGuid |
missingManual |
int(10), not null |
total missing approved patches that require manual installations reported for agentGuid |
pending |
int(10), not null |
total patches that are pending installation reported for agentGuid |
notReady |
int(10), not null |
total patches that required the user to be logged in for installation and the condition was not met reported for agentGuid |
failed |
int(10), not null |
total patches that failed installation reported for agentGuid |
rebootPending |
int(10), not null |
total patches whose final installation status cannot be determined until after the next reboot reported for agentGuid |
initialUpdateRunning |
int(10), not null |
If true, initial update is running. |
testStatus |
int(10), null |
This flag tells whether the current patch settings for this user have been tested or not. Every time the patch source path or user credential is changed, this flag gets reset. -2 – test pending -1,null – untested 0 – test passed >0 – test failed where bit 0 is set for a registry test error, bit 1 for a file test error (Credential might not have admin rights). 1 – Patch Test Failed (registry) 2 – Patch Test Failed (file) 4 – Patch Test Failed (registry and file) else – Patch file failed to install. 10000 – no exe file was downloaded 10001 – patch failed to copy from LAN server. 10002 – local credential failure 10003 – missing network credential failure 10004 – invalid network credential failure or LAN server was not available 10005 – file source configuration for this machine is invalid 10006 – invalid LAN Cache configuration or LAN Cache server was not available 61440 – exe file was downloaded but would not execute; credential might be invalid |
testStatusDescription |
varchar(89), not null |
Description of above. |
lastScanType |
smallint(5), not null |
Type of last patch scan; 0 -> Legacy scan 1 -> WUA scan (online) 3 -> WUA offline scan (WSUSSCN2.CAB) 4 -> Macintosh scan |
lastScanTypeDescription |
varchar(12), not null |
Description of above. |
scanStatus |
varchar(20), not null |
Unscanned Patch Scanned Succeeded Undetermined |
nonSupportedOS |
varchar(300), not null |
Null if the machine’s OS is supported for patching; OS element value from patchscn.xml if the OS is not supported for patching
|
lastPatchScan |
datetime(3), null |
Date/time the last patch scan occurred |
nextPatchScan |
datetime(3), null |
Date/time the next patch scan is scheduled |
patchScanRecurrenceLabel |
nvarchar(512), not null |
Label for patch scan schedule recurrence (ie. Every 1 month) |
patchScanRecurrenceDetailsLabel |
nvarchar(512), not null |
Label for patch scan schedule detail (ie. On day 1 of the month) |
patchScanExcludeTimeRangeLabel |
nvarchar(512), not null |
Label for patch scan schedule exclude time range |
patchScanRecurrenceEndLabel |
nvarchar(512), not null |
Label for patch scan schedule end date time |
patchScanOfflineLabel |
nvarchar(256), not null |
Label for patch scan schedule (Skip If Offline or Power Up If Offline) |
lastAutomaticUpdate |
datetime(3), null |
Date/time automatic update last occurred |
nextAutomaticUpdate |
datetime(3), null |
Date/time automatic update is next scheduled |
autoUpdateRecurrenceLabel |
nvarchar(512), not null |
Label for auto update schedule recurrence (ie. Every 1 day(s) |
autoUpdateRecurrenceDetailsLabel |
nvarchar(512), not null |
Label for auto update schedule detail (ie. On day 1 of the month) |
autoUpdateExcludeTimeRangeLabel |
nvarchar(512), not null |
Label for auto update schedule exclude time range |
autoUpdateRecurrenceEndLabel |
nvarchar(512), not null |
Label for auto update schedule end date time |
autoUpdateOfflineLabel |
nvarchar(256), not null |
Label for auto update (Skip If Offline or Power Up If Offline) |
wuaSelfUpdateRequired |
tinyint(3), not null |
WUA client self-update: 0 - Unknown 1 - Required 2 - NOT Required |
wuaSelfUpdateRequiredDescription |
varchar(12), not null |
Description of code above. |
online |
int(10), null |
0 -> offline 1 -> online 2 -> online and user has not used the mouse or keyboard for 10 minutes or more. 198 -> account suspended 199 -> agent never checked in (template account) |