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

• Script - MySQL - View - Create - Plugin_ProVal_V_Patch_Count_Status
• Dataview - Dash - Missing Patch - Count by Machines - Client Filter

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.