CREATE view v_alert AS SELECT network_Alert.server_addr, network_Alert.probe_addr, network_Probe.sysName, network_Probe.IP_addr, network_Alert.rsrcIndex, COUNT(network_Alert.threshold) AS numAlerts FROM network_Alert INNER JOIN network_Probe ON network_Alert.server_addr = network_Probe.server_addr AND network_Alert.probe_addr = network_Probe.probe_addr
WHERE ( (dbo.date('now') - network_Alert.IntervalDateTime) < (SELECT dbo.date(char (optionDataInt) + ' days') FROM RMConfiguration WHERE optionName = 'ThresholdCalcSize') AND network_Probe.collect_flags >= 0 AND network_Probe.collect_flags < 1073741824 ) GROUP BY network_Alert.server_addr,network_Alert.probe_addr, network_Alert.rsrcIndex, network_Probe.sysName, network_Probe.IP_addr
GO
GRANT SELECT ON [dbo].[v_alert] TO [uniadmin]
GO
[dbo].[v_alert]