CREATE view  v_ifutil AS SELECT Thresholds.server_addr, Thresholds.probe_addr, Thresholds.rsrcIndex, AVG(Thresholds.upperThreshold) AS ifInUtil, AVG(Thresholds1.upperThreshold) AS ifOutUtil, AVG(Thresholds.upperThreshold + Thresholds1.upperThreshold) AS ifUtil, network_Probe.sysName, network_Probe.IP_addr FROM  Thresholds INNER JOIN  Thresholds Thresholds1 ON Thresholds.server_addr = Thresholds1.server_addr AND Thresholds.probe_addr = Thresholds1.probe_addr AND Thresholds.rsrcIndex = Thresholds1.rsrcIndex INNER JOIN  network_Probe ON Thresholds1.server_addr = network_Probe.server_addr AND Thresholds1.probe_addr = network_Probe.probe_addr INNER JOIN  M2if ON Thresholds.server_addr = M2if.server_addr AND Thresholds.probe_addr = M2if.probe_addr AND Thresholds.rsrcIndex = M2if.ifIndex WHERE (Thresholds.fieldIndex = 101) AND (Thresholds1.fieldIndex = 107) AND network_Probe.collect_flags >= 0 AND network_Probe.collect_flags < 1073741824 GROUP BY Thresholds.server_addr, Thresholds.probe_addr, network_Probe.sysName, Thresholds.rsrcIndex, network_Probe.IP_addr, M2if.ifType HAVING (Thresholds.server_addr <> 0)
GO
GRANT SELECT ON  [dbo].[v_ifutil] TO [uniadmin]
GO