CREATE view  FRCircuitStatsThView AS SELECT FRCircuitStats.server_addr, FRCircuitStats.probe_addr, FRCircuitStats.frCircuitIfIndex, FRCircuitStats. frCircuitDlci, IntervalDateTime, IntervalDuration, frCircuitSentOctets=case WHEN (ifSpeed*IntervalDuration)= 0 THEN 0 WHEN ifSpeed = 1 THEN 0 ELSE frCircuitSentOctets*8/(ifSpeed*IntervalDuration) END, frCircuitSentFrames=case WHEN IntervalDuration= 0 THEN 0 ELSE frCircuitSentFrames/IntervalDuration END, frCircuitReceivedFECNs=case WHEN IntervalDuration= 0 THEN 0 ELSE frCircuitReceivedFECNs/IntervalDuration END, frCircuitReceivedBECNs=case WHEN IntervalDuration= 0 THEN 0 ELSE frCircuitReceivedBECNs/IntervalDuration END, frCircuitReceivedFrames=case WHEN IntervalDuration= 0 THEN 0 ELSE frCircuitReceivedFrames/IntervalDuration END, frCircuitReceivedOctets=case WHEN (ifSpeed*IntervalDuration)= 0 THEN 0 WHEN ifSpeed = 1 THEN 0 ELSE frCircuitReceivedOctets*8/(ifSpeed*IntervalDuration) END, ResourceNameFRView.ifSpeed FROM  FRCircuitStats, ResourceNameFRView WHERE userId = 0 AND ResourceNameFRView.server_addr=FRCircuitStats.server_addr AND ResourceNameFRView.probe_addr=FRCircuitStats.probe_addr AND ResourceNameFRView.rsrcIndex=FRCircuitStats.frCircuitIfIndex AND ResourceNameFRView.rsrcOtherIndex=FRCircuitStats.frCircuitDlci
GO
GRANT SELECT ON  [dbo].[FRCircuitStatsThView] TO [uniadmin]
GO