Views [dbo].[BaselineBGP4View]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:20 AM Wednesday, March 07, 2007
Last Modified5:37:03 PM Monday, May 04, 2009
Columns
Name
server_addr
probe_addr
bgpidentifier
bgppeeridentifier
bgppeerinupdatesu
bgppeerinupdatesl
bgppeeroutupdatesu
bgppeeroutupdatesl
bgppeerintotalmessagesu
bgppeerintotalmessagesl
bgppeerouttotalmessagesu
bgppeerouttotalmessagesl
bgppeerfsmestablishedtransu
bgppeerfsmestablishedtransl
bgppeerinupdateelapsedtimeu
bgppeerinupdateelapsedtimel
intervaldate
IntervalDateTime
Permissions
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW BaselineBGP4View AS SELECT BaselineBGP4.*, IntervalDateTime=IntervalDate FROM  BaselineBGP4
GO
GRANT SELECT ON  [dbo].[BaselineBGP4View] TO [uniadmin]
GO
Uses