· 5 years ago · Feb 10, 2020, 07:38 PM
1-- MySQL dump 10.13 Distrib 5.1.73, for redhat-linux-gnu (x86_64)
2--
3-- Host: localhost Database: aos_reporting
4-- ------------------------------------------------------
5-- Server version 5.1.73
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `daily_rpt`
20--
21
22DROP TABLE IF EXISTS `daily_rpt`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `daily_rpt` (
26 `dr_id` int(11) NOT NULL AUTO_INCREMENT,
27 `dr_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
28 `dr_institution` varchar(30) DEFAULT NULL,
29 `dr_service` varchar(30) DEFAULT NULL,
30 `dr_support_type` varchar(30) DEFAULT NULL,
31 `dr_description` varchar(200) DEFAULT NULL,
32 `dr_status` varchar(20) DEFAULT NULL,
33 `dr_usr_id` int(11) DEFAULT NULL,
34 PRIMARY KEY (`dr_id`),
35 KEY `fk_usr_id` (`dr_usr_id`)
36) ENGINE=MyISAM AUTO_INCREMENT=254 DEFAULT CHARSET=latin1;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `daily_rpt`
41--
42
43LOCK TABLES `daily_rpt` WRITE;
44/*!40000 ALTER TABLE `daily_rpt` DISABLE KEYS */;
45INSERT INTO `daily_rpt` VALUES (1,'2019-09-23 15:40:30','AOS','Cloud','Proactive support','Cloud services health check ( VCenter, CIAC, UCSManager)','Closed',7),(2,'2019-09-23 15:40:30','AOS','Cloud','Proactive support','Cloud Service Monitoring (configured nagiosxi and added new hosts)','Closed',7),(3,'2019-09-23 15:40:30','AOS','Cloud','Support request','Change host-names of Smart-Admin servers / provided guidance.','Closed',7),(4,'2019-09-26 06:53:39','ILPD','BaaS','Support request','Restore ILDP server on 20th / Done, waiting for feedback','Pending on Customer',7),(76,'2019-09-24 16:23:21','AOS','BaaS','Proactive support','check that critical servers backup were successful\r\n','Closed',8),(11,'2019-09-23 16:16:09','sol++','Web and mail hosting','Support request','domain name renew','Closed',16),(12,'2019-09-23 16:16:09','Scon','Web and mail hosting','Support request','domain name renew','Closed',16),(13,'2019-09-23 16:16:09','Ircad','Web and mail hosting','Support request','outlook/Thunderbird setup','Pending on Customer',16),(14,'2019-09-23 16:16:09','RLRC','Web and mail hosting','Support request','restore email backup','Closed',16),(15,'2019-09-23 16:16:09','RALC','Web and mail hosting','Support request','website down','Closed',16),(16,'2019-09-23 16:16:09','RMB','Web and mail hosting','Support request','website error','Closed',16),(17,'2019-09-23 16:16:09','RCAA','Web and mail hosting','Support request','Map domain name to IP','Closed',16),(18,'2019-09-23 16:16:09','AOS','Web and mail hosting','Proactive support','Check server resources usage and manage ironport quarantine','Closed',16),(21,'2019-09-23 16:28:42','AOS','BaaS','Proactive support','Daily checks of backups for critical servers ','Closed',8),(22,'2019-09-23 16:28:42','AOS','BaaS','Proactive support','Check on nimble storage and 3PAR Storage for both main and DR sites\r\n','Closed',8),(23,'2019-09-23 16:28:42','AOS','BaaS','Proactive support','Partial manual backup of Kalisimbi server','Closed',8),(24,'2019-09-23 16:28:42','AOS','BaaS','Proactive support','Manual backup of imparage server\r\n','Closed',8),(25,'2019-09-23 16:28:42','AOS','BaaS','Support request','Manual backup of rebero server','Closed',8),(26,'2019-09-23 16:28:42','MINAFFET','BaaS','Support request','Manual backup of minaffet-exch-0.minaffet.gov.local server','Closed',8),(27,'2019-09-23 16:28:42','RISA','BaaS','Support request','Restore snapshot of RISA-ICTSKILLS-01 server ','0',8),(75,'2019-09-24 15:47:11','AOS','Cloud','Proactive support','Informed Smart Admin team about disabled monitoring services','Pending on Customer',7),(154,'2019-09-26 16:04:01','Rightseat','Web and mail hosting','Support request','can not access backend','Pending on AOS',16),(31,'2019-09-23 16:30:34','AOS','Web and mail hosting','Proactive support','Free space on Inzovu and add space on Inzovu backup','Closed',17),(32,'2019-09-23 16:30:34','AOS','Web and mail hosting','Proactive support','Start fixing Vulnerabilities assessment ','Pending on AOS',17),(74,'2019-09-24 15:47:11','RWFA','Cloud','Support request','Upgrade DFMP Server to CentOS 7 ','Closed',7),(40,'2019-09-23 16:47:42','RCB','Cloud','Support request','Allow communication between RCB and RDB-SW so that RCB website can be accessible','Closed',15),(41,'2019-09-23 16:47:42','AOS','Network','Proactive support','Daily check ','Closed',15),(42,'2019-09-23 16:47:42','AOS','Network','Proactive support','Manual backup HQ config files for Access01 &02, Firewall\r\n','Closed',15),(43,'2019-09-23 16:47:42','BCS','Colocation','Support request','Create Vlan 262 and add vlan to trunk interfaces','Closed',15),(44,'2019-09-26 06:53:39','ILPD','Cloud','Support request','Permit ILDP Public IP to access and be accessible by Rwanda networks','Closed',15),(45,'2019-09-23 16:47:42','STATISTICS','Cloud','Support request','Site to site VPN new Encryption domains with Irembo','Closed',15),(46,'2019-09-23 16:47:42','RCAA','Cloud','Support request','Static NAT and Open ports','Pending on Customer',15),(47,'2019-09-23 16:47:42','GALAXY-GROUP','Cloud','Support request','Site to Site VPN with MTN add new Encryptions','Closed',15),(51,'2019-09-23 16:53:10','AOS','Facility','Support request','IDC Normal daily activities .\r\n\r\n','Closed',4),(52,'2019-09-23 16:53:10','AOS','Colocation','Support request','Have facilitated IDC Colocation Customers.\r\nHave also started working on the initialization of the request for implementing civil work and colocation services for AOS data center. ','Pending on AOS',4),(53,'2019-09-23 16:53:10','AOS','Facility','Support request','* Have made a followup with VERTIV/OEM of IDC UPS to support us on the issue we have for now but \r\nthey have told me wait till kenya office get the feedback from South AFRICA.','Pending on Customer',4),(54,'2019-09-23 16:53:10','RISA','Facility','Proactive support','Have worked with RISA team on facilities maintenance inspection.\r\n','Closed',4),(73,'2019-09-24 15:47:11','AOS','Cloud','Support request','Disconnect MYICT customer from Regular Bronze Small services','Closed',7),(61,'2019-09-23 18:51:08','AOS','Cloud','Proactive support','Risk Treatment ','Pending on AOS',1),(72,'2019-09-24 15:47:11','AOS','Cloud','Proactive support','Cloud services Monitoring ( configured nagios core and removed unresponding hosts','Closed',7),(71,'2019-09-24 15:47:11','AOS','Cloud','Proactive support','Cloud services health check (VCenter, CIAC )','Closed',7),(77,'2019-09-24 16:23:21','AOS','BaaS','Proactive support','Partial manual backup of Kalisimbi server\r\n','Closed',8),(78,'2019-09-24 16:23:21','AOS','BaaS','Proactive support','Manual backup of inyange server\r\n','Closed',8),(79,'2019-09-24 16:23:21','AOS','BaaS','Proactive support','Manual backup of imparage server','Closed',8),(80,'2019-09-24 16:23:21','AOS','BaaS','Proactive support','Manual backup of rebero server','Closed',8),(81,'2019-09-24 16:23:21','AOS','BaaS','Proactive support','Check on nimble storage and 3PAR Storage for both main and DR sites','Closed',8),(82,'2019-09-24 16:23:21','AOS','BaaS','Proactive support','Bring back silver and platinum schedules and retention on Data domain','Closed',8),(83,'2019-09-24 16:23:21','AOS','BaaS','Proactive support','Training on Veeam Backup and replication','Closed',8),(84,'2019-09-24 16:23:21','MYICT','BaaS','Support request','Disable myict server on backup services','Closed',8),(85,'2019-09-24 16:23:21','RWFA','Cloud','Support request','Reinstall server with centos7 and register it on backup services','Closed',8),(86,'2019-09-24 16:29:07','AOS','Network','Proactive support','Manual backup HQ config files for Access01 &02, Firewall','Closed',15),(87,'2019-09-24 16:29:07','AOS','Network','Proactive support','Manual backup DR config files for Access01','Closed',15),(88,'2019-09-24 16:29:07','AOS','Network','Proactive support','Daily check','Closed',15),(89,'2019-09-24 16:29:07','GALAXY-GROUP','Cloud','Support request','Troubleshoot site to site VPN','Closed',15),(90,'2019-09-24 16:29:07','AOS','Network','Proactive support','Risk treatment (Search how to disable weak encryption algorithm)','Pending on AOS',15),(91,'2019-09-24 16:29:07','AOS','Network','Proactive support','High availability on aggregation switches','Pending on AOS',15),(92,'2019-09-24 16:29:45','RPPA','Web and mail hosting','Support request','Issue sending/receiving using Outlook/Zimbra','Closed',17),(93,'2019-09-24 16:29:45','REB','Web and mail hosting','Support request','Restoreb yesterday database backup','Closed',17),(94,'2019-09-24 16:29:45','RICTA','Cloud','Support request','Reboot servers WHM1 and WHM2','Closed',17),(95,'2019-09-24 16:29:45','RCAA','Cloud','Support request','Issue accessing server on public IP/ NGNIX configurations','Closed',17),(96,'2019-09-24 16:29:45','AOS','Web and mail hosting','Proactive support','Clear some of the errors on cPanel servers and backups','Pending on AOS',17),(97,'2019-09-24 16:29:45','AOS','DNS','Proactive support','Training on EPP system','Pending on AOS',17),(98,'2019-09-24 16:45:23','AOS','Web and mail hosting','Proactive support','Checked spam to all cPanel mail servers and informed our sales team about MIFIMAR used Disk which was is full.','Closed',14),(99,'2019-09-24 16:45:23','AOS/CUR','DNS','Support request','Domain Registration Form','Closed',14),(100,'2019-09-24 16:45:23','REMA','Web and mail hosting','Support request','Password reset ','Closed',14),(101,'2019-09-24 16:45:23','NIDA','Web and mail hosting','Support request','Sub-domain request','Closed',14),(102,'2019-09-24 17:38:02','AOS','Facility','Support request','Normal daily activities.','Closed',4),(103,'2019-09-24 17:38:02','AOS','Facility','Support request','Have started working with AOS vendor to install camera at DR SITE.','Pending on AOS',4),(104,'2019-09-24 17:38:02','AOS','Colocation','Support request','Facilitated IDC colocated customers.','Closed',4),(105,'2019-09-24 18:52:32','AOS','Cloud','Proactive support','Veeam Backup and replication training ','Pending on AOS',1),(106,'2019-09-24 18:52:32','AOS','Cloud','Proactive support','Cloud Risk treatment ','Pending on AOS',1),(107,'2019-09-24 18:52:32','AOS','Cloud','Proactive support','Single sign-on (domain) Implementation','Pending on AOS',1),(108,'2019-09-25 15:39:47','AOS','Cloud','Proactive support','Cloud services health check (Vcenter, CIAC)','Closed',7),(109,'2019-09-25 15:39:47','AOS','Cloud','Proactive support','Cloud service monitoring (provided guidance on nagios configuration)','Closed',7),(110,'2019-09-25 15:39:47','TIGERSOFT','Cloud','Support request','Upgrade tigersoft OS to Windows Server 2012','Closed',7),(111,'2019-09-25 15:39:47','HARAMBEE','Cloud','Support request','Provided guidance on how to connect to a VM after being connected in VPN','Closed',7),(112,'2019-09-25 15:39:47','AFFLIX','Cloud','Support request','Requested a public IP / handled to Simon','Closed',7),(113,'2019-09-25 15:39:47','MININFRA','Cloud','Support request','Request to reset / reinstall the server ','Closed',7),(114,'2019-09-25 15:39:47','AOS','Cloud','Support request','Scan GWSAS Mobile-Gateway server with attached antivirus','Closed',7),(115,'2019-09-25 15:39:47','AGACIRO','Cloud','Support request','Migrating backup data to a provided external hard disk','Closed',7),(116,'2019-09-25 16:00:15','AOS','Network','Proactive support','Manual backup HQ config files for Access01 &02, Firewall','Closed',15),(117,'2019-09-25 16:00:15','AOS','Network','Proactive support','Manual backup DR config files for Access01','Closed',15),(118,'2019-09-25 16:00:15','AOS','Network','Proactive support','Daily check','Closed',15),(119,'2019-09-25 16:00:15','STATISTICS','Cloud','Support request','Site to site VPN with new encryptions','Closed',15),(120,'2019-09-25 16:00:15','AFFLIX','Cloud','Support request','Static NAT and open ports','Closed',15),(121,'2019-09-26 06:53:39','ILPD','Cloud','Support request','Troubleshoot ACL for restriction ','Closed',15),(122,'2019-09-25 16:00:15','RICTA','Cloud','Support request','ACL to allow remote access to their servers','Closed',15),(123,'2019-09-25 16:00:15','BCS','Colocation','Support request','Troubleshoot network with KTRN','Closed',15),(124,'2019-09-25 16:00:15','AOS','Network','Proactive support','Search for removing weak encryption algorith','Pending on AOS',15),(125,'2019-09-25 16:06:54','AOS','Web and mail hosting','Proactive support','Checked spam to all cPanel mail servers ','Closed',14),(126,'2019-09-25 16:06:54','AOS','Web and mail hosting','Proactive support','Mail Queue_197.243.16.109:\r\nUpdated storage quota for “k.aime@asarwanda.rw\" user and manually delivery mails in queue','Closed',14),(127,'2019-09-25 16:06:54','AOS','Web and mail hosting','Proactive support','Mail Queue_197.243.16.118:\r\nUpdated storage quota for “sylvie.kawera@cndp.org.rw\" user and manually delivery mails in queue','Closed',14),(128,'2019-09-25 16:06:54','AOS','Web and mail hosting','Proactive support','Shift Plan_October,2019:\r\nPrepared the shift Plan for october,2019 and shared with Datacenter Team ','Closed',14),(129,'2019-09-25 16:06:54','REB','DNS','Support request','Request to host Web Application of Repair Asset MIS system:\r\nMapped icte.reb.rw subdomain to 197.243.16.130 ','Closed',14),(130,'2019-09-25 16:06:54','RDB','Web and mail hosting','Support request','Request for support:\r\nTroubleshooted on musanze.lmis.gov.rw subdomain availability issue and advised the RB to check on musanze.lmis.gov.rw database name and password','Closed',14),(131,'2019-09-25 16:06:54','RAB','DNS','Support request','Requesting of SSL Certificate:\r\nMapped arpms.rab.gov.rw subdomain to 197.243.42.10 ','Closed',14),(132,'2019-09-25 16:06:54','CNLG','Web and mail hosting','Support request','outlook_problem\r\nThroubleshooted on send and receive mail issue through CNLG outlook account.','Pending on Customer',14),(133,'2019-09-25 16:09:46','AOS','BaaS','Proactive support','Check that critical servers backup were successful','Closed',8),(134,'2019-09-25 16:09:46','AOS','BaaS','Proactive support','Partial manual backup of kalisimbi server','Closed',8),(135,'2019-09-25 16:09:46','AOS','BaaS','Proactive support','Partial manual backup of rebero server','Closed',8),(136,'2019-09-25 16:09:46','AOS','BaaS','Proactive support','Manual backup of inyange server','Closed',8),(137,'2019-09-25 16:09:46','AOS','BaaS','Proactive support','Check on nimble storage and 3PAR Storage for both main and DR sites\r\n','Closed',8),(138,'2019-09-25 16:09:46','RISA','BaaS','Support request','Provide access to the restored server of RISA','Closed',8),(139,'2019-09-25 16:15:41','AOS','BaaS','Proactive support','Check that critical servers backup were successful','Closed',8),(140,'2019-09-25 16:15:41','AOS','BaaS','Proactive support','Partial manual backup of kalisimbi server','Closed',8),(141,'2019-09-25 16:15:41','AOS','BaaS','Proactive support','Partial manual backup of rebero server','Closed',8),(142,'2019-09-25 16:15:41','AOS','BaaS','Proactive support','Manual backup of inyange server','Closed',8),(143,'2019-09-25 16:15:41','AOS','BaaS','Proactive support','Check on nimble storage and 3PAR Storage for both main and DR sites\r\n','Closed',8),(144,'2019-09-25 16:15:41','RISA','BaaS','Support request','Provide accessibility of the restored server','Closed',8),(145,'2019-09-25 16:15:41','ILPD','BaaS','Support request','clone their server snapshot for restoration','Closed',8),(146,'2019-09-25 16:50:33','AOS','Web and mail hosting','Proactive support','Approve change requests','Closed',17),(147,'2019-09-25 16:50:33','AOS','Web and mail hosting','Proactive support','Correct errors on hosting servers','Pending on AOS',17),(148,'2019-09-25 16:50:33','AOS','Web and mail hosting','Proactive support','Learn AOS zimbra management','Closed',17),(149,'2019-09-25 17:51:53','AOS','Cloud','Proactive support','Single sign-on (domain controller)','Pending on AOS',1),(150,'2019-09-25 17:51:53','NPPA','Cloud','Support request','unable to access one of their server ','Closed',1),(151,'2019-09-25 17:51:53','GW SAS','Cloud','Proactive support','Configure monitoring of GW SAS Hosts and services ','Pending on AOS',1),(152,'2019-09-25 18:28:51','AOS','Facility','Support request','Normal Daily ACtivity.','Closed',4),(153,'2019-09-25 18:28:51','AOS','Facility','Support request','Installation of cameras at DR site.','Pending on AOS',4),(155,'2019-09-26 16:04:01','AOS','Web and mail hosting','Proactive support','monitor server resources usage and services status','Closed',16),(156,'2019-09-26 16:04:01','AOS','Web and mail hosting','Proactive support','Install SSL certificate on 197.243.16.104','Closed',16),(157,'2019-09-26 16:04:01','AOS','Web and mail hosting','Support request','create user mail account','Closed',16),(158,'2019-09-26 16:04:01','Minagri','Web and mail hosting','Support request','create Subdomain','Closed',16),(159,'2019-09-26 16:04:01','MNI','Web and mail hosting','Support request','map domain to IP','Pending on Customer',16),(160,'2019-09-26 16:04:01','AOS','Web and mail hosting','Proactive support','participate to EPP training','Closed',16),(161,'2019-09-26 16:08:15','AOS','BaaS','Proactive support','Check that critical servers backup were successful','Closed',8),(162,'2019-09-26 16:08:15','AOS','BaaS','Proactive support','Partial manual backup of kalisimbi server','Closed',8),(163,'2019-09-26 16:08:15','AOS','BaaS','Proactive support','Manual backup of imparage server','Closed',8),(164,'2019-09-26 16:08:15','AOS','BaaS','Proactive support','Increase datastore capacity ','Closed',8),(165,'2019-09-26 16:08:15','AOS','Cloud','Support request','Create a new server for smart admin and register it on backup services','Closed',8),(166,'2019-09-26 16:08:15','RHA','Cloud','Support request','Create a new server for RHA and register it on backup services','Closed',8),(167,'2019-09-26 16:08:15','ZENYSIS','BaaS','Support request','Register new server on backup services','Closed',8),(168,'2019-09-26 16:08:15','CONNECTED-ENERGY','BaaS','Support request','Create new domain and user on avamar','Closed',8),(169,'2019-09-26 16:08:15','MINAFFET','BaaS','Proactive support','Manual backup of minaffet-exch-0.minaffet.gov.local server','Closed',8),(170,'2019-09-26 16:08:15','FARG','BaaS','Proactive support','Manual backup of FARG Servers','Closed',8),(171,'2019-09-26 17:05:22','AOS','Network','Proactive support','Manual backup HQ config files for Access01 &02, Firewall\r\n','Closed',15),(172,'2019-09-26 17:05:22','AOS','Network','Proactive support','Manual backup DR config files for Access01\r\n','Closed',15),(173,'2019-09-26 17:05:22','AOS','Network','Proactive support','Daily check\r\n','Closed',15),(174,'2019-09-26 17:05:22','SMART-ADMIN','Cloud','Support request','Open port on SMART-ADMIN server','Closed',15),(175,'2019-09-26 17:05:22','ILDP','Cloud','Support request','Troubleshoot network for accessibility and open ports','Closed',15),(176,'2019-09-26 17:05:22','RISA ()SMART-ADMIN)','Cloud','Support request','Open ports on the Firewall','Closed',15),(177,'2019-09-26 17:05:22','IREMBO','Cloud','Support request','Preparation of IP addresses to be used by new Customer ','Pending on AOS',15),(178,'2019-09-26 17:05:22','AFRICABET','Cloud','Support request','Troubleshoot network for bandwidth improvement ','Pending on AOS',15),(179,'2019-09-26 17:05:22','AOS','Network','Proactive support','Prepare disable weak encryption algorithm','Pending on AOS',15),(180,'2019-09-26 17:05:22','BCS','Colocation','Support request','Troubleshoot Vlan accessibility using a different Link','Closed',15),(181,'2019-09-26 17:46:13','AOS','Web and mail hosting','Proactive support','Checked spam to all cPanel mail servers and Ironport','Closed',14),(182,'2019-09-26 17:46:13','AOS','Web and mail hosting','Proactive support','Due to the Iron port configurations, I tried to filter and send some blocked emails','Closed',14),(183,'2019-09-26 17:46:13','AOS','Web and mail hosting','Proactive support','Mail Queue_197.243.16.116\r\nUpdated storage quota for \"david.museruka@statistics.gov.rw and n.felix@naeb.gov.rw\" users and manually delivery mails in queue','Closed',14),(184,'2019-09-26 17:46:13','AOS','Web and mail hosting','Proactive support','Mail Queue_197.243.16.118\r\nUpdated storage quota for \"denise.umutoni@cheno.gov.rw\" user and manually delivery mails in queue','Closed',14),(185,'2019-09-26 17:46:13','RLMA','DNS','Support request','Requesting domain mapping to public Ip:\r\nMapp rwandalanddashboard.rlmua.rw to 197.243.65.146','Closed',14),(186,'2019-09-26 17:46:13','RISA','DNS','Support request','DNS record A\r\nMapp gasabo.district.test.risa.rw to 1197.243.21.239','Closed',14),(187,'2019-09-26 17:58:03','AOS','Web and mail hosting','Proactive support','Approve change request','Closed',17),(188,'2019-09-26 17:58:03','Rwanda Connect','SSL','Support request','Acquire SSL certificate for rwandakonnect.rw','Closed',17),(189,'2019-09-26 17:58:03','AOS','Web and mail hosting','Support request','Block spams by creating a dictionary and block incoming mails using the dictionary','Closed',17),(190,'2019-09-26 17:58:03','Mifotra','SSL','Proactive support','Install SSL certificate','Closed',17),(191,'2019-09-26 17:58:03','Kigali City','SSL','Proactive support','Install SSL certificate','Closed',17),(192,'2019-09-26 17:58:03','AOS','Web and mail hosting','Proactive support','Download Cisco ESA virtual appliance and prepare for installation','Pending on AOS',17),(193,'2019-09-26 19:14:16','AOS','Cloud','Proactive support','Cloud Services health check (VCenter, CIAC, UCSManager)','Closed',7),(194,'2019-09-26 19:14:16','AOS','Cloud','Proactive support','Cloud Services Monitoring (Configured GWSAS Serves new services on nagios)','Pending on AOS',7),(195,'2019-09-26 19:14:16','ZENYSIS','Cloud','Support request','Delete and create a new server with ubuntu 18.04 Lts OS','Closed',7),(196,'2019-09-26 19:14:16','AOS','Cloud','Proactive support','Install an Ubuntu test server','Closed',7),(197,'2019-09-26 19:14:16','CONNECTED ENERGY','Cloud','Support request','Onboard a VDC (I provided old VDC and VPN Credentials)','Closed',7),(198,'2019-09-27 16:13:05','CONNECT ENERGY','Cloud','Support request','Reconnect their VDC','Closed',1),(199,'2019-09-27 16:13:05','CONNECT ENERGY','Cloud','Support request','Provision a new virtual machine','Closed',1),(200,'2019-09-27 16:13:05','AOS','Cloud','Proactive support','Configure esxi monitoring with Nagios ','Pending on AOS',1),(201,'2019-09-27 16:14:08','AOS','Web and mail hosting','Proactive support','Checked spam to all cPanel mail servers ','Closed',14),(202,'2019-09-27 16:14:08','NAEB','DNS','Support request','Migration of OES & API apps in data center:\r\nMapped oes.naeb.gov.rw subdomain to 197.243.21.246','Closed',14),(203,'2019-09-27 16:14:08','REMA','Web and mail hosting','Support request','Rema domain locked :\r\nHelped rema.gov.rw to get access on their email accounts due to “invalid login\" error and whitelisted their public IP (197.243.42.26)','Closed',14),(204,'2019-09-27 16:18:28','AOS','Web and mail hosting','Proactive support','Approve change request','Closed',17),(205,'2019-09-27 16:18:28','AOS','Web and mail hosting','Proactive support','Add daily check script on Inyemera and Sabyinyo for reporting','Closed',17),(206,'2019-09-27 16:18:28','AOS','Cloud','Proactive support','Collect errors and warnings on hosting servers and address some. ','Pending on AOS',17),(207,'2019-09-27 16:18:28','CHUK','Cloud','Support request','Assist on installing FTP server . To be resumed on Monday','Pending on Customer',17),(208,'2019-09-27 16:18:28','RLMA','Web and mail hosting','Support request','Bandwidth limit exceeded. Increased the limit','Closed',17),(209,'2019-09-27 16:20:20','AOS','BaaS','Proactive support','Check that all critical servers backup were successful','Closed',8),(210,'2019-09-27 16:20:20','AOS','BaaS','Proactive support','Partial manual backup of kalisimbi server','0',8),(211,'2019-09-27 16:20:20','AOS','BaaS','Proactive support','Manual backup of imparage server','0',8),(212,'2019-09-27 16:20:20','AOS','BaaS','Support request','Grant access to new staff on avamar and Data domain','0',8),(213,'2019-09-27 16:20:20','AOS','BaaS','Support request','Support on installing avamar console(both) to new staff','0',8),(214,'2019-09-27 16:20:20','CONNECTED-ENERGY','BaaS','Support request','Register new server on backup services','0',8),(215,'2019-09-27 16:20:20','MINAFFET','BaaS','Proactive support','Manual backup of minaffet-exch-0.minaffet.gov.local server','0',8),(216,'2019-09-27 17:10:14','AOS','Cloud','Proactive support','Cloud Services health check (VCenter, CIAC, UCSManager','Closed',7),(217,'2019-09-27 17:10:14','AOS','Cloud','Proactive support','Cloud services monitoring (installing nagios plugins on test server / was unable to configure memory check ... still working on it .\r\nRemoved non-responding Minecofin servers.\r\nProvided knowledge tran','Pending on AOS',7),(218,'2019-09-27 17:10:14','RISA','Cloud','Support request','Reset RHA BPMIS test server password and sent it to Christophe.','Closed',7),(219,'2019-09-27 17:10:14','AOS','Cloud','Proactive support','Created a server for test of ASM WAF','Pending on AOS',7),(220,'2019-09-27 17:10:14','CONNECTED ENERGY','Cloud','Proactive support','Tested Ubuntu 18.04 Desktop on Virtual Box (failed to switch on the OS / but checked by Brice)','Closed',7),(221,'2019-09-27 18:32:34','AOS','Facility','Support request','Normal daily activities.','Closed',4),(222,'2019-09-27 18:32:34','AOS ','Colocation','Support request','Have facilitated IDC Colocated customers to gain the access in IDC.','Closed',4),(223,'2019-09-27 18:32:34','AOS','Facility','Support request','Have worked on IDC UPS which having Soft start fail fault.','Closed',4),(224,'2019-09-27 20:04:27','AOS','Network','Proactive support','Manual backup HQ config files for Access01 & 02, Firewall\r\n','Closed',15),(225,'2019-09-27 20:04:27','AOS','Network','Proactive support','Manual backup DR config files for Access01, S2SVPN and IR\r\n','Closed',15),(226,'2019-09-27 20:04:27','AOS','Network','Proactive support','Daily check\r\n','Closed',15),(227,'2019-09-27 20:04:27','SMART-ADMIN','Cloud','Support request','REI-Datacenter server reconfigure network with new subnet mask','Closed',15),(228,'2019-09-27 20:04:27','MOHM','Cloud','Support request','Change site to site VPN encryption domains MOH and NIDA','Closed',15),(229,'2019-09-27 20:04:27','CONN-ENERGY','Cloud','Support request','Static NAT and open ports for accessibility','Closed',15),(230,'2019-09-27 20:04:27','IREMBO','Colocation','Support request','Configure and test interfaces to connect Irembo network phase 2','Closed',15),(231,'2019-09-27 20:04:27','SMART-ADMIN','Cloud','Support request','Configurations to allow testing ASM WAF for SMART ADMIN servers','Pending on AOS',15),(232,'2019-09-27 20:04:27','AOS','Network','Proactive support','Identify errors and warnings for network devices','Pending on AOS',15),(233,'2019-09-27 20:04:27','RISA','Colocation','Support request','Allow IP addresses on the Firewall for accessing devices in DC','Closed',15),(234,'2019-09-30 15:43:12','AOS','Web and mail hosting','Proactive support','Checked spam to all cPanel mail servers ','Closed',14),(235,'2019-09-30 15:43:12','AOS','Web and mail hosting','Proactive support','Mail Queue_197.243.16.109:\r\nUpdated storage quota for \"zahid@asarwanda.rw \" user and manually delivery mails in queue','Closed',14),(236,'2019-09-30 15:43:12','CNDP','Web and mail hosting','Support request','National Human Rights -cndp :\r\nIncreased bandwidth Limit for ndp.org.rw website to unlimited megabytes','Closed',14),(237,'2019-09-30 15:43:12','ILDP','Web and mail hosting','Support request','request for support to fix the issue of brow sable web directory:\r\npublic_html folder under ilpd.ac.rw mail server was disabled','Closed',14),(238,'2019-09-30 15:43:12','NIC','Web and mail hosting','Support request','Request of SSL Protection For NIC Website:\r\nGenerated CSR for nic.gov.rw.rw and mail.nic.gov.rw and provisioned its SSL certificate from RapidSSL \r\n','Pending on Customer',14),(239,'2019-09-30 15:48:12','AOS','Network','Proactive support','Netflow:\r\n- downloaded and installed manageengine netflow analyser\r\n- connected to network device\r\n- configured network device\r\n- troubleshoot connectivity between network analyzer server and device','Pending on AOS',10),(240,'2019-09-30 15:48:12','Connected Energy','Network','Support request','Reset credentials for remote VPN access','Closed',10),(241,'2019-09-30 16:10:42','AOS','Web and mail hosting','Support request','IECMS issues sending to yahoo due to poor reputation of IP. Changed the interface the domain was sending from iecms.gov.rw. To be monitored','Pending on AOS',17),(242,'2019-09-30 16:10:42','MINAFFET','Web and mail hosting','Support request','Issue receiving mails to one account.','Pending on Customer',17),(243,'2019-09-30 16:20:58','AOS','BaaS','Proactive support','Checking that critical servers backups were successful','Closed',8),(244,'2019-09-30 16:20:58','AOS','BaaS','Proactive support','Partial manual backup of kalisimbi server','Closed',8),(245,'2019-09-30 16:20:58','AOS','BaaS','Proactive support','Manual backup of imparage server','Closed',8),(246,'2019-09-30 16:20:58','AOS','BaaS','Proactive support','Check on nimble storage and 3PAR Storage for both main and DR sites','Closed',8),(247,'2019-09-30 16:20:58','AOS','BaaS','Proactive support','Knowlegde transfer to helpdesk team','Closed',8),(248,'2019-09-30 16:20:58','METEO','BaaS','Support request','Reactivate meteobkup server on backup services','Pending on Customer',8),(249,'2019-09-30 16:20:58','MIFOTRA','BaaS','Proactive support','Reactivate mifotra zimbra server on backup services','Closed',8),(250,'2019-09-30 16:20:58','RPPA','BaaS','Proactive support','Reactivate RPPA Server on backup services','Closed',8),(251,'2019-09-30 16:20:58','MINAFFET','BaaS','Proactive support','Manual backup of minaffet server','Closed',8),(252,'2019-09-30 16:23:51','AOS','Facility','Support request','Normal Daily Activities.','Closed',4),(253,'2019-09-30 16:23:51','AOS','Colocation','Support request','Facilitated I&M bank during the setup of Master card project at DR site.','Closed',4);
46/*!40000 ALTER TABLE `daily_rpt` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `rpt_users`
51--
52
53DROP TABLE IF EXISTS `rpt_users`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `rpt_users` (
57 `usr_id` int(11) NOT NULL AUTO_INCREMENT,
58 `usr_firstname` varchar(30) DEFAULT NULL,
59 `usr_lastname` varchar(30) DEFAULT NULL,
60 `usr_email` varchar(30) DEFAULT NULL,
61 `usr_phone` varchar(30) DEFAULT NULL,
62 `usr_login` varchar(30) DEFAULT NULL,
63 `usr_password` varchar(200) DEFAULT NULL,
64 `usr_profile` int(1) DEFAULT NULL,
65 PRIMARY KEY (`usr_id`)
66) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `rpt_users`
71--
72
73LOCK TABLES `rpt_users` WRITE;
74/*!40000 ALTER TABLE `rpt_users` DISABLE KEYS */;
75INSERT INTO `rpt_users` VALUES (1,'Annick','Tuyishime','annick.tuyishime@aos.rw','','annick.tuyishime@aos.rw','2787e61f1d7db274fad32a3ee4030ea1',0),(2,'Brice','Kayihura','brice.kayihura@aos.rw','0788318892','brice.kayihura@aos.rw','26edc48562ebe7bc034e5172f1b76256',1),(3,'Claude','Iraguha','claude.iraguha@aos.rw','','claude.iraguha@aos.rw','d4f13cde4f0d0789ac815c927849abdb',0),(4,'Faustin','Mvuyekure','faustin.mvuyekure@aos.rw','','faustin.mvuyekure@aos.rw','d4f13cde4f0d0789ac815c927849abdb',0),(5,'Fred','Byegeka','fred.byegeka@aos.rw','','fred.byegeka@aos.rw','d4f13cde4f0d0789ac815c927849abdb',0),(6,'Ignace','Abeza','ignace.abeza@aos.rw','','ignace.abeza@aos.rw','d4f13cde4f0d0789ac815c927849abdb',0),(7,'Jean Claude','Ruhinda','jeanclaude.ruhinda@aos.rw','','jeanclaude.ruhinda@aos.rw','e0198e411ed0cb3b65c680b055ce98a6',0),(8,'Jeannelle','Gapira','jeanelle.gapira@aos.rw','','jeanelle.gapira@aos.rw','b24331b1a138cde62aa1f679164fc62f',0),(9,'Jennifer','Umutesi','jennifer.umutesi@aos.rw','','jennifer.umutesi@aos.rw','8bb36e1d4a27b44bc8c2790c0d620533',0),(10,'Marie Ange','Muhimpundu','marieange.muhimpundu@aos.rw ','','marieange.muhimpundu@aos.rw ','27e433e0d08d8e72076ca31c924a377f',0),(11,'Marius','Mugiraneza','marius.mugiraneza@aos.rw','','marius.mugiraneza@aos.rw','d4f13cde4f0d0789ac815c927849abdb',0),(12,'Maxwell','Butoto','maxwell.butoto@aos.rw','','maxwell.butoto@aos.rw','d4f13cde4f0d0789ac815c927849abdb',0),(13,'Michel','Niyoyita','michel.niyoyita@aos.rw','','michel.niyoyita@aos.rw','d4f13cde4f0d0789ac815c927849abdb',0),(14,'Placidie','Benamahirwe','placidie.benamahirwe@aos.rw','','placidie.benamahirwe@aos.rw','d4f13cde4f0d0789ac815c927849abdb',0),(15,'Simon','Misa','simon.misa@aos.rw','','simon.misa@aos.rw','fc81f63df101d12652887d4ceaef0e59',0),(16,'Solange','Tuyisenge','solange.tuyisenge@aos.rw','','solange.tuyisenge@aos.rw','8edad3ed164b929ed25a7de62e8b789c',0),(17,'Veronique','Umutesi','veronique.umutesi@aos.rw','','veronique.umutesi@aos.rw','1bf094eb1c5b9a49960da02547f06d0e',0),(18,'Yussufu','Mugemana','yussufu.mugemana@aos.rw','','yussufu.mugemana@aos.rw','53b776647c35072018c3412f71754530',0);
76/*!40000 ALTER TABLE `rpt_users` ENABLE KEYS */;
77UNLOCK TABLES;
78/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
79
80/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
81/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
82/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
84/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
85/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
86/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
87
88-- Dump completed on 2019-09-30 19:03:50