[dbo].[RTTJitter_statHourView]

(local) > mdb > Views > dbo.RTTJitter_statHourView

Properties
Columns
Permissions
SQL Script
Uses
Used By

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

Columns

Name
server_addr
probe_addr
intervaldatetime
intervalduration
jitterstatsstarttimeindex
ctrladminindex
jitterstatscompletions
jitterstatsoverthresholds
jitterstatsnumofrtt
jitterstatsrttsum
jitterstatsrttmin
jitterstatsrttmax
jitterstatsminofpositivessd
jitterstatsmaxofpositivessd
jitterstatsnumofpositivessd
jitterstatssumofpositivessd
jitterstatsminofnegativessd
jitterstatsmaxofnegativessd
jitterstatsnumofnegativessd
jitterstatssumofnegativessd
jitterstatsminofpositivesds
jitterstatsmaxofpositivesds
jitterstatsnumofpositivesds
jitterstatssumofpositivesds
jitterstatsminofnegativesds
jitterstatsmaxofnegativesds
jitterstatsnumofnegativesds
jitterstatssumofnegativesds
jitterstatspacketlosssd
jitterstatspacketlossds
jitterstatspacketoutofsequence
jitterstatspacketmia
jitterstatspacketlatearrival
jitterstatserror
jitterstatsbusies
IntervalTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

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

Uses

[dbo].[rttjitter_stat]
dbo

Used By

[dbo].[RTTJitter_statLastDayView]