--
-- Host: localhost    Database: CARE
-- ------------------------------------------------------


--
-- Table structure for table `CPUUtil`
--

CREATE TABLE `CPUUtil` (
  `customer_id` varchar(255) DEFAULT NULL,
  `SID` varchar(255) DEFAULT NULL,
  `user` float DEFAULT NULL,
  `nice` float DEFAULT NULL,
  `sys` float DEFAULT NULL,
  `IOWait` float DEFAULT NULL,
  `steal` float DEFAULT NULL,
  `idle` float DEFAULT NULL,
  `sysname` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CPUUtil`
--

INSERT INTO `CPUUtil` VALUES ('c1','gbsadm',0,0,0,0,0,0,'SAP Java'),('c1','indadm',6.78,0,0.81,2.21,0.18,90.02,'integrtrdev'),('c1','inqadm',7.85,0,0.85,0.1,2.45,88.74,'integrtrqas');

--
-- Table structure for table `FSUsage`
--

CREATE TABLE `FSUsage` (
  `customer_id` varchar(255) DEFAULT NULL,
  `SID` varchar(255) DEFAULT NULL,
  `filesys` varchar(255) DEFAULT NULL,
  `size` float DEFAULT NULL,
  `used` float DEFAULT NULL,
  `avail` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `FSUsage`
--

INSERT INTO `FSUsage` VALUES ('c1','SAPSOLMAN72','devtmpfs-/dev',32,0,32),('c1','SAPSOLMAN72','tmpfs-/dev/shm',86,0,86),('c1','SAPSOLMAN72','tmpfs-/run',32,0,32),('c1','SAPSOLMAN72','tmpfs-/sys/fs/cgroup',32,0,32),('c1','SAPSOLMAN72','/dev/mapper/system-root-/',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/home',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/tmp',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/boot/grub2/x86_64-efi',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/.snapshots',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/usr/local',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/opt',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/srv',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/root',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/boot/grub2/i386-pc',60,35,25),('c1','SAPSOLMAN72','/dev/mapper/system-root-/var',60,35,25),('c1','SAPSOLMAN72','/dev/sda3-/usr/sap',66,21,45),('c1','SAPSOLMAN72','/dev/sda5-/hana',250,170,80),('c1','SAPSOLMAN72','tmpfs-/run/user/469',6.3,0,6.3),('c1','SAPSOLMAN72','tmpfs-/run/user/1001',6.3,0,6.3),('c1','SAPSOLMAN72','tmpfs-/run/user/468',6.3,0,6.3),('c1','SAPSOLMAN72','tmpfs-/run/user/1002',6.3,0,6.3),('c1','SAPSOLMAN72','tmpfs-/run/user/1003',6.3,0,6.3),('c1','SAPSOLMAN72','tmpfs-/run/user/1004',6.3,0,6.3);

--
-- Table structure for table `GetProcessList`
--

CREATE TABLE `GetProcessList` (
  `customer_id` varchar(255) DEFAULT NULL,
  `SID` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `dispstatus` varchar(255) DEFAULT NULL,
  `textstatus` varchar(255) DEFAULT NULL,
  `stime` varchar(255) DEFAULT NULL,
  `pid` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `GetProcessList`
--

INSERT INTO `GetProcessList` VALUES ('c1','Hana Instance','hdbdaemon','HDB Daemon','SAPControl-GREEN','Running','2020-10-17 08:13:05','5123'),('c1','Hana Instance','hdbcompileserver','HDB Compileserver','SAPControl-GREEN','Running','2020-10-17 08:13:25','5346'),('c1','Hana Instance','hdbindexserver','HDB Indexserver-HDB','SAPControl-GREEN','Running','2020-10-17 08:13:25','5397'),('c1','Hana Instance','hdbnameserver','HDB Nameserver','SAPControl-GREEN','Running','2020-10-17 08:13:06','5141'),('c1','Hana Instance','hdbpreprocessor','HDB Preprocessor','SAPControl-GREEN','Running','2020-10-17 08:13:25','5349'),('c1','Hana Instance','hdbwebdispatcher','HDB Web Dispatcher','SAPControl-GREEN','Running','2020-10-17 08:15:39','6200'),('c1','Hana Instance','hdbxsengine','HDB XSEngine-HDB','SAPControl-GREEN','Running','2020-10-17 08:13:25','5400'),('c1','ABAP PAS Instance','disp+work','Dispatcher','SAPControl-GREEN','Running','2020-10-17 08:18:48','12218'),('c1','ABAP PAS Instance','igswd_mt','IGS Watchdog','SAPControl-GREEN','Running','2020-10-17 08:18:48','12219'),('c1','ABAP PAS Instance','gwrd','Gateway','SAPControl-GREEN','Running','2020-10-17 08:19:06','13131'),('c1','ABAP PAS Instance','icman','ICM','SAPControl-GREEN','Running','2020-10-17 08:19:06','13132'),('c1','ABAP ASCS Instance','msg_server','MessageServer','SAPControl-GREEN','Running','2020-10-17 08:18:36','10749'),('c1','ABAP ASCS Instance','enserver','EnqueueServer','SAPControl-GREEN','Running','2020-10-17 08:18:36','10750'),('c1','Java PAS Instance','jstart','J2EE Server','SAPControl-GREEN','All processes running','2020-10-17 08:20:40','18928'),('c1','Java PAS Instance','igswd_mt','IGS Watchdog','SAPControl-GREEN','Running','2020-10-17 08:20:40','18929'),('c1','Java ASCS Instance','msg_server','MessageServer','SAPControl-GREEN','Running','2020-10-17 08:20:28','17391'),('c1','Java ASCS Instance','enserver','EnqueueServer','SAPControl-GREEN','Running','2020-10-17 08:20:28','17392'),('c1','Java ASCS Instance','gwrd','Gateway','SAPControl-GREEN','Running','2020-10-17 08:20:28','17394');

--
-- Table structure for table `GetSystemInstanceList`
--

CREATE TABLE `GetSystemInstanceList` (
  `customer_id` varchar(255) DEFAULT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `instance_nr` int DEFAULT NULL,
  `SID` varchar(255) DEFAULT NULL,
  `httpport` int DEFAULT NULL,
  `httpsport` int DEFAULT NULL,
  `startpriority` varchar(255) DEFAULT NULL,
  `features` varchar(255) DEFAULT NULL,
  `dispstatus` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `GetSystemInstanceList`
--

INSERT INTO `GetSystemInstanceList` VALUES ('c1','sapsolman72',0,'Hana Instance',50013,50014,'0.3','HDB|HDB_WORKER','SAPControl-GREEN'),('c1','SAPSOLMAN72',1,'ABAP PAS Instance',50113,50114,'3','ABAP|GATEWAY|ICMAN|IGS','SAPControl-GREEN'),('c1','SAPSOLMAN72',2,'ABAP ASCS Instance',50213,50214,'1','MESSAGESERVER|ENQUE','SAPControl-GREEN'),('c1','SAPSOLMAN72',4,'Java ASCS Instance',50413,50414,'1','GATEWAY|MESSAGESERVER|ENQUE','SAPControl-GREEN'),('c1','SAPSOLMAN72',3,'Java PAS Instance',50313,50314,'3','J2EE|ICMAN|IGS','SAPControl-GREEN');

--
-- Table structure for table `LockMon`
--

CREATE TABLE `LockMon` (
  `customer_id` varchar(255) DEFAULT NULL,
  `SID` varchar(255) DEFAULT NULL,
  `instance_name` varchar(255) DEFAULT NULL,
  `locks_now` int DEFAULT NULL,
  `locks_high` int DEFAULT NULL,
  `locks_max` int DEFAULT NULL,
  `locks_state` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `LockMon`
--

INSERT INTO `LockMon` VALUES ('c1','SAPSOLMAN72','ABAP ASCS Instance',2,1077,56415,'SAPControl-GREEN'),('c1','SAPSOLMAN72','Java ASCS Instance',5,61,56415,'SAPControl-GREEN');

--
-- Table structure for table `MemUtil`
--

CREATE TABLE `MemUtil` (
  `customer_id` varchar(255) DEFAULT NULL,
  `SID` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `used` varchar(255) DEFAULT NULL,
  `free` varchar(255) DEFAULT NULL,
  `shared` varchar(255) DEFAULT NULL,
  `cache` varchar(255) DEFAULT NULL,
  `available` varchar(255) DEFAULT NULL,
  `sysname` varchar(255) DEFAULT NULL,
  `port` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `MemUtil`
--

INSERT INTO `MemUtil` VALUES ('c1','gbsadm','Mem','15G','13G','1.7G','3.6G','6.7M','9.5G','SAP Java',51013),('c1','gbsadm','Swap','30G','0B','1.7G','0','0','0','SAP Java',51013),('c1','indadm','Mem','7.8G','6.2G','159M','1.1G','1.4G','243M','integrtrdev',50013),('c1','indadm','Swap','29G','10G','159M','0','0','0','integrtrdev',50013),('c1','indadm','Mem','7.8G','6.2G','158M','1.1G','1.4G','242M','integrtrdev',50113),('c1','indadm','Swap','29G','10G','158M','0','0','0','integrtrdev',50113),('c1','inqadm','Mem','7.8Gi','3.0Gi','245Mi','4.3Gi','4.5Gi','212Mi','integrtrqas',50013),('c1','inqadm','Swap','30Gi','7.6Gi','245Mi','0','0','0','integrtrqas',50013),('c1','inqadm','Mem','7.8Gi','3.0Gi','245Mi','4.3Gi','4.5Gi','212Mi','integrtrqas',50113),('c1','inqadm','Swap','30Gi','7.6Gi','245Mi','0','0','0','integrtrqas',50113);

--
-- Table structure for table `UpMon`
--

CREATE TABLE `UpMon` (
  `customer_id` varchar(255) DEFAULT NULL,
  `SID` varchar(255) DEFAULT NULL,
  `instance_name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `restime` int DEFAULT NULL,
  `quetime` int DEFAULT NULL,
  `utilization` int DEFAULT NULL,
  `NumberOfWpUD` int DEFAULT NULL,
  `ErrorsInWpUD` int DEFAULT NULL,
  `ErrorFreqInWpUD` float DEFAULT NULL,
  `EndedWpUD` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `UpMon`
--

INSERT INTO `UpMon` VALUES ('c1','SAPSOLMAN72','ABAP PAS Instance','PerformanceU1',108,100,0,1,0,0,0),('c1','SAPSOLMAN72','ABAP PAS Instance','PerformanceU2',176,0,0,1,0,0,0);

--
-- Table structure for table `responsetime`
--

CREATE TABLE `responsetime` (
  `customer_id` varchar(255) DEFAULT NULL,
  `SID` varchar(255) DEFAULT NULL,
  `instance_name` varchar(255) DEFAULT NULL,
  `restime` int DEFAULT NULL,
  `restimedia` int DEFAULT NULL,
  `restimediarfc` int DEFAULT NULL,
  `restimehttp` int DEFAULT NULL,
  `ferestime` int DEFAULT NULL,
  `quetime` int DEFAULT NULL,
  `loadgentime` int DEFAULT NULL,
  `rolltime` int DEFAULT NULL,
  `dbreqtime` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `responsetime`
--

INSERT INTO `responsetime` VALUES ('c1','SAPSOLMAN72','ABAP PAS Instance',176,490,3,0,83,0,2,0,115);


