Views [dbo].[BaselineBGP4View]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:31:56 PM Sunday, December 05, 2010
Last Modified7:19:19 PM Friday, January 07, 2011
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