Both of these functions use the same parameters and return the same columns but each has different filtering based on patch approval policies.

fnMissingPatchCounts_UsePolicy

Returns the number of patches, using the patch approval policies, for the specified machine group. Tabular data as seen in the missing patch pie charts in the executive summary reports and the View Dashboard page under the Home tab. Only one row is returned.

fnMissingPatchCounts_NoPolicy

Returns the number of patches, without using the patch approval policies, for the specified machine group. Tabular data as seen in the missing patch pie charts in the View Dashboard page under the Home tab. Only one row is returned.

Parameter

Type

Purpose

@groupName

varchar

Machine group name; Use null or an empty string for all groups

@skipSubGroups

tinyint

When a group name is provided in the above parameter, determines whether to filter the results for only the one specified group or for the specified group and all of its subgroups:

0 = Use specified group and all of its subgroups

1 = Skip subgroups – use only the one specified group

Column

Type

Purpose

GroupName

varchar

Machine group name; Returns "All Groups" when the @groupName parameter is null or an empty string

WithSubgroups

varchar

YES when @skipSubGroups = 0 and for "All Groups"

NO when @skipSubGroups = 1

FullyPatched

int

Count of fully patched machines in the group specified by the parameters

Missing12

int

Count of machines missing 1-2 patches in the group specified by the parameters

Missing35

int

Count of machines missing 3-5 patches in the group specified by the parameters

MissingMore5

int

Count of machines missing 5 or more patches in the group specified by the parameters

Unscanned

int

Count of unscanned machines in the group specified by the parameters

Unsupported

int

Count of machines for which patching is not supported in the group specified by the parameters