CREATE view  RMONetherStatsStatsThView AS SELECT RMONetherStatsStats.server_addr, RMONetherStatsStats.probe_addr, RMONetherStatsStats.etherStatsIndex, IntervalDateTime, IntervalDuration, etherStatsDropEvents=case WHEN etherStatsPkts= 0 THEN 0 ELSE etherStatsDropEvents/etherStatsPkts END, etherStatsOctest=case WHEN (ifSpeed*IntervalDuration)= 0 THEN 0 WHEN ifSpeed = 1 THEN 0 ELSE 8.0*etherStatsOctets/(ifSpeed*IntervalDuration) END, etherStatsPkts=case WHEN IntervalDuration= 0THEN 0 ELSE etherStatsPkts/IntervalDuration END, etherStatsBroadcastPkts=case WHEN IntervalDuration= 0 THEN 0 ELSE etherStatsBroadcastPkts/IntervalDuration END, etherStatsMulticastPkts=case WHEN IntervalDuration= 0 THEN 0 ELSE etherStatsMulticastPkts/IntervalDuration END, etherStatsCRCAlignErrors=case WHEN etherStatsPkts= 0 THEN 0 ELSE etherStatsCRCAlignErrors/etherStatsPkts END, etherStatsUndersizePkts=case WHEN etherStatsPkts= 0 THEN 0 ELSE etherStatsUndersizePkts/etherStatsPkts END, etherStatsOversizePkts=case WHEN etherStatsPkts= 0 THEN 0 ELSE etherStatsOversizePkts/etherStatsPkts END, etherStatsFragments=case WHEN IntervalDuration= 0 THEN 0 ELSE etherStatsFragments/IntervalDuration END, etherStatsJabbers=case WHEN etherStatsPkts= 0 THEN 0 ELSE etherStatsJabbers/etherStatsPkts END, etherStatsCollisions=case WHEN IntervalDuration= 0 THEN 0 ELSE etherStatsCollisions/IntervalDuration END, ResourceNameRMONView.ifSpeed FROM  RMONetherStatsStats, ResourceNameRMONView WHERE userId = 0 AND ResourceNameRMONView.server_addr=RMONetherStatsStats.server_addr AND ResourceNameRMONView.probe_addr=RMONetherStatsStats.probe_addr AND ResourceNameRMONView.rsrcOtherIndex=RMONetherStatsStats.etherStatsIndex
GO
GRANT SELECT ON  [dbo].[RMONetherStatsStatsThView] TO [uniadmin]
GO