Views [dbo].[RTTJitter_statMinuteView]
(local) > mdb > Views > dbo.RTTJitter_statMinuteView
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:08 AM Wednesday, March 07, 2007
Last Modified5: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
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW RTTJitter_statMinuteView AS
SELECT RTTJitter_stat.*, IntervalTime=DATEADD(minute, DATEDIFF(minute,0,getdate()), 0) FROM RTTJitter_stat
GO
GRANT SELECT ON  [dbo].[RTTJitter_statMinuteView] TO [uniadmin]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved