[dbo].[LSYTermServerStatsMonthView]

(local) > mdb > Views > dbo.LSYTermServerStatsMonthView

Properties
Columns
Permissions
SQL Script
Uses

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

Columns

Name
server_addr
probe_addr
intervaldatetime
intervalduration
probeindex
termserverkeyid
pktstoclient
bytestoclient
pktstoserver
bytestoserver
rttermcount
rttermsum
rttermsos
netresponsetype
nrtermcount
nrtermsum
nrtermsos
linkerrcount
IntervalTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE VIEW LSYTermServerStatsMonthView AS
SELECT LSYTermServerStats.*, IntervalTime=DATEADD(month, DATEDIFF(month,0,getdate()), 0) FROM LSYTermServerStats
GO
GRANT SELECT ON [dbo].[LSYTermServerStatsMonthView] TO [uniadmin]
GO

Uses

[dbo].[lsytermserverstats]
dbo