Tables [dbo].[ucm_mib_reportdata]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:36 AM Wednesday, March 07, 2007
Last Modified11:07:36 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
hostnamenvarchar(255)510
No
mibnamenvarchar(48)96
No
instancenvarchar(20)40
Yes
tablegroupnvarchar(48)96
No
tgdescnvarchar(255)510
No
rownvarchar(255)510
Yes
vardescnvarchar(255)510
No
warnmaxnvarchar(16)32
Yes
warnminnvarchar(16)32
Yes
critmaxnvarchar(16)32
Yes
critminnvarchar(16)32
Yes
warnnvarchar(16)32
Yes
critnvarchar(16)32
Yes
maxnvarchar(16)32
Yes
minnvarchar(16)32
Yes
monitornvarchar(16)32
Yes
lagnvarchar(16)32
Yes
Permissions
TypeActionOwning Principal
GrantDeleteuniadmin
GrantInsertuniadmin
GrantReferencesuniadmin
GrantSelectuniadmin
GrantUpdateuniadmin
SQL Script
CREATE TABLE [dbo].[ucm_mib_reportdata]
(
[hostname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[mibname] [nvarchar] (48) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[instance] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tablegroup] [nvarchar] (48) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[tgdesc] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[row] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[vardesc] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[warnmax] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[warnmin] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[critmax] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[critmin] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[warn] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[crit] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[max] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[min] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[monitor] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lag] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[ucm_mib_reportdata] TO [uniadmin]
GRANT SELECT ON  [dbo].[ucm_mib_reportdata] TO [uniadmin]
GRANT INSERT ON  [dbo].[ucm_mib_reportdata] TO [uniadmin]
GRANT DELETE ON  [dbo].[ucm_mib_reportdata] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ucm_mib_reportdata] TO [uniadmin]
GO
Uses