[dbo].[BGP4PeerEntryMessagePSMonthView]

(local) > mdb > Views > dbo.BGP4PeerEntryMessagePSMonthView

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:31:56 PM Sunday, December 05, 2010
Last Modified	7:19:18 PM Friday, January 07, 2011

Columns

Name
server_addr
probe_addr
bgpidentifier
bgppeeridentifier
intervaldatetime
intervalduration
bgppeerstate
bgppeeradminstatus
bgppeerinupdates
bgppeeroutupdates
bgppeerintotalmessages
bgppeerouttotalmessages
bgppeerlasterror
bgppeerfsmestablishedtrans
bgppeerfsmestablishedtime
bgppeerholdtime
bgppeerkeepalive
bgppeerinupdateelapsedtime
IntervalTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE VIEW BGP4PeerEntryMessagePSMonthView AS
SELECT BGP4PeerEntryMessage.*, IntervalTime=DATEADD(month, DATEDIFF(month,0,getdate()), 0) FROM BGP4PeerEntryMessage WHERE datepart(weekday, IntervalDateTime) BETWEEN 2 AND 6 AND datepart(hour, IntervalDateTime) BETWEEN 8 AND 18
GO
GRANT SELECT ON [dbo].[BGP4PeerEntryMessagePSMonthView] TO [uniadmin]
GO

Uses

[dbo].[bgp4peerentrymessage]
dbo