Plugin_ProVal_V_Patch_Count_Status
Purpose
This view provides a client-level breakdown of machines missing a certain number of patches.
Sample data:
Dependencies
CWM - Automate - Script - MySQL - View - Create - Plugin_ProVal_V_Patch_Count_Status
Tables
plugin_proval_v_patch_count_status
| Column | Type | Explanation |
|---|---|---|
| clientid | int(11) | Client ID |
| os | varchar(11) | Operating System (Workstation |
| category | varchar(18) | Category Name (Full |
| Machine Count | int(5) | Number of machines falling under the concerned category for the client. |