CREATE VIEW RTTStats_stat AS
SELECT r.*
,r2.StatsCollectTimeouts
,StatsCollectBusies
,StatsCollectNoConnections
,StatsCollectDrops
,StatsCollectSequenceErrors
,StatsCollectVerifyErrors
,StatsCollectAddress
FROM RTTStatsCapture_stat r, RTTStatsColl_stat r2
WHERE r.server_addr = r2.server_addr
AND r.probe_addr=r2.probe_addr
AND r.StatsCaptureStartTimeIndex=r2.StatsCaptureStartTimeIndex
AND r.StatsCapturePathIndex=r2.StatsCapturePathIndex
AND r.StatsCaptureHopIndex=r2.StatsCaptureHopIndex
GO
GRANT SELECT ON [dbo].[RTTStats_stat] TO [uniadmin]
GO
[dbo].[RTTStats_stat]