home *** CD-ROM | disk | FTP | other *** search
/ PC Answers 2003 September / PC Answers September 2003.iso / Software / trial / MonitorIT 5.2.06 / monitorit_fullsetup.exe / data1.cab / Database / CreateProcessLogTable.sql next >
Encoding:
Text File  |  2003-06-24  |  1.4 KB  |  27 lines
  1. CREATE TABLE [ProcessCheckLogData] (
  2.     [ID] [int] IDENTITY (1, 1) NOT NULL ,
  3.     [MonitorID] [int] NULL CONSTRAINT [DF__Temporary__Monit__20C1E124] DEFAULT (0),
  4.     [ComputerID] [int] NULL CONSTRAINT [DF__Temporary__Compu__21B6055D] DEFAULT (0),
  5.     [AlertGroupID] [int] NULL CONSTRAINT [DF__Temporary__Alert__22AA2996] DEFAULT (0),
  6.     [CheckDT] [datetime] NULL ,
  7.     [ProcessName] [nvarchar] (255) NULL ,
  8.     [CPUPerCent] [int] NULL CONSTRAINT [DF__Temporary__CPUPe__239E4DCF] DEFAULT (0),
  9.     [WSMemory] [int] NULL CONSTRAINT [DF__Temporary__WSMem__24927208] DEFAULT (0),
  10.     [PPMemory] [int] NULL CONSTRAINT [DF__Temporary__PPMem__25869641] DEFAULT (0),
  11.     [NPPMemory] [int] NULL CONSTRAINT [DF__Temporary__NPPMe__267ABA7A] DEFAULT (0),
  12.     [PFMemory] [int] NULL CONSTRAINT [DF__Temporary__PFMem__276EDEB3] DEFAULT (0),
  13.     [Status] [int] NULL CONSTRAINT [DF__Temporary__Statu__286302EC] DEFAULT (0),
  14.     [CPUMax] [int] NULL CONSTRAINT [DF__Temporary__CPUMa__29572725] DEFAULT (0),
  15.     [MemoryMax] [int] NULL CONSTRAINT [DF__Temporary__Memor__2A4B4B5E] DEFAULT (0),
  16.     [PPMax] [int] NULL CONSTRAINT [DF__Temporary__PPMax__2B3F6F97] DEFAULT (0),
  17.     [NPPMax] [int] NULL CONSTRAINT [DF__Temporary__NPPMa__2C3393D0] DEFAULT (0),
  18.     [PFMax] [int] NULL CONSTRAINT [DF__Temporary__PFMax__2D27B809] DEFAULT (0),
  19.     [MiscParms] [ntext] NULL ,
  20.     CONSTRAINT [aaaaaProcessCheckLogData_PK] PRIMARY KEY  NONCLUSTERED 
  21.     (
  22.         [ID]
  23.     )  ON [PRIMARY] 
  24. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  25. GO
  26.  
  27.