[dbo].[v_cpuUtil]

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:20 AM Wednesday, March 07, 2007
Last Modified	5:37:38 PM Monday, May 04, 2009

Name
server_addr
probe_addr
sysName
IP_addr
cpuUtil

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE view v_cpuUtil AS SELECT Thresholds.server_addr, Thresholds.probe_addr, network_Probe.sysName, network_Probe.IP_addr, Thresholds.upperThreshold AS cpuUtil FROM Thresholds INNER JOIN network_Probe ON Thresholds.server_addr = network_Probe.server_addr AND Thresholds.probe_addr = network_Probe.probe_addr WHERE (Thresholds.fieldIndex = 409) AND (Thresholds.server_addr <> 0) AND network_Probe.collect_flags >= 0 AND network_Probe.collect_flags < 1073741824
GO
GRANT SELECT ON [dbo].[v_cpuUtil] TO [uniadmin]
GO