[dbo].[BGP4PeerEntryMessageThView]
CREATE view BGP4PeerEntryMessageThView AS SELECT BGP4PeerEntryMessage.server_addr, BGP4PeerEntryMessage.probe_addr, BGP4PeerEntryMessage.bgpIdentifier, BGP4PeerEntryMessage.bgpPeerIdentifier, IntervalDateTime, IntervalDuration, bgpPeerInUpdates=case WHEN bgpPeerInTotalMessages= 0 THEN 0 ELSE bgpPeerInUpdates/bgpPeerInTotalMessages END, bgpPeerOutUpdates=case WHEN bgpPeerOutTotalMessages= 0 THEN 0 ELSE bgpPeerOutUpdates/bgpPeerOutTotalMessages END, bgpPeerInTotalMessages=case WHEN IntervalDuration= 0 THEN 0 ELSE bgpPeerInTotalMessages/IntervalDuration END, bgpPeerOutTotalMessages=case WHEN IntervalDuration= 0 THEN 0 ELSE bgpPeerOutTotalMessages/IntervalDuration END, bgpPeerFsmEstablishedTrans=case WHEN IntervalDuration= 0 THEN 0 ELSE bgpPeerFsmEstablishedTrans/IntervalDuration END, bgpPeerInUpdateElapsedTime=bgpPeerInUpdateElapsedTime FROM BGP4PeerEntryMessage
GO
GRANT SELECT ON [dbo].[BGP4PeerEntryMessageThView] TO [uniadmin]
GO
