Appears the data held in the table Evt_SUA_Execution is no longer being updated correctly since upgrading to ITMS 8.0.x, for the number for installed, failed and missing Software Updates is always NULL.
Evt_SUA_Execution is a legacy table and is no longer being used by ITMS for current Software Update status on client side.
The new table is called Inv_Software_Update_Distribution_Status and any custom reports will need to be updated.
Note: The table will be empty of entries once the computer applies all targeted updates, sends back compliance information and the NS.Windows Patch Remediation Settings schedule runs. Additionally, the table Inv_Software_Update_Distribution_Status uses status codes.
Here is a list of possible status values:
|Client status (visible)||ID||Description|
|Invalid package||1||Package is unavailable on client|
|Pending||8||Maintenance window isn't open. Waiting till it will be processed|
|Retrying download||16||Retrying download|
|Installed||128||Installed by Software Update Plugin|
|Installed by user||256||Installed manually by user|
|Failed||512||Failed to apply with maximum number of retry attempts|
|Failed(rescheduled)||1024||Failed to install and was rescheduled for another try|
|Not applicable||2048||Not applicable for current computer based on results of assessment scan|
|Scheduled||4096||Update is downloaded and scheduled for deployment|
|Superseded||8192||Superseded by another update delivered to agent|
|Installation in progress||16384||Installation of update is started|
|Verification||32768||Checking status after package execution|
|Restart pending||65536||Update requires restart to finish deployment of new files|
|Installed with errors||131072||Update installed new files, but returns non-success code during deployment|