[dbo].[LSYLanUtilizationThView]
CREATE view LSYLanUtilizationThView AS SELECT LSYLanUtilization.server_addr, LSYLanUtilization.probe_addr, LSYLanUtilization.probeIndex, IntervalDateTime, IntervalDuration, utilSum=case WHEN utilCount= 0 THEN 0 ELSE utilSum/utilCount END,
broadcastFrames=case WHEN IntervalDuration= 0 THEN 0 ELSE broadcastFrames/IntervalDuration END,
multicastFrames=case WHEN IntervalDuration= 0 THEN 0 ELSE multicastFrames/IntervalDuration END,
framesLostProbe=case WHEN totalFrames= 0 THEN 0 ELSE framesLostProbe/totalFrames END,
framesLostBuf=case WHEN totalFrames= 0 THEN 0 ELSE framesLostHard/totalFrames END,
framesLostHard=case WHEN totalFrames= 0 THEN 0 ELSE framesLostBuf/totalFrames END
FROM LSYLanUtilization
GO
GRANT SELECT ON [dbo].[LSYLanUtilizationThView] TO [uniadmin]
GO
