• Yes a machine is viewReportMonitorCounterLog.ComputerName.

    The avg needs to be calculated per counter instance per machine - ie avg of c drive values for machine 1, avg of c drive values for machine 2 etc and if any counter instance average is over 80 on one machine that machine is then counted, if no counter instances average above 80, this machine is ignored.

    For example:

    Machine Counter Instance Avg Value

    Server 1 c: 65.27

    Server 1 E: 84.64

    Server 2 C: 37.27

    Server 2 D: 57.00

    Server 2 E: 55.61

    Server 3 C: 20.00

    Server 3 E: 46.89

    I'm trying to get an output which is just 1 row in a table:

    'Number of Machines Exceeding Critical Utilisation Values' '1'