CREATE TABLE [dbo].[nonhealth]
(
[server_addr] [int] NULL,
[intervaldatetime] [datetime] NULL,
[intervallength] [int] NULL,
[nprobesmonitoredperformance] [int] NULL,
[ninterfacesmonitoredperformance] [int] NULL,
[nprobesmonitoredavailability] [int] NULL,
[ninterfacesmonitoredavailability] [int] NULL,
[criticalduration] [int] NULL,
[majorduration] [int] NULL,
[minorduration] [int] NULL,
[warningduration] [int] NULL,
[criticalnumber] [int] NULL,
[majornumber] [int] NULL,
[minornumber] [int] NULL,
[warningnumber] [int] NULL,
[ntotalprobesnonavail] [int] NULL,
[ntotalinterfacesnonavail] [int] NULL,
[nsecondsprobesnonavail] [int] NULL,
[nsecondsinterfacesnonavail] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_nonhealth] ON [dbo].[nonhealth] ([intervaldatetime]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[nonhealth] TO [uniadmin]
GRANT INSERT ON [dbo].[nonhealth] TO [uniadmin]
GRANT DELETE ON [dbo].[nonhealth] TO [uniadmin]
GRANT UPDATE ON [dbo].[nonhealth] TO [uniadmin]
GRANT SELECT ON [dbo].[nonhealth] TO [uniuser]
GO
[dbo].[nonhealth]
