[dbo].[rttjitter

Property	Value
Heap
Row Count	0
Created	11:07:28 AM Wednesday, March 07, 2007
Last Modified	11:09:42 AM Wednesday, March 07, 2007

Property

Value

Heap

Row Count

Created

11:07:28 AM Wednesday, March 07, 2007

Last Modified

11:09:42 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
	server_addr	int	4
$Indexes baseidx_rttjitter_stat: probe_addr\jitterstatsstarttimeindex\ctrladminindex$	probe_addr	int	4
	intervaldatetime	datetime	8
	intervalduration	int	4
$Indexes baseidx_rttjitter_stat: probe_addr\jitterstatsstarttimeindex\ctrladminindex$	jitterstatsstarttimeindex	int	4
$Indexes baseidx_rttjitter_stat: probe_addr\jitterstatsstarttimeindex\ctrladminindex$	ctrladminindex	int	4
	jitterstatscompletions	float	8
	jitterstatsoverthresholds	float	8
	jitterstatsnumofrtt	float	8
	jitterstatsrttsum	float	8
	jitterstatsrttmin	float	8
	jitterstatsrttmax	float	8
	jitterstatsminofpositivessd	float	8
	jitterstatsmaxofpositivessd	float	8
	jitterstatsnumofpositivessd	float	8
	jitterstatssumofpositivessd	float	8
	jitterstatsminofnegativessd	float	8
	jitterstatsmaxofnegativessd	float	8
	jitterstatsnumofnegativessd	float	8
	jitterstatssumofnegativessd	float	8
	jitterstatsminofpositivesds	float	8
	jitterstatsmaxofpositivesds	float	8
	jitterstatsnumofpositivesds	float	8
	jitterstatssumofpositivesds	float	8
	jitterstatsminofnegativesds	float	8
	jitterstatsmaxofnegativesds	float	8
	jitterstatsnumofnegativesds	float	8
	jitterstatssumofnegativesds	float	8
	jitterstatspacketlosssd	float	8
	jitterstatspacketlossds	float	8
	jitterstatspacketoutofsequence	float	8
	jitterstatspacketmia	float	8
	jitterstatspacketlatearrival	float	8
	jitterstatserror	float	8
	jitterstatsbusies	float	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

server_addr

int

$Indexes baseidx_rttjitter_stat: probe_addr\jitterstatsstarttimeindex\ctrladminindex$

probe_addr

int

intervaldatetime

datetime

intervalduration

int

$Indexes baseidx_rttjitter_stat: probe_addr\jitterstatsstarttimeindex\ctrladminindex$

jitterstatsstarttimeindex

int

$Indexes baseidx_rttjitter_stat: probe_addr\jitterstatsstarttimeindex\ctrladminindex$

ctrladminindex

int

jitterstatscompletions

float

jitterstatsoverthresholds

float

jitterstatsnumofrtt

float

jitterstatsrttsum

float

jitterstatsrttmin

float

jitterstatsrttmax

float

jitterstatsminofpositivessd

float

jitterstatsmaxofpositivessd

float

jitterstatsnumofpositivessd

float

jitterstatssumofpositivessd

float

jitterstatsminofnegativessd

float

jitterstatsmaxofnegativessd

float

jitterstatsnumofnegativessd

float

jitterstatssumofnegativessd

float

jitterstatsminofpositivesds

float

jitterstatsmaxofpositivesds

float

jitterstatsnumofpositivesds

float

jitterstatssumofpositivesds

float

jitterstatsminofnegativesds

float

jitterstatsmaxofnegativesds

float

jitterstatsnumofnegativesds

float

jitterstatssumofnegativesds

float

jitterstatspacketlosssd

float

jitterstatspacketlossds

float

jitterstatspacketoutofsequence

float

jitterstatspacketmia

float

jitterstatspacketlatearrival

float

jitterstatserror

float

jitterstatsbusies

float

Name	Columns
baseidx_rttjitter_stat	probe_addr, jitterstatsstarttimeindex, ctrladminindex
rttjitter_stat_timeindex	intervaldatetime

Name

Columns

baseidx_rttjitter_stat

probe_addr, jitterstatsstarttimeindex, ctrladminindex

rttjitter_stat_timeindex

intervaldatetime

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

Type

Action

Owning Principal

Grant

Delete

uniadmin

Grant

Insert

uniadmin

Grant

Select

uniadmin

Grant

Update

uniadmin

Grant

Select

uniuser

SQL Script

CREATE TABLE [dbo].[rttjitter_stat]
(
[server_addr] [int] NOT NULL,
[probe_addr] [int] NOT NULL,
[intervaldatetime] [datetime] NOT NULL,
[intervalduration] [int] NOT NULL,
[jitterstatsstarttimeindex] [int] NULL,
[ctrladminindex] [int] NULL,
[jitterstatscompletions] [float] NULL,
[jitterstatsoverthresholds] [float] NULL,
[jitterstatsnumofrtt] [float] NULL,
[jitterstatsrttsum] [float] NULL,
[jitterstatsrttmin] [float] NULL,
[jitterstatsrttmax] [float] NULL,
[jitterstatsminofpositivessd] [float] NULL,
[jitterstatsmaxofpositivessd] [float] NULL,
[jitterstatsnumofpositivessd] [float] NULL,
[jitterstatssumofpositivessd] [float] NULL,
[jitterstatsminofnegativessd] [float] NULL,
[jitterstatsmaxofnegativessd] [float] NULL,
[jitterstatsnumofnegativessd] [float] NULL,
[jitterstatssumofnegativessd] [float] NULL,
[jitterstatsminofpositivesds] [float] NULL,
[jitterstatsmaxofpositivesds] [float] NULL,
[jitterstatsnumofpositivesds] [float] NULL,
[jitterstatssumofpositivesds] [float] NULL,
[jitterstatsminofnegativesds] [float] NULL,
[jitterstatsmaxofnegativesds] [float] NULL,
[jitterstatsnumofnegativesds] [float] NULL,
[jitterstatssumofnegativesds] [float] NULL,
[jitterstatspacketlosssd] [float] NULL,
[jitterstatspacketlossds] [float] NULL,
[jitterstatspacketoutofsequence] [float] NULL,
[jitterstatspacketmia] [float] NULL,
[jitterstatspacketlatearrival] [float] NULL,
[jitterstatserror] [float] NULL,
[jitterstatsbusies] [float] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [rttjitter_stat_timeindex] ON [dbo].[rttjitter_stat] ([intervaldatetime]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_rttjitter_stat] ON [dbo].[rttjitter_stat] ([probe_addr], [jitterstatsstarttimeindex], [ctrladminindex]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[rttjitter_stat] TO [uniadmin]
GRANT INSERT ON  [dbo].[rttjitter_stat] TO [uniadmin]
GRANT DELETE ON  [dbo].[rttjitter_stat] TO [uniadmin]
GRANT UPDATE ON  [dbo].[rttjitter_stat] TO [uniadmin]
GRANT SELECT ON  [dbo].[rttjitter_stat] TO [uniuser]
GO