Views [dbo].[v_cpuUtil]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:12 PM Sunday, December 05, 2010
Last Modified7:19:35 PM Friday, January 07, 2011
Columns
Name
server_addr
probe_addr
sysName
IP_addr
cpuUtil
Permissions
TypeActionOwning Principal
GrantSelectuniadmin
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
Uses