[dbo].[v_ipthruput]

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
ipInRec
ipForwPerc
ipThruput
sysName

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE view v_ipthruput AS SELECT Thresholds.server_addr, Thresholds.probe_addr, Thresholds.upperThreshold AS ipInRec, Thresholds1.upperThreshold AS ipForwPerc, Thresholds.upperThreshold * Thresholds1.upperThreshold AS ipThruput, network_Probe.sysName 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 WHERE (Thresholds.fieldIndex = 201) AND (Thresholds1.fieldIndex = 204) AND network_Probe.collect_flags >= 0 AND network_Probe.collect_flags < 1073741824
GO
GRANT SELECT ON [dbo].[v_ipthruput] TO [uniadmin]
GO