[dbo].[BaselineLUView]

(local) > mdb > Views > dbo.BaselineLUView

Properties
Columns
Permissions
SQL Script
Uses

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

Columns

Name
server_addr
probe_addr
probeindex
utilsumu
utilsuml
broadcastframesu
broadcastframesl
multicastframesu
multicastframesl
frameslostprobeu
frameslostprobel
frameslostbufu
frameslostbufl
frameslosthardu
frameslosthardl
intervaldate
IntervalDateTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE VIEW BaselineLUView AS SELECT BaselineLU.*, IntervalDateTime=IntervalDate FROM BaselineLU
GO
GRANT SELECT ON [dbo].[BaselineLUView] TO [uniadmin]
GO

Uses

[dbo].[baselinelu]
dbo