fnOSCounts

Returns the types of operating systems and the counts for each for the specified machine group. Tabular data as seen in the OS pie charts in the executive summary reports and the View Dashboard page under the Home tab. Returns one row for each OSType.

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

OSType

varchar

Operating system type such as "Win XP", Win Vista", and "Mac OS X"

OSCount

int

Count of operating system type in the group specified by the parameters