[dbo].[BaselineTSView]

(local) > mdb > Views > dbo.BaselineTSView

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:20 AM Wednesday, March 07, 2007
Last Modified	5:37:04 PM Monday, May 04, 2009

Columns

Name
server_addr
probe_addr
probeindex
termserverkeyid
bytestoclientsu
bytestoclientsl
bytestoserveru
bytestoserverl
rttermsumu
rttermsuml
nrtermsumu
nrtermsuml
linkerrcountu
linkerrcountl
intervaldate
IntervalDateTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

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

Uses

[dbo].[baselinets]
dbo