-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsimssampledb.txt
124 lines (108 loc) · 5.52 KB
/
simssampledb.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
--
-- Database: `simssampledb`
--
-- --------------------------------------------------------
--
-- Table structure for table `members`
--
CREATE TABLE IF NOT EXISTS `members` (
`MemId` int(5) NOT NULL AUTO_INCREMENT,
`UserName` varchar(25) NOT NULL,
`Password` varchar(20) NOT NULL,
`Type` varchar(20) NOT NULL,
`Region` varchar(10) NOT NULL,
PRIMARY KEY (`MemId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `members`
--
INSERT INTO `members` (`MemId`, `UserName`, `Password`, `Type`, `Region`) VALUES
(1, 'furqan.aziz', '123456', 'ACTAdmin', 'HQ');
-- --------------------------------------------------------
--
-- Table structure for table `servername`
--
CREATE TABLE IF NOT EXISTS `servername` (
`SrNo` int(11) NOT NULL AUTO_INCREMENT,
`ServerName` varchar(15) NOT NULL,
`EntryDate` date NOT NULL,
PRIMARY KEY (`SrNo`),
UNIQUE KEY `ServerName` (`ServerName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `servername`
--
INSERT INTO `servername` (`SrNo`, `ServerName`, `EntryDate`) VALUES
(1, '10.86.0.75', '2013-11-13'),
(2, '10.86.0.66', '2013-11-05'),
(3, '10.86.0.61', '2013-11-05'),
(4, '10.86.0.78', '2013-11-03'),
(5, '10.86.0.77', '2013-11-03'),
(6, '10.86.0.44', '2013-11-12');
-- --------------------------------------------------------
--
-- Table structure for table `statstracker`
--
CREATE TABLE IF NOT EXISTS `statstracker` (
`SrNo` int(11) NOT NULL AUTO_INCREMENT,
`ServerName` varchar(15) NOT NULL,
`HiMemUti` double NOT NULL,
`AvgMemUti` double NOT NULL,
`HiCpuUti` double NOT NULL,
`AvgCpuUti` double NOT NULL,
`HiIOPerSec` double NOT NULL,
`AvgIOPerSec` double NOT NULL,
`HiDiskUsage` double NOT NULL,
`AvgDsikUsage` double NOT NULL,
`EntryBy` varchar(15) NOT NULL,
`EntryDate` date NOT NULL,
PRIMARY KEY (`SrNo`),
UNIQUE KEY `SrNo` (`SrNo`),
FULLTEXT KEY `ServerName` (`ServerName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=44 ;
--
-- Dumping data for table `statstracker`
--
INSERT INTO `statstracker` (`SrNo`, `ServerName`, `HiMemUti`, `AvgMemUti`, `HiCpuUti`, `AvgCpuUti`, `HiIOPerSec`, `AvgIOPerSec`, `HiDiskUsage`, `AvgDsikUsage`, `EntryBy`, `EntryDate`) VALUES
(1, '10.86.0.44', 95, 90, 88, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-10'),
(2, '10.86.0.44', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-09'),
(3, '10.86.0.44', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-08'),
(4, '10.86.0.44', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-03'),
(5, '10.86.0.44', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-04'),
(6, '10.86.0.44', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-05'),
(7, '10.86.0.44', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-06'),
(8, '10.86.0.44', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-07'),
(10, '10.86.0.64', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-08'),
(11, '10.86.0.64', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-01'),
(12, '10.86.0.64', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-02'),
(13, '10.86.0.64', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-03'),
(14, '10.86.0.64', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-04'),
(15, '10.86.0.64', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-05'),
(16, '10.86.0.64', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-06'),
(17, '10.86.0.64', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-07'),
(18, '10.86.0.94', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-08'),
(19, '10.86.0.94', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-01'),
(20, '10.86.0.94', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-02'),
(21, '10.86.0.94', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-03'),
(22, '10.86.0.94', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-04'),
(23, '10.86.0.94', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-05'),
(24, '10.86.0.94', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-06'),
(25, '10.86.0.94', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-07'),
(26, '10.86.0.33', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-08'),
(27, '10.86.0.33', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-01'),
(28, '10.86.0.33', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-02'),
(29, '10.86.0.33', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-03'),
(30, '10.86.0.33', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-04'),
(31, '10.86.0.33', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-05'),
(32, '10.86.0.33', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-06'),
(33, '10.86.0.33', 95, 90, 92, 88, 98, 94, 97, 76, 'furqan.aziz', '2013-11-07'),
(34, '10.86.0.44', 50, 50, 50, 50, 50, 50, 50, 50, 'furqan.aziz', '2013-11-12'),
(35, '10.86.0.44', 60, 50, 60, 50, 60, 50, 60, 50, 'furqan.aziz', '2013-11-11'),
(36, '10.86.0.75', 96, 90, 95, 90, 94, 90, 98, 88, 'furqan.aziz', '2013-11-12'),
(37, '10.86.0.75', 94, 88, 93, 89, 90, 88, 90, 85, 'furqan.aziz', '2013-11-11'),
(38, '10.86.0.75', 94, 88, 90, 89, 90, 88, 90, 85, 'furqan.aziz', '2013-11-10'),
(39, '10.86.0.75', 94, 88, 88, 89, 90, 88, 90, 85, 'furqan.aziz', '2013-11-09'),
(40, '10.86.0.75', 94, 88, 80, 89, 90, 88, 90, 85, 'furqan.aziz', '2013-11-08'),
(41, '10.86.0.75', 94, 88, 78, 89, 90, 88, 90, 85, 'furqan.aziz', '2013-11-07'),
(42, '10.86.0.75', 94, 88, 76, 89, 90, 88, 90, 85, 'furqan.aziz', '2013-11-06'),
(43, '10.86.0.75', 50, 50, 60, 78, 67, 78, 67, 56, 'furqan.aziz', '2013-11-13');