[dbo].[LSYTermServerStatsThView]
CREATE view LSYTermServerStatsThView AS SELECT LSYTermServerStats.server_addr, LSYTermServerStats.probe_addr, LSYTermServerStats.probeIndex, LSYTermServerStats.termServerKeyId, IntervalDateTime, IntervalDuration, bytesToClients=case WHEN IntervalDuration= 0 THEN 0 ELSE bytesToClient/IntervalDuration END, bytesToServer=case WHEN IntervalDuration= 0 THEN 0 ELSE bytesToServer/IntervalDuration END, RTTermSum=case WHEN RTTermCount= 0 THEN 0 ELSE RTTermSum/RTTermCount END, NRTermSum=case WHEN NRTermCount= 0 THEN 0 ELSE NRTermSum/NRTermCount END, linkErrCount=case WHEN pktsToServer= 0 THEN 0 ELSE linkErrCount/pktsToServer END FROM LSYTermServerStats
GO
GRANT SELECT ON [dbo].[LSYTermServerStatsThView] TO [uniadmin]
GO
