Skip to main content

Patching and CU compliance Metrics

Summary

The dataview is designed to display the patch and cumulative update compliance score for the entire environment. It displays data exclusively for supported Windows computers with managed patch policies that have been online in Automate within the past 30 days and are part of production patching groups.

Dependencies

Columns

ColumnExplanation
Approved Prod. PatchesNumber of approved production patches
Installed Prod. PatchesNumber of installed production patches
Failed Prod. PatchesNumber of failed production patches
Missing Prod. PatchesNumber of missing production patches
Prod. Patch Compliance %Patch compliance of the whole environment for the production patches ( Number of installed production patches divided by Number of approved production patches multiplied by 100)
Supported Prod. ComputersNumber of active Windows machines with managed patch policies that are part of production patching groups.
Patch Managed ClientsTotal number of patch-managed clients
Compliant Clients - Prod. PatchingTotal number of compliant clients. A client is considered compliant if the patch compliance of the client is greater than 75%.
Non-Compliant Clients - Prod. PatchingTotal number of non-compliant clients. Clients with the patch compliance score less than 75%.
Compliant Clients - Prod. Patching %Percentage of compliant clients. (Compliant Clients - Production Patching divided by Patch Managed Clients multiplied by 100)
CU Age - CurrentThe count of computers where the installed latest cumulative update's release date falls within the last 45 days.
CU Age - 46-90The count of computers where the installed latest cumulative update's release date falls between 46 to 90 days.
CU Age - 91-135The count of computers where the installed latest cumulative update's release date falls between 91 to 135 days.
CU Age - 136+The number of computers where the release date of the installed latest cumulative update is at least 136 days ago.
CU Score %This scoring system is custom-made, based on the age of the installed cumulative update. A score of 100 is assigned if the cumulative update is less than 45 days old, 75 if it falls between 46 to 90 days, 50 for updates aged between 91 to 135 days, and 25 for updates older than 136 days. The formula used for calculation is as follows: (CU Age - Current) * 100 + (CU Age - 46-90) * 75 + (CU Age - 91-135) * 50 + (CU Age - 136+) * 25) / Supported CU Eligible Computers
CU Age - Current %Percentage of computers where the installed latest cumulative update's release date falls within the last 45 days. ( CU Age - Current divided by Total Eligible Computers - CU multiplied by 100)
CU Age - 46-90 %Percentage of computers where the installed latest cumulative update's release date falls between 46 to 90 days. ( CU Age - 46-90 divided by Total Eligible Computers - CU multiplied by 100)
CU Age - 91-135 %Percentage of computers where the installed latest cumulative update's release date falls between 91 to 135 days. ( CU Age - 91-135 divided by Total Eligible Computers - CU multiplied by 100)
CU Age - 136+ %Percentage of computers where the release date of the installed latest cumulative update is at least 136 days ago. ( CU Age - 136+ divided by Total Eligible Computers - CU multiplied by 100)
Total Eligible Computers - CUTotal number of supported Windows computers that have been online in Automate within the past 30 days and exist in pvl_win_latest_installed_cu table.
Total Eligible Clients - CUTotal number of clients with supported Windows computers that have been online in Automate within the past 30 days and exist in pvl_win_latest_installed_cu table.
Compliant Clients - CUTotal number of individual clients where CU Score % is greater than or equal to 75.
Non-Compliant Clients - CUTotal number of individual clients where CU Score % is less than 75.
Compliant Clients - CU %Percentage of compliant clients based on CU Score %. (Compliant Clients - CU divided by Total Eligible Clients - CU multiplied by 100)

Format Control

ColumnColourDescription
Prod. Patch Compliance %RedLess than 75
Prod. Patch Compliance %GreenGreater than or equal to 75
Compliant Clients - Prod. Patching %RedLess than 75
Compliant Clients - Prod. Patching %GreenGreater than or equal to 75
CU Score %RedLess than 75
CU Score %GreenGreater than or equal to 75
Compliant Clients - CU %RedLess than 75
Compliant Clients - CU %GreenGreater than or equal to 75