[dbo].[rmonhostcontrol]

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

Property

Value

Heap

Row Count

Created

11:07:27 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_rmonhostcontrol: probe_addr\intervaldatetime\hostcontrolindex$	probe_addr	int	4
$Indexes baseidx_rmonhostcontrol: probe_addr\intervaldatetime\hostcontrolindex$	intervaldatetime	datetime	8
$Indexes baseidx_rmonhostcontrol: probe_addr\intervaldatetime\hostcontrolindex$	hostcontrolindex	int	4
	hostcontroldatasource	int	4
	hostcontrolstatus	tinyint	1
	hosttopngrantedsize0	tinyint	1
	hosttopngrantedsize1	tinyint	1
	hosttopngrantedsize2	tinyint	1
	hosttopngrantedsize3	tinyint	1
	hosttopngrantedsize4	tinyint	1
	hosttopngrantedsize5	tinyint	1
	hosttopngrantedsize6	tinyint	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

server_addr

int

$Indexes baseidx_rmonhostcontrol: probe_addr\intervaldatetime\hostcontrolindex$

probe_addr

int

$Indexes baseidx_rmonhostcontrol: probe_addr\intervaldatetime\hostcontrolindex$

intervaldatetime

datetime

$Indexes baseidx_rmonhostcontrol: probe_addr\intervaldatetime\hostcontrolindex$

hostcontrolindex

int

hostcontroldatasource

int

hostcontrolstatus

tinyint

hosttopngrantedsize0

tinyint

hosttopngrantedsize1

tinyint

hosttopngrantedsize2

tinyint

hosttopngrantedsize3

tinyint

hosttopngrantedsize4

tinyint

hosttopngrantedsize5

tinyint

hosttopngrantedsize6

tinyint

Name	Columns
baseidx_rmonhostcontrol	probe_addr, intervaldatetime, hostcontrolindex

Name

Columns

baseidx_rmonhostcontrol

probe_addr, intervaldatetime, hostcontrolindex

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].[rmonhostcontrol]
(
[server_addr] [int] NULL,
[probe_addr] [int] NULL,
[intervaldatetime] [datetime] NULL,
[hostcontrolindex] [int] NULL,
[hostcontroldatasource] [int] NULL,
[hostcontrolstatus] [tinyint] NULL,
[hosttopngrantedsize0] [tinyint] NULL,
[hosttopngrantedsize1] [tinyint] NULL,
[hosttopngrantedsize2] [tinyint] NULL,
[hosttopngrantedsize3] [tinyint] NULL,
[hosttopngrantedsize4] [tinyint] NULL,
[hosttopngrantedsize5] [tinyint] NULL,
[hosttopngrantedsize6] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_rmonhostcontrol] ON [dbo].[rmonhostcontrol] ([probe_addr], [intervaldatetime], [hostcontrolindex]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[rmonhostcontrol] TO [uniadmin]
GRANT INSERT ON  [dbo].[rmonhostcontrol] TO [uniadmin]
GRANT DELETE ON  [dbo].[rmonhostcontrol] TO [uniadmin]
GRANT UPDATE ON  [dbo].[rmonhostcontrol] TO [uniadmin]
GRANT SELECT ON  [dbo].[rmonhostcontrol] TO [uniuser]
GO