CREATE TABLE [dbo].[wtDRO_PLVSerial]
(
[uuid] [binary] (16) NOT NULL,
[Platform_Name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Platform_Type] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IO1] [float] NULL,
[IO2] [float] NULL,
[IO3] [float] NULL,
[IO4] [float] NULL,
[IO1_Min] [float] NULL,
[IO1_Max] [float] NULL,
[IO1_COEF] [float] NULL,
[IO2_Min] [float] NULL,
[IO2_Max] [float] NULL,
[IO2_COEF] [float] NULL,
[IO3_Min] [float] NULL,
[IO3_Max] [float] NULL,
[IO3_COEF] [float] NULL,
[IO4_Min] [float] NULL,
[IO4_Max] [float] NULL,
[IO4_COEF] [float] NULL,
[Disk1] [float] NULL,
[Disk2] [float] NULL,
[Disk1_Min] [float] NULL,
[Disk1_Max] [float] NULL,
[Disk1_COEF] [float] NULL,
[Disk2_Min] [float] NULL,
[Disk2_Max] [float] NULL,
[Disk2_COEF] [float] NULL,
[Mem2] [float] NULL,
[Mem3] [float] NULL,
[Mem2_Min] [float] NULL,
[Mem2_Max] [float] NULL,
[Mem2_COEF] [float] NULL,
[Mem3_Min] [float] NULL,
[Mem3_Max] [float] NULL,
[Mem3_COEF] [float] NULL,
[CPU2] [float] NULL,
[CPU2_Min] [float] NULL,
[CPU2_Max] [float] NULL,
[CPU2_COEF] [float] NULL,
[Net1] [float] NULL,
[Net2] [float] NULL,
[Net1_Min] [float] NULL,
[Net1_Max] [float] NULL,
[Net1_COEF] [float] NULL,
[Net2_Min] [float] NULL,
[Net2_Max] [float] NULL,
[Net2_COEF] [float] NULL,
[Manage_Platform] [int] NULL,
[Free_Memory] [int] NULL,
[DRSL] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DRSLG] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Analysis_Interval] [int] NULL,
[Poll_Interval] [int] NULL,
[HMC_Name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Memory_Usage] [float] NULL,
[CPU_Usage] [float] NULL,
[Capacity_PLPAR] [float] NULL,
[Crit_Capacity_Plat_Thresh] [int] NULL,
[Min_Capacity_Plat_Thresh] [int] NULL,
[DebugLevel] [int] NULL,
[Console_Message_Level] [int] NULL,
[LogFileSize] [int] NULL,
[Number_Of_CPUs] [int] NULL,
[Plat_Free_LMBs] [int] NULL,
[Plat_Total_LMBs] [int] NULL,
[SYS_IP_Address] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Capacity_On_Demand_CPU_Capable] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Capacity_On_Demand_MEM_Capable] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OS400_Capable] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Micro_LPAR_Capable] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Virtual_IO_Server_Capable] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LPAR_Property1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LPAR_Property2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LPAR_Property3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LPARName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AdapterType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RemoteLPARID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RemoteLPARName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RemoteLPARSlotNum] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Required] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SupportsHMC] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LPARID] [int] NULL,
[SlotNum] [int] NULL,
[VPM_Property1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO