CREATE view  v_ifthruput AS SELECT ifInOctets.server_addr, ifInOctets.probe_addr, ifInOctets.rsrcIndex, AVG(ifInOctets.upperThreshold) AS inIfUtil, AVG(ifOutOctets.upperThreshold) AS outIfUtil, SUM((ifInOctets.upperThreshold + ifOutOctets.upperThreshold) * M2if.ifSpeed / 2) AS ifThruput, network_Probe.sysName, network_Probe.IP_addr FROM  Thresholds ifInOctets INNER JOIN  Thresholds ifOutOctets ON ifInOctets.server_addr = ifOutOctets.server_addr AND ifInOctets.probe_addr = ifOutOctets.probe_addr AND ifInOctets.rsrcIndex = ifOutOctets.rsrcIndex INNER JOIN  M2if ON ifOutOctets.server_addr = M2if.server_addr AND ifOutOctets.probe_addr = M2if.probe_addr AND ifOutOctets.rsrcIndex = M2if.ifIndex INNER JOIN  network_Probe ON M2if.server_addr = network_Probe.server_addr AND M2if.probe_addr = network_Probe.probe_addr WHERE (ifInOctets.fieldIndex = 101) AND (ifOutOctets.fieldIndex = 107) AND network_Probe.collect_flags >= 0 AND network_Probe.collect_flags < 1073741824 GROUP BY ifInOctets.server_addr, ifInOctets.probe_addr, ifInOctets.rsrcIndex, network_Probe.sysName, network_Probe.IP_addr
GO
GRANT SELECT ON  [dbo].[v_ifthruput] TO [uniadmin]
GO