[dbo].[RMON2ProtocolDistThView]
CREATE view RMON2ProtocolDistThView AS SELECT RMON2ProtocolDist.server_addr, RMON2ProtocolDist.probe_addr, RMON2ProtocolDist.protocolDirRMIndex, RMON2ProtocolDist.protocolDistDataSource, IntervalDateTime, IntervalDuration, protocolDistStatsPkts=case WHEN IntervalDuration= 0 THEN 0 ELSE protocolDistStatsPkts/IntervalDuration END, protocolDistStatsOctets=case WHEN (ifSpeed*IntervalDuration)= 0 THEN 0 WHEN ifSpeed = 1 THEN 0 ELSE protocolDistStatsOctets/(ifSpeed*IntervalDuration) END, ResourceNameRMON2View.ifSpeed FROM RMON2ProtocolDist, ResourceNameRMON2View WHERE userId = 0 AND ResourceNameRMON2View.server_addr=RMON2ProtocolDist.server_addr AND ResourceNameRMON2View.probe_addr=RMON2ProtocolDist.probe_addr AND ResourceNameRMON2View.rsrcIndex=RMON2ProtocolDist.protocolDistDataSource
GO
GRANT SELECT ON [dbo].[RMON2ProtocolDistThView] TO [uniadmin]
GO
