[dbo].[RTTStatsCapture_statThView]
CREATE view RTTStatsCapture_statThView AS SELECT RTTStatsCapture_stat.server_addr, RTTStatsCapture_stat.probe_addr, RTTStatsCapture_stat.CtrlAdminIndex, RTTStatsCapture_stat.StatsCapturePathIndex, RTTStatsCapture_stat.StatsCaptureHopIndex, IntervalDateTime, IntervalDuration, StatsCaptureOverThresholds=case WHEN StatsCaptureCompletions= 0 THEN 0 ELSE StatsCaptureOverThresholds/StatsCaptureCompletions END, StatsCaptureSumCompletionTime=case WHEN StatsCaptureCompletions= 0 THEN 0 ELSE StatsCaptureSumCompletionTime/StatsCaptureCompletions END FROM RTTStatsCapture_stat
GO
GRANT SELECT ON [dbo].[RTTStatsCapture_statThView] TO [uniadmin]
GO
