[dbo].[RTTStats_statLastWeekView]

(local) > mdb > Views > dbo.RTTStats_statLastWeekView

Properties
Columns
Permissions
SQL Script
Uses

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

Columns

Name
server_addr
probe_addr
intervaldatetime
intervalduration
statscapturestarttimeindex
ctrladminindex
statscapturedistindex
statscapturehopindex
statscapturepathindex
statscapturecompletions
statscaptureoverthresholds
statscapturesumcompletiontime
statscapturecompletiontimemax
statscapturecompletiontimemin
StatsCollectTimeouts
StatsCollectBusies
StatsCollectNoConnections
StatsCollectDrops
StatsCollectSequenceErrors
StatsCollectVerifyErrors
StatsCollectAddress
IntervalTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE VIEW RTTStats_statLastWeekView AS
SELECT * FROM RTTStats_statDayView WHERE IntervalTime >= DATEADD(dd, DATEDIFF(dd,8,getdate()), 0) AND IntervalDateTime < DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)
GO
GRANT SELECT ON [dbo].[RTTStats_statLastWeekView] TO [uniadmin]
GO

Uses

[dbo].[RTTStats_statDayView]
dbo