-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `eregadb`
--

-- --------------------------------------------------------

--
-- Table structure for table `assetclassification`
--

CREATE TABLE `assetclassification` (
  `assetclassificationid` int(11) NOT NULL,
  `assetclassificationname` varchar(200) NOT NULL,
  `assetclassificationescription` varchar(200) NOT NULL,
  `assettypeid` int(11) NOT NULL,
  `otid` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `assetclassification`
--

INSERT INTO `assetclassification` (`assetclassificationid`, `assetclassificationname`, `assetclassificationescription`, `assettypeid`, `otid`) VALUES
(1, 'LAPTOP - LP', 'LAPTOP - LP', 1, '00'),
(2, 'DESKTOP - DP', 'DESKTOP - DP', 1, '00'),
(3, 'TABLETS FOR IFS PROJEST- IFS', 'TABLETS FOR IFS PROJEST- IFS', 1, '00'),
(4, 'TABLETS - TB', 'TABLETS - TB', 1, '00'),
(5, 'ROOM MANAGER - RM', 'ROOM MANAGER - RM', 1, '00'),
(6, 'WAYLEAVE NET DEVICE - WYL', 'WAYLEAVE NET DEVICE - WYL', 1, '00'),
(7, 'PROJECTOR - PJ', 'PROJECTOR - PJ', 1, '00'),
(8, 'SWITCH - SW', 'SWITCH - SW', 1, '00'),
(9, 'AUDIO AND VIDEO CONFERENCE - VC', 'AUDIO AND VIDEO CONFERENCE - VC', 1, '00'),
(10, 'RADIO CALL DEVICES - RD', 'RADIO CALL DEVICES - RD', 1, '00'),
(11, 'ACCESS POINTS - AP', 'ACCESS POINTS - AP', 1, '00'),
(12, 'SERVERS - SVR', 'SERVERS - SVR', 1, '00'),
(13, 'CCTV CAMERA - CCTV', 'CCTV CAMERA - CCTV', 1, '00'),
(14, 'FINGER KEY ACCESS - FKA', 'FINGER KEY ACCESS - FKA', 1, '00'),
(15, 'ROUTER - RT', 'ROUTER - RT', 1, '00'),
(16, 'POWER SUPPLY-PS', 'POWER SUPPLY-PS', 1, '00'),
(17, 'SONGO SONGO DEVICE - SSI', 'SONGO SONGO DEVICE - SSI', 1, '00'),
(18, 'TV - TV', 'TV - TV', 1, '00'),
(19, 'SCANNER - SC', 'SCANNER - SC', 1, '00'),
(20, 'PRINTER - PT', 'PRINTER - PT', 1, '00'),
(21, 'UPS - UPS', 'UPS - UPS', 1, '00'),
(22, 'TELEPHONE - TP', 'TELEPHONE - TP', 1, '00'),
(23, 'MEDIA CONVETER - MC', 'MEDIA CONVETER - MC', 1, '00'),
(24, 'Monitors', 'Monitors', 2, '01'),
(25, 'Processors/OSM', 'Processors/OSM', 2, '02'),
(26, 'Switches', 'Switches', 2, '03'),
(27, 'Storage', 'Storage', 2, '04'),
(28, 'KVM', 'KVM', 2, '05'),
(29, 'DPU', 'DPU', 2, '06'),
(30, 'GPS', 'GPS', 2, '07'),
(31, 'Servers', 'Servers', 2, '08'),
(32, 'Router', 'Router', 2, '09'),
(33, 'Converter', 'Converter', 2, '10'),
(34, 'Printer', 'Printer', 2, '11'),
(35, 'Communication Box/Module', 'Communication Box/Module', 2, '12'),
(36, 'Micronet', 'Micronet', 2, '13'),
(37, 'Gateway (RTN/Field wireless)', 'Gateway (RTN/Field wireless)', 2, '14'),
(38, 'AVR', 'AVR', 2, '15'),
(39, 'Weather Station', 'Weather Station', 2, '16'),
(40, 'PLC', 'PLC', 2, '17'),
(41, 'I/O RACK', 'I/O RACK', 2, '18'),
(42, 'Field Wireless', 'Field Wireless', 2, '19');

-- --------------------------------------------------------

--
-- Table structure for table `assetmasterdata`
--

CREATE TABLE `assetmasterdata` (
  `assetmasterdataid` int(11) NOT NULL,
  `departmentid` int(11) NOT NULL,
  `locationid` int(11) NOT NULL,
  `asseclassification_id` int(11) NOT NULL,
  `ano` varchar(200) NOT NULL,
  `acode` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `modelid` int(11) NOT NULL,
  `serialnumber` varchar(200) NOT NULL,
  `manufacturer` varchar(200) NOT NULL,
  `netbiosname` varchar(200) NOT NULL,
  `usersid` int(11) NOT NULL,
  `createdby` int(11) NOT NULL,
  `createddate` date NOT NULL,
  `createdtime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `softwaregroupid` int(11) NOT NULL,
  `softwareinstalleddescription` varchar(200) NOT NULL,
  `ipaddressgroupid` int(11) NOT NULL,
  `vlan` int(11) NOT NULL,
  `switchdescription` varchar(200) NOT NULL,
  `biosversion` varchar(200) NOT NULL,
  `biosyear` varchar(200) NOT NULL,
  `macadressethernet` varchar(200) NOT NULL,
  `macaddresswifi` varchar(200) NOT NULL,
  `macadressbluetooth` varchar(200) NOT NULL,
  `imeinumber` varchar(200) NOT NULL,
  `purchasedate` date NOT NULL,
  `warrantyperiod` varchar(200) NOT NULL,
  `assetstateid` int(11) NOT NULL,
  `csv_file` varchar(200) DEFAULT NULL,
  `locations` varchar(200) DEFAULT NULL,
  `departments` varchar(200) DEFAULT NULL,
  `otnetworktypeid` int(11) DEFAULT NULL,
  `otitemnumber` varchar(200) DEFAULT NULL,
  `otdeviceserialnumber` varchar(200) DEFAULT NULL,
  `assettypeid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `assetmasterdata`
--

INSERT INTO `assetmasterdata` (`assetmasterdataid`, `departmentid`, `locationid`, `asseclassification_id`, `ano`, `acode`, `description`, `modelid`, `serialnumber`, `manufacturer`, `netbiosname`, `usersid`, `createdby`, `createddate`, `createdtime`, `softwaregroupid`, `softwareinstalleddescription`, `ipaddressgroupid`, `vlan`, `switchdescription`, `biosversion`, `biosyear`, `macadressethernet`, `macaddresswifi`, `macadressbluetooth`, `imeinumber`, `purchasedate`, `warrantyperiod`, `assetstateid`, `csv_file`, `locations`, `departments`, `otnetworktypeid`, `otitemnumber`, `otdeviceserialnumber`, `assettypeid`) VALUES
(1, 1, 2, 1, '2', '002LP002', 'HP ELITE BOOK X 360 1030 G2', 1, '5CG9121V2V', 'HP', 'TZSG-TE02LP002', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'MARY MWANUKUZI', 'P80 Ver. 01.25 ', '2019', 'N/A', '48-F1-7F-4E-1E-21', '48-F1-7F-4E-1E-24', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Technical Office Manager', 'Technical\r\n', NULL, NULL, NULL, NULL),
(2, 1, 2, 1, '3', '002LP003', 'LATITUDE 5410', 1, '7B2FZ33', 'DELL', 'TZSG-TE02LP003', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'PETER STEWART ', 'DELL INC. 1.3.2', '2020', '74-78-27-09-95-71', 'DC-41-A9-7D-C6-85', 'DC-41-A9-7D-C6-88', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Technical office', 'Technical\r\n', NULL, NULL, NULL, NULL),
(3, 1, 2, 1, '4', '002LP004', 'HP PRO BOOK 430 G5', 1, '5CD909480T', 'HP', 'TZSG-HS02LP004', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'JONNES MASALLA', 'HP Q85 VER 01.06.00', '2019', 'B0-0C-D1-68-52-32', 'D8-F2-CA-2C-18-B7', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'HSE Office', 'HSE\r\n', NULL, NULL, NULL, NULL),
(4, 1, 2, 1, '5', '002LP005', 'HP PRO BOOK 430 G5', 1, '5CD90949D5', 'HP', 'TZSG-HS02LP005', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'GEORGE RAMADHANI', 'HP Q85 VER 01.06.00', '2019', 'B0-0C-D1-68-58-E8', '50-76-AF-E1-5B-B3', '50-76-AF-E1-5B-B7', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Operation Manager Office', 'Operations\r\n', NULL, NULL, NULL, NULL),
(5, 1, 2, 1, '6', '002LP006', 'HP ELITE BOOK X360 1030 G2', 1, '5CG9121V4R', 'HP', 'TZSG-HS02LP006', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'JOHN MAITARIA', 'HP P80 VER. 01.25', '2019', '', '20-79-18-E4-B0-D8', '20-79-18-E4-B0-DC', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'HSE Manager Office', 'HSE\r\n', NULL, NULL, NULL, NULL),
(6, 1, 2, 1, '7', '002LP007', 'LATITUDE 5410', 1, '1TK09C3', 'DELL', 'TZSG-FN02LP007', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SWITBERT BAGOKA', 'DELL INC. 1.3.2', '2020', '74-78-27-74-4E-E9', '50-2F-9B-E0-75-50', '50-2F-9B-E0-75-53', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Finance Offie', 'Finance\r\n', NULL, NULL, NULL, NULL),
(7, 1, 2, 1, '8', '002LP008', 'HP PRO BOOK 430 G5', 1, '5CD909491V', 'HP', 'TZSG-FN02LP008', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'IRENE MACHAKU', 'HP Q85 VER. 01.06.00', '2019', 'B0-0C-D1-68-52-64', '50-76-AF-58-45-6D', '50-76-AF-58-45-70', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Finance Offie', 'Finance\r\n', NULL, NULL, NULL, NULL),
(8, 1, 2, 1, '9', '002LP009', 'HP ELITE BOOK X360 1030 G2', 1, '5CG9121V3Q', 'HP', 'TZSG-FN02LP009', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'WILLIAM KIDAVA', 'HP P80 VER. 01.25', '2019', '', '20-79-18-FB-58-F1', '20-79-18-FB-58-F5', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Finance Offie', 'Finance\r\n', NULL, NULL, NULL, NULL),
(9, 1, 2, 1, '10', '002LP010', 'HP ELITE BOOK X 360 1030 G2', 1, '5CG9121V40', 'HP', 'TZSG-FN02LP010', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'THIBELY MLUNZA', 'HP P80 VER. 01.25', '2019', '', '48-F1-7F-4D-99-DC', '48-F1-7F-4D-99-E0', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Finance and Accounting Manager Offie', 'Finance\r\n', NULL, NULL, NULL, NULL),
(10, 1, 2, 1, '11', '002LP011', 'HP PRO BOOK 430 G5', 1, '5CD8522J8M', 'HP', 'TZSG-HR02LP011', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'ELNA SOLOMON', 'HP Q85 VER. 01.03.00', '2018', 'E4-E7-49-4B-39-D5', 'A0-A4-C5-54-D8-79', 'A0-A4-C5-54-D8-7C', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'HR Office', 'HR\r\n', NULL, NULL, NULL, NULL),
(11, 1, 2, 1, '12', '002LP012', 'HP P80 VER. 01.25', 1, '5CG9121V6L', 'HP', 'TZSG-HR02LP012', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'AGATHA KEENJA', 'HP P80 VER. 01.25', '2019', '', '20-79-18-FB-5C-1B', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'HR Manager Office', 'HR\r\n', NULL, NULL, NULL, NULL),
(12, 1, 2, 1, '13', '002LP013', 'HP ELITE BOOK X360 1030 G2', 1, '5CG9121V2K', 'HP', 'TZSG-PM02LP013', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'MICHAEL MNGODO', 'HP P80 Ver .01.25', '2019', '', '20-79-18-FB-07-C5', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Plant Manager Office', 'Administration\r\n', NULL, NULL, NULL, NULL),
(13, 1, 2, 1, '14', '002LP014', 'HP ELITE BOOK X360 1030 G2', 1, '5CG9121V14', 'HP', 'TZSG-SC02LP014', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'AMANDA MAMBONA', 'HP P80 Ver .01.25', '2019', '', '48-F1-7F-4D-B8-EF', '48-F1-7F-4D-B8-F3', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Supply Chain Office', 'Supply Chain\r\n', NULL, NULL, NULL, NULL),
(14, 1, 2, 1, '15', '002LP015', 'LATITUDE 5410', 1, '7NHRW33', 'DELL', 'TZSG-CM02LP017', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SAID MBAYA', 'DELL INC. 1.7.0', '2021', 'C0-3E-BA-6F-08-77', '8E-C8-4B-85-1C-D3', '8C-C8-4B-85-1C-D4', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Supply Chain Office', 'Supply Chain\r\n', NULL, NULL, NULL, NULL),
(15, 1, 2, 1, '16', '002LP016', 'HP PRO BOOK 430 G5', 1, '5CD8522JB8', 'HP', 'TZSG-SC02LP016', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'EDMUND NCHUNDA', 'HP Q85 VER. 01.03.00', '2018', 'E4-E7-49-4B-3E-EF', 'A0-A4-C5-55-E8-09', 'A0-A4-C5-55-E8-0C', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Supply Chain Manager Office', 'Supply Chain\r\n', NULL, NULL, NULL, NULL),
(16, 1, 2, 1, '17', '002LP017', 'DELL LATITUDE 5410', 1, '7NHRW33', 'DELL', 'TZSG-CM02LP017', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'GORONGA KASAKA', 'DELL  1.2.16', '2019', 'C0-3E-BA-6F-08-77', '8C-C8-4B-85-1C-D3', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Gas infrastructure Office', 'Gas and Engineering\r\n', NULL, NULL, NULL, NULL),
(17, 1, 2, 1, '18', '002LP018', 'HP PRO BOOK 430 G5', 1, '5CD909497F', 'HP', 'TZSG-MT02LP018', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'AARON MDEMU', 'HP Q85 VER. 01.60.00', '2019', 'B0-0C-D1-68-55-B8', 'D8-F2-CA-2C-80-53', 'D8-F2-CA-2C-80-57', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Maintenance Manager Office', 'Maintenance\r\n', NULL, NULL, NULL, NULL),
(18, 1, 2, 1, '19', '002LP019', 'LATITUDE 5410', 1, 'CWPDZ33', 'DELL', 'TZSG-IT02LP019', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'ELISANTE PETER', '1.9.0 Portable', '2020', '74-78-27-09-A2-0D', 'DC-41-A9-7D-D4-D0', 'DC-41-A9-7D-D4-D4', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'ITC Office', 'ITC\r\n', NULL, NULL, NULL, NULL),
(19, 1, 2, 1, '20', '002LP020', 'HP ELITE BOOK 840 G3', 1, '5CG6117JJV', 'HP', 'TZSG-IT02LP020', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SIMON NTULA', 'N75 Ver. 01.04 Portable', '2016', '70-5A-0F-84-A0-85', '44-85-00-23-CA-59', '44-85-00-23-CA-5C', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'ITC Office', 'ITC\r\n', NULL, NULL, NULL, NULL),
(20, 1, 2, 1, '21', '002LP021', 'HP PRO BOOK 430 G5', 1, '5CD90949F7', 'HP', 'TZSG-MT02LP021', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'NICKSON MOSES', 'HP Q85 VER. 01.06.00', '2019', 'B0-0C-D1-68-5A-23', '50-76-AF-E1-5C-5E', '50-76-AF-E1-5C-61', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'E&I supervisor office', 'E&I\r\n', NULL, NULL, NULL, NULL),
(21, 1, 2, 1, '22', '002LP022', 'HP PRO BOOK 430 G5', 1, '5CD90948K6', 'HP', 'TZSG-MT02LP022', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'JOHN RUNYORO', 'HP Q85 VER. 01.06.00', '2019', 'B0-0C-D1-68-55-B5', '50-76-AF-DE-26-5B', '50-76-AF-DE-26-5E', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'E&I supervisor office', 'Gas and Engineering\r\n', NULL, NULL, NULL, NULL),
(22, 1, 2, 1, '23', '002LP023', 'HP PRO BOOK 430 G5', 1, '5CD8522J6Z', 'HP', 'TZSG-MT02LP023', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'DANFORD MPALANZI', 'HP Q85 VER. 01.03.00', '2018', 'E4-E7-49-4B-40-31', 'A0-A4-C5-55-CD-51', 'A0-A4-C5-55-CD-54', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'E&I supervisor office', 'E&I\r\n', NULL, NULL, NULL, NULL),
(23, 1, 2, 1, '24', '002LP024', 'HP PRO BOOK 430 G5', 1, '5CD8522J7W', 'HP', 'TZSG-MT02LP024', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'JOHN NKYA', 'HP Q85 VER. 01.03.00', '2018', 'E4-E7-49-4B-36-A8', 'A0-A4-C5-55-F6-28', 'A0-A4-C5-55-F6-2B', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Mechanical Supervisor Office', 'Mechanical\r\n', NULL, NULL, NULL, NULL),
(24, 1, 4, 1, '28', '004LP028', 'HP ELITE BOOK X 360 1030 G2', 1, '5CG9121V54', 'HP', 'TZSG-MD04LPO28', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'ANAEL SAMUEL', 'HP P80 VER. 01.25', '2019', '', '20-79-18-FB-57-F7', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'MD Rsquare office', 'Administration\r\n', NULL, NULL, NULL, NULL),
(25, 1, 4, 1, '30', '004LP030', 'LATITUDE 7390 2-IN-1', 1, '8JDKVT2', 'DELL', 'TZSG-CM04LP030', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'JACKLINE SILAA', 'DELL INC. 1.22.0', '2021', '', '48-5F-99-53-C0-27', '48-5F-99-53-C0-28', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Legal office Rsquare office', 'Legal\r\n', NULL, NULL, NULL, NULL),
(26, 1, 4, 1, '32', '004LP032', 'LATITUDE 7390 2-IN-1', 1, 'F1YJVT2', 'DELL', 'TZSG-CM04LP032', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SARAH MAJENGO', 'DELL INC. 1.6.2', '2018', '', '48-5F-99-53-BF-FD', '48-5F-99-53-BF-FE', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'PR Offcie', 'PR\r\n', NULL, NULL, NULL, NULL),
(27, 1, 2, 1, '33', '002LP033', 'HP ELITE BOOK X 360 1030 G2', 1, '5CG9121V3F', 'HP', 'TZSG-OP02LP033', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SALEHE SALUM', 'HP P80 VER. 01.25', '2019', '', '48-F1-7F-4D-AA-1C', '48-F1-7F-4D-AA-20', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Plant Manager Office', 'Administration\r\n', NULL, NULL, NULL, NULL),
(28, 1, 2, 1, '34', '002LP034', 'HP ELITE BOOK X 360 1030 G2', 1, '5CG9121V20', 'HP', 'TZSG-CM02LP034', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SEBASTIAN KASTULI', 'HP P80 VER. 01.25', '2019', '', '48-F1-7F-4E-67-30', '48-F1-7F-4E-67-2C', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'CCFO Office', 'Finance\r\n', NULL, NULL, NULL, NULL),
(29, 1, 4, 1, '35', '004LP035', 'LATITUDE 5410', 1, 'D9609C3', 'DELL', 'TZSG-CM04LP035', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'NICODEMUS CHIPAKAPAKA', 'HP P80 VER. 01.25', '2019', '', 'E0-2B-E9-33-D7-90', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Rsquare Office', 'Business \r\n', NULL, NULL, NULL, NULL),
(30, 1, 4, 1, '36', '004LP036', 'HP ELITE BOOK X 360 1030 G2', 1, '5CG9121V0H', 'HP', 'TZSG-CM04LP036', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'OBETH MWINGIZI', 'HP P80 VER. 01.25', '2019', 'B0-9F-9E-45-54-41', '48-F1-7F-4E-07-E1', '48-F1-7F-4E-07-E5', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Rsquare Office', 'Business \r\n', NULL, NULL, NULL, NULL),
(31, 1, 4, 1, '37', '004LP037', 'LATITUDE 5410', 1, 'GYVSDB3', 'DELL', 'TZSG-HR04LP037', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'CLARA MURO', 'DELL INC. 1.4.3', '2020', '', '8C-55-4A-0B-2B-79', '5', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Rsquare Office', 'PA MD \r\n', NULL, NULL, NULL, NULL),
(32, 1, 2, 1, '38', '002LP038', 'LATITUDE 5410', 1, '4G609C3', 'DELL', 'TZSG-OP02LP038', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'IGNATUS LAURIAN', 'DELL INC. 1.4.3', '2020', '74-78-27-74-52-0E', 'E0-2B-E9-36-9E-E0', 'E0-2B-E9-36-9E-E3', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Operation Office', 'Operations\r\n', NULL, NULL, NULL, NULL),
(33, 1, 2, 1, '39', '002LP039', 'LATITUDE 5410', 1, 'FL609C3', 'DELL', 'TZSG-OP02LP039', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'JOSEPH MSYANI', 'DELL INC. 1.12.2', '2022', '74-78-27-74-53-44', 'E0-2B-E9-36-9F-0D', 'E0-2B-E9-36-9F-10', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Operation Office', 'Operations\r\n', NULL, NULL, NULL, NULL),
(34, 1, 2, 1, '40', '002LP040', 'LATITUDE 5410', 1, '88D09C3', 'DELL', 'TZSG-OP02LP040', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'BENARD NKWAMA', 'DELL INC. 1.4.3', '2020', '74-78-27-74-53-42', '50-2F-9B-E0-75-78', '50-2F-9B-E0-75-7B', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Operation Office', 'Operations\r\n', NULL, NULL, NULL, NULL),
(35, 1, 2, 1, '41', '002LP041', 'LATITUDE 5410', 1, '2CM9593', 'DELL', 'TZSG-OP02LP041', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'OFORO SHAYO', 'DELL INC. 1.15.0', '2022', '74-78-27-5E-1C-9D', 'B4-0E-DE-DF-C6-9A', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Operation Office', 'Operations\r\n', NULL, NULL, NULL, NULL),
(36, 1, 2, 1, '42', '002LP042', 'LATITUDE 5410', 1, '6MHSDB3', 'DELL', 'TZSG-OP02LP042', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'MUSSA NDANZI', 'DELL INC. 1.10.0', '2021', '74-78-27-56-8F-25', '8C-55-4A-09-E2-CE', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Operation Office', 'Operations\r\n', NULL, NULL, NULL, NULL),
(37, 1, 2, 1, '43', '002LP043', 'LATITUDE 5410', 1, '61D09C3', 'DELL', 'TZSG-HR02LP043', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'FAIDHA SOKA', 'DELL INC. 1.3.2', '2020', '74-78-27-74-52-AF', '50-2F-9B-EE-1C-73', '50-2F-9B-EE-1C-76', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Reception', 'HR\r\n', NULL, NULL, NULL, NULL),
(38, 1, 2, 1, '44', '002LP044', 'LATITUDE 5410', 1, '1K609C3', 'DELL', 'TZSG-HR02LP044', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SHARIFA KATAKWEBA', 'DELL INC. 1.4.3', '2020', '74-78-27-74-53-2B', 'E0-2B-E9-36-66-AA', 'E0-2B-E9-36-66-AD', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Office Cordinator', 'HR\r\n', NULL, NULL, NULL, NULL),
(39, 1, 2, 1, '45', '002LP045', 'LATITUDE 5410', 1, '32D09C3', 'DELL', 'TZSG-FN02LP045', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'MARTHA MAWERE', 'DELL INC. 1.4.3', '2020', '74-78-27-74-53-E3', '50-2F-9B-E2-82-2D', '50-2F-9B-E2-82-30', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Finance Office', 'Finance\r\n', NULL, NULL, NULL, NULL),
(40, 1, 2, 1, '46', '002LP046', 'LATITUDE 5410', 1, '3F379C3', 'DELL', 'TZSG-FN02LP046', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'THOMAS MWINCHUMU', 'DELL INC. 1.5.1', '2021', '74-78-27-74-53-F4', 'E0-2B-E9-35-0F-94', 'E0-2B-E9-35-0F-97', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Finance Office', 'Finance\r\n', NULL, NULL, NULL, NULL),
(41, 1, 4, 1, '47', '004LP047', 'LATITUDE 5410', 1, '128XZ33', 'DELL', 'TZSG-BD041042', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'IMRAN KANJI', '1.5.1 Portable', '2021', '74-78-27-0C-9C-83', 'DC-41-A9-7D-A3-57', 'DC-41-A9-7D-A3-5B', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Rsquare Office', 'Business \r\n', NULL, NULL, NULL, NULL),
(42, 1, 4, 1, '48', '004LP048', 'LATITUDE 5410', 1, 'JB68M33', 'DELL', 'TZSG-BD041043', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'UPENDO BANDEKE', '1.5.1 Portable', '', '', '', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Rsquare Office', 'Business \r\n', NULL, NULL, NULL, NULL),
(43, 1, 2, 1, '50', '002LP050', 'LATITUDE 5320', 1, 'DDLNHL3', 'DELL', 'TZSG-PM02LP050', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'MICHAEL MGODO', 'DELL INC. 1.18.1', '2022', '', '7C-21-4A-87-ED-F9', '7C-21-4A-87-ED-FC', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Plant Manager Office', 'Administration\r\n', NULL, NULL, NULL, NULL),
(44, 1, 2, 1, '51', '002LP051', 'HP ELITEBOOK X360 1030 G2', 1, '5CG9121V20', 'HP', 'TZSG-CM02LP034', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SEBASTIAN KASTULI', 'HP P80 VER 0125', '2019', '', '48-F1-7F-4E-67-2D', '48-F1-7F-4E-67-30', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'CCFO Office', 'Finance\r\n', NULL, NULL, NULL, NULL),
(45, 1, 4, 1, '52', '004LP052', 'LATITUDE 5320', 1, 'GDLNHL3', 'DELL', 'TZSG-CM04LP052', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'OBETH MWINGIZI', 'DELL INC. 1.18.1', '2022', '', '', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Rsquare Office', 'Business \r\n', NULL, NULL, NULL, NULL),
(46, 1, 4, 1, '53', '004LP053', 'LATITUDE 5320', 1, '8DLNHL3', 'DELL', 'TZSG-MD04LP053', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'ANAEL SAMUEL', 'DELL INC. 1.18.1', '2022', '', '', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'MD Rsquare office', 'Administration\r\n', NULL, NULL, NULL, NULL),
(47, 1, 2, 1, '54', '002LP054', 'LATITUDE 5320', 1, 'FDLNHL3', 'DELL', 'TZSG-HR02LP054', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'AGATHA KEENJA', 'DELL INC. 1.18.1', '2022', '', '7C-21-4A-88-31-A1', '7C-21-4A-88-31-A4', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'HR Manager Office', 'HR\r\n', NULL, NULL, NULL, NULL),
(48, 1, 2, 1, '55', '002LP055', 'LATITUDE 5320', 1, '4FLNHL3', 'DELL', 'TZSG-MT02LP055', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'AARON MDEMU', 'DELL INC. 1.18.1', '2022', '00-BE-43-46-0A-3D', '7C-21-4A-99-6E-03', '7C-21-4A-99-6E-06', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Maintenance Manager Office', 'Maintenance\r\n', NULL, NULL, NULL, NULL),
(49, 1, 2, 1, '56', '002LP056', 'LATITUDE 5320', 1, '3FLNHL3', 'DELL', 'TZSG-TE02LP056', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'MARY MWANUKUZI', 'P80 Ver. 01.25 ', '2019', '', '48-F1-7F-4E-1E-21', '48-F1-7F-4E-1E-24', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Technical Office Manager', 'Technical\r\n', NULL, NULL, NULL, NULL),
(50, 1, 2, 1, '57', '002LP057', 'LATITUDE 5320', 1, '9DLNHL3', 'DELL', 'TZSG-FN02LP057', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'WILLIAM KIDAVA', 'DELL INC. 1.18.1', '2022', '', '7C-21-4A-98-B7-29', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Finance Offie', 'Finance\r\n', NULL, NULL, NULL, NULL),
(51, 1, 2, 1, '58', '002LP058', 'LATITUDE 5320', 1, '5DLNHL3', 'DELL', 'TZSG-FN02LP58', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'THIBELY MLUNZA', 'DELL INC. 1.18.1', '2022', '', '7C-21-4A-98-BD-96', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Finance and Accounting Manager Offie', 'Finance\r\n', NULL, NULL, NULL, NULL),
(52, 1, 2, 1, '59', '002LP059', 'LATITUDE 5320', 1, 'HDLNHL3', 'DELL', 'TZSG-OP02LP059', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SALEHE SALUM', 'DELL INC. 1.18.1', '2022', '', '7C-21-4A-99-71-5E', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Plant Manager Office', 'Administration\r\n', NULL, NULL, NULL, NULL),
(53, 1, 2, 1, '60', '002LP060', 'LATITUDE 5320', 1, '4DLNHL3', 'DELL', 'TZSG-HS02LP060', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'JOHN MAITARIA', 'DELL INC. 1.18.1', '2022', '', '7C-21-4A-97-65-80', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'HSE Manager Office', 'HSE\r\n', NULL, NULL, NULL, NULL),
(54, 1, 2, 1, '61', '002LP061', 'LATITUDE 5320', 1, 'JDLNHL3', 'DELL', 'TZSG-GI02LP061', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'GORONGA KASAKA', 'DELL INC. 1.18.1', '2022', '', '7C-21-4A-97-4B-05', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Gas infrastructure Office', 'Gas and Engineering\r\n', NULL, NULL, NULL, NULL),
(55, 1, 2, 1, '62', '002LP062', 'LATITUDE 5320', 1, '6DLNHL3', 'DELL', 'TZSG-IT02LP062', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'SUNIL VEDD', 'DELL INC. 1.20.0', '2022', '', '7C-21-4A-97-65-4A', '7C-21-4A-97-65-4D', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'ITC Manager Office', 'ITC\r\n', NULL, NULL, NULL, NULL),
(56, 1, 4, 1, '63', '004LP063', 'LATITUDE 5320', 1, '', 'DELL', 'TZSG-CM04LP063', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'NICODEMUS CHIPAKAPAKA', 'DELL INC. 1.18.1', '2022', '', '', '', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'Rsquare Office', 'Business \r\n', NULL, NULL, NULL, NULL),
(57, 1, 2, 1, '64', '004LP064', 'HP PROBOOK0 G5', 1, '5CD909497F', 'HP', 'TZSG-MT02LP018', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'KAYUS PATRICE', 'HP Q85 Ver.01.20.00', '2022', 'BO-0C-D1-68-55-B8', 'DA-F2-CA-2C-80-53', 'D8-F2-CA-2C-80-57', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'ITC Office', 'ITC\r\n', NULL, NULL, NULL, NULL),
(58, 1, 2, 1, '65', '004LP065', 'HP ELITEBOOK 840 G2', 1, '5CG5390NKL', 'HP', 'TZSG-FN02LP049', 1, 0, '2022-11-11', '2022-11-15 07:24:55', 1, 'OS', 1, 1, 'IT INTERN', 'HP M71Ver.01.08', '2015', 'B0-5A-DA-B1-D4-DA', '94-65-9C-A1-9F-5B', 'B4-BF-82-5B-45-58', 'N/A', '0000-00-00', '3 YEARS', 1, 'uploads/Data.csv', 'ITC Office', 'ITC\r\n', NULL, NULL, NULL, NULL),
(59, 0, 2, 2, '3', '002DP003', 'DELL OPTIPLEX 5250AIO', 0, '9STOJN2', 'DELL', 'TZSG-OP02DP003', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Songas Operations', 'DELL INC. 1.13.2', '2019', '14-B3-1F-2A-A7-E5', 'E4-70-B8-D9-B3-54', 'E4-70-B8-D9-B3-58', 'N/A', '0000-00-00', '3 years', 1, 'uploads/Data.csv', 'Main Control Room', 'Operations\r\n', NULL, NULL, NULL, NULL),
(60, 0, 2, 2, '5', '002DP005', 'DELL OPTIPLEX 5250 AIO', 0, '9SR1JN2', 'DELL', 'TZSG-HS02DP005', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'HSE Intern', 'DELL INC. 1.15.1', '2020', '14-B3-1F-2C-0B-B7', 'E4-70-B8-D9-A5-3B', 'E4-70-B8-D9-A5-3E', 'N/A', '0000-00-00', '3 years', 1, 'uploads/Data.csv', 'HSE Office', 'HSE\r\n', NULL, NULL, NULL, NULL),
(61, 0, 2, 2, '8', '002DP008', 'DELL OPTIPLEX 5250 AIO', 0, '9SV7JN2', 'DELL', 'TZSG-FN02DP008', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Martha Mawere', 'DELL INC. 1.8.5', '2020', '', 'E4-70-B8-D9-A5-3A', '', 'N/A', '0000-00-00', '3 years', 1, 'uploads/Data.csv', 'Finance Office', 'Finance\r\n', NULL, NULL, NULL, NULL),
(62, 0, 2, 2, '23', '002DP023', 'OPTIPLEX 9020', 0, '28ZNV42', 'DELL', 'TZSG-IT02DP023', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'IT USB PC', 'DELL INC. A10', '2015', '98-90-96-D7-BB-E9', '', '', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'LIBRARY', 'IT (USB PC)\r\n', NULL, NULL, NULL, NULL),
(63, 0, 2, 2, '24', '002DP024', 'HP PRO DESK 400 G1 MT', 0, 'TRF4110LC4', 'HP', 'TZSG-IT02DP024', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'GUARD HOUSE', 'HP L02 V02.11', '2014', '9C-B6-54-BA-56-78', '', '', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'GUARD HOUSE MAIN GATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(64, 0, 4, 2, '28', '004DP028', 'DELL INSPIRON 7700 AIO', 0, '7MKJ673', 'DELL', 'TZSG-AD04DP028', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'ANAEL SAMUEL', '1.2.2', '', '', '', '', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'R SQUARE', 'ADMIN\r\n', NULL, NULL, NULL, NULL),
(65, 0, 2, 2, '29', '002DP029', 'DELL Inspiron 5400 AIO', 0, '2BB7G92', 'DELL', 'TZSG-MT02DP029', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'WILLIAM MICHAEL', '1.11.0', '2022', '30-D0-42-EA-52-3B', '06-56-E5-ED-77-27', '04-56-E5-ED-77-2B', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Maintenance Office', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(66, 0, 2, 2, '30', '002DP030', 'DELL Inspiron 5400 AIO', 0, 'FBB7G92', 'DELL', 'TZSG-MT02DP030', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'TWAIRAN SELEMAN', '1.12.0', '2022', '30-D0-42-EA-51-A7', '04-56-E5-ED-79-17', '04-56-E5-ED-79-1A', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Maintenance Office', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(67, 0, 2, 2, '31', '002DP031', 'DELL Inspiron 5400 AIO', 0, 'CBB7G92', 'DELL', 'TZSG-MT02DP031', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'SYLVESTER EMILY', '1.12.0', '2022', '30-D0-42-EA-52-2B', '06-56-E5-ED-79-2A', '04-56-E5-ED-79-2E', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Maintenance Office', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(68, 0, 2, 2, '32', '002DP032', 'DELL Inspiron 5400 AIO', 0, 'DBB7G92', 'DELL', 'TZSG-MT02DP032', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'ADAM BAWA', '1.12.0', '2022', '30-D0-42-EA-52-E2', '04-56-E5-ED-79-67', '04-56-E5-ED-79-6A', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Maintenance Office', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(69, 0, 2, 2, '33', '002DP032', 'DELL Inspiron 5400 AIO', 0, 'B9B7G92', 'DELL', 'TZSG-MT02DP033', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'ABEID KAPOMPO', '1.10.0', '2022', '30-D0-42-EA-52-62', '04-56-E5-ED-77-A0', '04-56-E5-ED-77-A3', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Maintenance Office Container', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(70, 0, 2, 2, '34', '002DP034', 'DELL Inspiron 5400 AIO', 0, '7BB7G92', 'DELL', 'TZSG-MT02DP034', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'ALFRED MUHITIRA', '1.12.0', '2022', '30-D0-42-EA-3E-8F', '04-56-E5-ED-78-B8', '04-56-E5-ED-78-BB', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Maintenance Office Container', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(71, 0, 2, 2, '36', '002DP036', 'DELL Inspiron 5400 AIO', 0, 'J9B7G92', 'DELL', 'TZSG-MT02DP036', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Jesse Ruzige', '1.12.0', '2022', '30-D0-42-EA-52-B2', '04-56-E5-ED-78-0D', '04-56-E5-ED-78-11', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'E&I Office', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(72, 0, 2, 2, '37', '002DP037', 'DELL Inspiron 5400 AIO', 0, '5BB7G92', 'DELL', 'TZSG-MT02DP037', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Denis Daniel', '1.12.0', '2022', '30-D0-42-EA-3D-EB', '04-56-E5-ED-77-F4', '04-56-E5-ED-77-F8', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'E&I Office', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(73, 0, 2, 2, '38', '002DP038', 'DELL Inspiron 5400 AIO', 0, 'D9B7G92', 'DELL', 'TZSG-MT02DP038', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Said Kapungu', '1.12.0', '2022', '30-D0-42-EA-52-CB', '04-56-E5-ED-78-45', '04-56-E5-ED-78-48', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'E&I Office', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(74, 0, 2, 2, '39', '002DP039', 'DELL Inspiron 5400 AIO', 0, 'H9B7G92', 'DELL', 'TZSG-MT02DP039', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Ewald Kiria', '1.12.0', '2022', '30-D0-42-EA-52-64', '04-56-E5-ED-78-A8', '04-56-E5-ED-78-AC', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'E&I Office Container', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(75, 0, 2, 2, '40', '002DP040', 'DELL Inspiron 5400 AIO', 0, '9BB7G92', 'DELL', 'TZSG-MT02DP040', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Leonard Mpiwa', '1.12.0', '2022', '30-D0-42-EA-52-A3', '04-56-E5-ED-78-18', '04-56-E5-ED-78-1B', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'E&I Office', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(76, 0, 2, 2, '41', '002DP041', 'DELL Inspiron 5400 AIO', 0, 'G9B7G92', 'DELL', 'TZSG-MT02DP041', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Denis Temba', '1.12.0', '2022', '30-D0-42-EA-42-7E', '04-56-E5-ED-78-22', '04-56-E5-ED-78-25', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'E&I Office Container', 'MAINTENANCE\r\n', NULL, NULL, NULL, NULL),
(77, 0, 2, 2, '42', '002DP042', 'DELL Inspiron 5400 AIO', 0, 'F9B7G92', 'DELL', 'TZSG-OP02DP042', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Operations Team', '1.12.0', '2022', '30-D0-42-EA-52-8D', '04-56-E5-ED-78-35', '04-56-E5-ED-78-39', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Library', 'Operations\r\n', NULL, NULL, NULL, NULL),
(78, 0, 2, 2, '43', '002DP043', 'DELL Inspiron 5400 AIO', 0, '1BB7G92', 'DELL', 'TZSG-OP02DP043', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Operations Team', '1.12.0', '2022', '30-D0-42-EA-52-87', '04-56-E5-ED-78-09', '04-56-E5-ED-78-0C', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Library', 'Operations\r\n', NULL, NULL, NULL, NULL),
(79, 0, 2, 2, '44', '002DP044', 'DELL Inspiron 5400 AIO', 0, '8BB7G92', 'DELL', 'TZSG-TE02DP044', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Halima Abbas', '1.12.0', '2022', '30-D0-42-EA-52-BE', '04-56-E5-ED-77-B9', '04-56-E5-ED-77-BC', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Technical Office', 'Technical\r\n', NULL, NULL, NULL, NULL),
(80, 0, 2, 2, '45', '002DP045', 'DELL Inspiron 5400 AIO', 0, '89B7G92', 'DELL', 'TZSG-TE02DP045', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Raphael Bukene', '1.12.0', '2022', '30-D0-42-EA-52-56', '04-56-E5-ED-77-DC', '04-56-E5-ED-77-DF', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Technical Office', 'Technical\r\n', NULL, NULL, NULL, NULL),
(81, 0, 2, 2, '46', '002DP046', 'DELL Inspiron 5400 AIO', 0, '6BB7G92', 'DELL', 'TZSG-TE02DP046', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Goodluck Mwikala', '1.12.0', '2022', '30-D0-42-EA-52-AB', '04-56-E5-ED-77-FF', '04-56-E5-ED-78-02', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'Technical Office', 'Technical\r\n', NULL, NULL, NULL, NULL),
(82, 0, 2, 2, '47', '002DP047', 'DELL Inspiron 5400 AIO', 0, 'C9B7G92', 'DELL', 'TZSG-IT02DP048', 0, 0, '2022-11-11', '2022-11-15 09:11:17', 1, 'OS', 1, 1, 'Sunil Vedd', '1.12.0', '2022', '30-D0-42-EA-52-A8', '04-56-E5-ED-77-B3', '04-56-E5-ED-77-B7', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'IT Manager Office', 'IT \r\n', NULL, NULL, NULL, NULL),
(83, 0, 2, 2, '48', '002DP048', 'DELL Inspiron 5400 AIO', 0, '79B7G92', 'DELL', 'DESKTOP-HI0RIS2', 0, 0, '2022-11-11', '2022-11-15 09:11:18', 1, 'OS', 1, 1, 'Elisante Peter', '1.12.0', '2022', '30-D0-42-EA-52-9F', '04-56-E5-ED-77-63', '04-56-E5-ED-77-67', 'N/A', '0000-00-00', '1 Year', 1, 'uploads/Data.csv', 'IT office', 'IT \r\n', NULL, NULL, NULL, NULL),
(84, 0, 2, 2, '49', '002DP049', 'DELL OPTIPLEX 5250AIO', 0, '9SS5JN2', 'DELL', 'REPORTS01', 0, 0, '2022-11-11', '2022-11-15 09:11:18', 1, 'OS', 1, 1, 'CRO', 'DELL INC. 1.13.2', '2019', '14-B3-1F-2A-B8-40', '', '', 'N/A', '0000-00-00', '3 years', 1, 'uploads/Data.csv', 'MCR', 'IT \r\n', NULL, NULL, NULL, NULL),
(85, 0, 2, 2, '50', '002DP050', 'OptiPlex5250 AIO', 0, '9SY1JN2', 'DELL', 'TZSG-GI02DP050', 0, 0, '2022-11-11', '2022-11-15 09:11:18', 1, 'OS', 1, 1, 'GI intern', 'DELL INC 1.19.0', '2021', '14-B3-1F-2A-55-5F', 'E4-70-B8-D9-A4-FF', 'E4-70-B8-D9-A5-02', 'N/A', '0000-00-00', '3 years', 1, 'uploads/Data.csv', 'HSE Office', 'HSE\r\n', NULL, NULL, NULL, NULL),
(86, 0, 2, 2, '51', '002DP051', 'HP 50B MICROTOWER', 0, 'TRF1234NLP', 'HP', 'TZSG-CS02DP031', 0, 0, '2022-11-11', '2022-11-15 09:11:18', 1, 'OS', 1, 1, 'SUPPLYCHAIN INTERN', 'AMERICAN MEGA TRENTS INC 6.07', '2011', '78-AC-CO-BB-3E-95', '', '', 'N/A', '0000-00-00', '3 years', 1, 'uploads/Data.csv', 'SUPPLY AND CHAIN OFFICE', 'SUPPLY AND CHAIN\r\n', NULL, NULL, NULL, NULL),
(87, 0, 2, 2, '52', '002DP052', 'OPTIPLEX 9020', 0, '6Q63622', 'DELL', 'TZSG-TE02DP025', 0, 0, '2022-11-11', '2022-11-15 09:11:18', 1, 'OS', 1, 1, 'TECHNICAL INTERN', 'DELL INC .A08', '2014', '98-90-96-A9-7F-AA', '', '', 'N/A', '0000-00-00', '3 years', 1, 'uploads/Data.csv', 'Technical Office', 'Technical\r\n', NULL, NULL, NULL, NULL),
(88, 0, 2, 20, '1', '002PT001', 'L6170 WIFI', 0, '', 'EPSON', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'SUNIL VEDD', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'IT MANAGER OFFICE', 'IT\r\n', NULL, NULL, NULL, NULL),
(89, 0, 2, 20, '2', '002PT002', 'HP M351 PCL6', 0, 'CNFF816261', 'HP', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'AGATHA KEENJA', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'HR MANAGER OFFICE', 'HR\r\n', NULL, NULL, NULL, NULL),
(90, 0, 2, 20, '3', '002PT003', 'GK420t', 0, '29J181402586', 'ZEBRA', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'SECURITY GUARD', '', '', '', '', '', 'CARD PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MAINGATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(91, 0, 2, 20, '4', '002PT004', 'SHARP MX-3640', 0, '5E006834', 'DURA', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'LABLING MACHINE', 1, 1, 'SUPPLY CHAIN STAFFS', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'SUPPLY CHAIN', 'SUPPLY CHAIN\r\n', NULL, NULL, NULL, NULL),
(92, 0, 2, 20, '5', '002PT005', 'DuraLable PRO 300', 0, 'T4317450335', 'DURA', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'LABLING MACHINE', 1, 1, 'HSE STAFFS', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'HSE OFFICE', 'HSE\r\n', NULL, NULL, NULL, NULL),
(93, 0, 2, 20, '6', '002PT006', 'HP LASERJET PRO M608', 0, 'CNBKMBM089', 'HP', 'CONTROL ROOM PRINTER', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', 'V.38.97.FF', '', '9C:8E:99:89:5F:36', '', '', 'MCR PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCR', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(94, 0, 2, 20, '7', '002PT007', 'SHARP DX-2500', 0, 'SEOO6644', 'SHARP', 'ANNEX PRINTER', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'MAINTENANCE  STAFFS', '', '', '28:84:FA:5C:CA:7A', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'ANNEX', 'IT\r\n', NULL, NULL, NULL, NULL),
(95, 0, 2, 20, '8', '002PT008', 'SHARP DX-2301N', 0, '7E00008X', 'SHARP', 'SUPPLY CHAIN', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'SUPPLY CHAIN STAFFS', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'SUPPLY CHAIN', 'SUPPLY CHAIN\r\n', NULL, NULL, NULL, NULL),
(96, 0, 2, 20, '9', '002PT009', 'SHARP DX-2500', 0, 'SC50918E', 'SHARP', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'ALL STAFFS', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'TWIGA Conference', 'IT\r\n', NULL, NULL, NULL, NULL),
(97, 0, 2, 20, '10', '002PT010', 'Canon iR-ADV C5535i III', 0, 'WHR21370', 'CANON', 'UPP RECEPTION PRINTER', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'ALL STAFFS', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'RECEPTION', 'IT\r\n', NULL, NULL, NULL, NULL),
(98, 0, 4, 20, '11', '004PT011', 'Canon iR-ADV C5535i III', 0, '2KE11486', 'CANON', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'ALL STAFFS', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'R SQUARE ', 'IT\r\n', NULL, NULL, NULL, NULL),
(99, 0, 2, 20, '12', '002PT012', 'M254nw', 0, 'VNC3G07478', 'HP', 'GE PRINTER', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'GE PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCR', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(100, 0, 2, 20, '13', '002PT013', 'M254nw', 0, 'VNC3G07473', 'HP', 'SEIMENS PRINTER', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'SEIMENS PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCR', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(101, 0, 4, 20, '14', '004PT014', 'SHARP MX-2310U', 0, '2E014940', 'SHARP', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'ALL STAFFS', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'RHINO CONFERENCE R SQUARE', 'ALL STAFFS\r\n', NULL, NULL, NULL, NULL),
(102, 0, 2, 20, '15', '002PT015', 'HP DESIGNJET T2530', 0, 'CN7595H00N', 'HP', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'TECHNICAL STAFFS', '', '', '', '', '', 'PLOTTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'TECHNICAL OFFICE', 'TECHNICAL\r\n', NULL, NULL, NULL, NULL),
(103, 0, 2, 20, '16', '002SC016', 'HP DESKJET 2130', 0, '', 'HP', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'SCANNER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'MCR SCANNER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(104, 0, 1, 20, '17', '001PT017', 'LASERJET PRO M102a', 0, 'VNC4D27498', 'HP', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'UGT5 PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCC5', 'IT\r\n', NULL, NULL, NULL, NULL),
(105, 0, 1, 20, '18', '001PT018', 'F158200', 0, 'NCLA135595', 'CANON', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'UGT3 PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCC3/4', 'IT\r\n', NULL, NULL, NULL, NULL),
(106, 0, 1, 20, '19', '001PT019', 'F158200', 0, 'NCLA126896', 'CANON', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'UGT4 PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCC3/4', 'IT\r\n', NULL, NULL, NULL, NULL),
(107, 0, 1, 20, '20', '001PT020', 'LASERJET PRO M102a', 0, 'VNC4D27514', 'HP', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'UGT6 PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCC6', 'IT\r\n', NULL, NULL, NULL, NULL),
(108, 0, 1, 20, '21', '001PT021', '', 0, '', 'OKI', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'UGT1 PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCC1', 'IT\r\n', NULL, NULL, NULL, NULL),
(109, 0, 1, 20, '22', '001PT022', 'N36301B', 0, 'AK6B052989', 'OKI', '', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'OPREATIONS STAFFS', '', '', '', '', '', 'UGT2 PRINTER', '0000-00-00', '', 1, 'uploads/Data.csv', 'MCC2', 'IT\r\n', NULL, NULL, NULL, NULL),
(110, 0, 2, 20, '23', '002PT023', 'Canon iR-ADV C5535i III', 0, 'WHR21242', 'CANON', 'UPP Finance PRINTER', 0, 0, '2022-11-11', '2022-11-15 12:29:24', 1, 'PRINTER', 1, 1, 'Finance Staff', '', '', '', '', '', '', '0000-00-00', '', 1, 'uploads/Data.csv', 'Finance', 'Finance\r\n', NULL, NULL, NULL, NULL),
(111, 0, 2, 7, '1', '002PJ001', 'EB-1776W', 0, 'REQK5400195', 'EPSON', 'PROJECTOR', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'ALL STAFFS', '', '', '', '64-EB-8C-CC-4A-20', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TWIGA CONFERENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(112, 0, 2, 7, '2', '002PJ002', 'EPSON-H328B', 0, 'M3WF071656L', 'EPSON', 'PROJECTOR', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'MAINT STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ANNEX', 'IT\r\n', NULL, NULL, NULL, NULL),
(113, 0, 2, 10, '1', '002RD001', 'MDH56QCC9LA3AN', 0, '627TTK2305 7210', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(114, 0, 2, 10, '2', '002RD002', 'MDH56QCC9LA3AN', 0, '627TTK1573 7210', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'OPERATIONS STAFF', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CONTROL ROOM', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(115, 0, 2, 10, '3', '002RD003', 'MDH56QCC9LA3AN', 0, '627TTK2288 7210', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'OPERATIONS STAFF', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CONTROL ROOM', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(116, 0, 2, 10, '4', '002RD004', 'MDH56QCC9LA3AN', 0, '627TTK2477 7210', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'OPERATIONS STAFF', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CONTROL ROOM', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(117, 0, 2, 10, '5', '002RD005', 'MDH56QCC9LA3AN', 0, '627TUB0958 8022', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'OPERATIONS STAFF', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CONTROL ROOM', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(118, 0, 2, 10, '6', '002RD006', 'MDH56QCC9LA3AN', 0, '627TTK2461 7210', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'OPERATIONS STAFF', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CONTROL ROOM', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(119, 0, 2, 10, '7', '002RD007', 'MDH56QCC9LA3AN', 0, '627TTK2438 7210', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(120, 0, 2, 10, '8', '002RD008', 'MDH56QCC9LA3AN', 0, '627TTM0507 7212', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(121, 0, 2, 10, '9', '002RD009', 'MDH56QCC9LA3AN', 0, '627TTK2304 7210', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(122, 0, 2, 10, '10', '002RD010', 'MDH56QCC9LA3AN', 0, '627TWZ0467 0500', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.20.02.0002', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(123, 0, 2, 10, '11', '002RD011', 'MDH56QCC9LA3AN', 0, '627TWZ0607 0500', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.20.02.0002', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(124, 0, 2, 10, '12', '002RD012', 'MDH56QCC9LA3AN', 0, '627TWZ0752 0500', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.20.02.0002', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(125, 0, 2, 10, '13', '002RD013', 'MDH56QCC9LA3AN', 0, '627TWZ0541 0500', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.20.02.0002', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(126, 0, 2, 10, '14', '002RD014', 'MDH56QCC9LA3AN', 0, '627TWZ0750 0500', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.20.02.0002', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(127, 0, 2, 10, '15', '002RD015', 'MDH56QCC9LA3AN', 0, '627TTK2429 7210', 'MOTOROLA', 'RADIO CALL PHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'SALEHE SALUM', 'R02.07.01.0000', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATIONS MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(128, 0, 4, 18, '1', '004TV001', 'UA65TU7000U', 0, 'N/A', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'RHINO CONFERENCE ROOM R-SQUARE', 'IT\r\n', NULL, NULL, NULL, NULL),
(129, 0, 4, 18, '2', '004TV002', 'UA65TU7000U', 0, '015Q3FAN600022P', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'RHINO CONFERENCE ROOM R-SQUARE', 'IT\r\n', NULL, NULL, NULL, NULL),
(130, 0, 2, 18, '3', '002TV003', 'UA48H4200', 0, '00643YEG200183B', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', 'T-NT14LDEUC-1025.0', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SIMBA CONFERENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(131, 0, 2, 18, '4', '002TV004', 'UA48H4200', 0, '00643YEG200190Z', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', 'T-NT14LDEUC-1025.0', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SIMBA CONFERENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(132, 0, 2, 18, '5', '002TV005', 'UA50J5100', 0, '028V3KDH304400B', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'OPERATIONS', 'T-NT14LJDAAC-1016.1', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(133, 0, 2, 18, '6', '002TV006', 'UA50J5100', 0, '028V3KDH303160Y', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'OPERATIONS', 'T-NT14LJDAAC-1016.1', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(134, 0, 2, 18, '7', '002TV007', 'UA50J5100', 0, '028V3KHH600219W', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'OPERATIONS', 'T-NT14LJDAAC-1018.0', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(135, 0, 2, 18, '8', '002TV008', 'UA50J5100', 0, '028V3KDH302597T', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'OPERATIONS', 'T-NT14LJDAAC-1017.1', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(136, 0, 2, 18, '9', '002TV009', 'UA50J5100', 0, '028V3KDH401659B', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'OPERATIONS', 'T-NT14LJDAAC-1017.1', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(137, 0, 2, 18, '10', '002TV010', 'UA50J5100', 0, '028V3KHH600804V', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'OPERATIONS', 'T-NT14LJDAAC-1018.0', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(138, 0, 2, 18, '11', '002TV011', 'KLV-32EX330', 0, '2343505', 'S0NY', 'SONY', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'CCTV DISPLAY TV', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(139, 0, 2, 18, '12', '002TV012', 'UA32EH4000R', 0, 'LF4U3DBDB00628P', 'SAMSUNG', 'SAMSUNG TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'SECURITY GUARDS', 'T-MX9HMAFC-1114.0', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAINGATE VISITORS ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(140, 0, 2, 18, '13', '002TV013', 'TH-50C330M', 0, 'IFB122857A-00065', 'PANASONIC', 'PANASONIC', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'DINING ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(141, 0, 2, 18, '14', '002TV014', 'UA49J5200AK', 0, '03TX3K4J606283F', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'GYM', 'IT\r\n', NULL, NULL, NULL, NULL),
(142, 0, 2, 18, '15', '002TV015', 'KD-65X8500G', 0, '3003324', 'SONY', 'SONY SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TWIGA CONFERENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(143, 0, 2, 18, '16', '002TV016', 'KD-65X8500G', 0, '3003323', 'SONY', 'SONY SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TWIGA CONFERENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(144, 0, 4, 18, '17', '004TV017', 'UA55F8000', 0, 'N/A', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-20 22:50:05', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '\"T-FXPDEUC-1136.0 ', 'BT-S\"', '', '', '', '', '0000-00-00', '0000-00-00', 1, 'uploads/Data.csv', '1', 'R-SQUARE RECEPTION', NULL, NULL, NULL, NULL),
(145, 0, 4, 18, '18', '004TV018', 'UA65TU7000U', 0, 'N/A', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TEMBO CONFERENCE ROOM', 'IT\r\n', NULL, NULL, NULL, NULL);
INSERT INTO `assetmasterdata` (`assetmasterdataid`, `departmentid`, `locationid`, `asseclassification_id`, `ano`, `acode`, `description`, `modelid`, `serialnumber`, `manufacturer`, `netbiosname`, `usersid`, `createdby`, `createddate`, `createdtime`, `softwaregroupid`, `softwareinstalleddescription`, `ipaddressgroupid`, `vlan`, `switchdescription`, `biosversion`, `biosyear`, `macadressethernet`, `macaddresswifi`, `macadressbluetooth`, `imeinumber`, `purchasedate`, `warrantyperiod`, `assetstateid`, `csv_file`, `locations`, `departments`, `otnetworktypeid`, `otitemnumber`, `otdeviceserialnumber`, `assettypeid`) VALUES
(146, 0, 4, 18, '19', '004TV019', 'UA65TU7000U', 0, '015Q3FAN600059X', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ALL SONGAS STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TEMBO CONFERENCE ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(147, 0, 2, 18, '20', '002TV020', 'UA48H4200AKXKE', 0, '00643YEG300308M', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'MICHAEL MNGODO', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'PLANT MANAGER OFFICE', 'IT\r\n', NULL, NULL, NULL, NULL),
(148, 0, 4, 18, '21', '004TV021', 'UA55F8000ATXXA', 0, 'LGS838RDA00380Y', 'SAMSUNG', 'SAMSUNG SMART TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'ANAEL SAMUEL', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MANAGING DIRECTOR', 'IT\r\n', NULL, NULL, NULL, NULL),
(149, 0, 2, 18, '22', '002TV022', 'UA32EH4000R', 0, 'LF4U3DBDB00544Z', 'SAMSUNG', 'SAMSUNG TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 3, 1, 'NICKSON MOSES', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAINTENANCE PLANNER', 'IT\r\n', NULL, NULL, NULL, NULL),
(150, 0, 2, 18, '23', '002TV023', '65A61G', 0, 'ZK24469-252189-222N-4182', 'HISENSE', 'HISENSE TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CCTV CONTROL ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(151, 0, 2, 18, '24', '002TV024', '65A61G', 0, 'ZK24469-252189-222N-4181', 'HISENSE', 'HISENSE TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CCTV CONTROL ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(152, 0, 2, 18, '25', '002TV025', '65A6GS', 0, 'ZK24469-275314-22B6-0135', 'HISENSE', 'HISENSE TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CCTV CONTROL ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(153, 0, 2, 18, '26', '002TV026', '65A61G', 0, 'ZK24469-252189-222N-4282', 'HISENSE', 'HISENSE TV', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CCTV CONTROL ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(154, 0, 2, 21, '1', '002UPS001', 'BX650CI-AF', 0, '3B1435X23270', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'maintenance container', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'mec container', 'MAINTAINANCE\r\n', NULL, NULL, NULL, NULL),
(155, 0, 2, 21, '2', '002UPS002', 'BX650CI-AF', 0, '3B1308X12850', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'E&I container', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'mec container', 'MAINTAINANCE\r\n', NULL, NULL, NULL, NULL),
(156, 0, 2, 21, '3', '002UPS003', 'BX650CI-AF', 0, '3B1427X10205', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'martha.mawele', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ACCOUNT ASSISTANT', 'FINANCE\r\n', NULL, NULL, NULL, NULL),
(157, 0, 2, 21, '4', '002UPS004', 'BV800I-MSX', 0, '9B2139A12033', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'martha.mawele', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ACCOUNT ASSISTANT', 'FINANCE\r\n', NULL, NULL, NULL, NULL),
(158, 0, 2, 21, '5', '002UPS005', 'BV800I-MSX', 0, '9B2139A12456', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'william kidava', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ACCOUNT ASSISTANT', 'FINANCE\r\n', NULL, NULL, NULL, NULL),
(159, 0, 2, 21, '6', '002UPS006', 'SMV750I-MS', 0, 'OS1944A00804', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', '', 'FINANCE\r\n', NULL, NULL, NULL, NULL),
(160, 0, 2, 21, '7', '002UPS007', 'BX650CI-AF', 0, '3B1427X11150', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'Peter Stewart', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TECHNICAL OFFICE', 'TECHNICAL\r\n', NULL, NULL, NULL, NULL),
(161, 0, 2, 21, '8', '002UPS008', '', 0, '3B1308X10626', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'intern technical', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TECHNICAL OFFICE', 'TECHNICAL\r\n', NULL, NULL, NULL, NULL),
(162, 0, 2, 21, '9', '002UPS009', 'SMC1500I', 0, '3S1523X00958', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'raphael.bukene', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TECHICAL OFFICE', 'TECHINICAL \r\n', NULL, NULL, NULL, NULL),
(163, 0, 2, 21, '10', '002UPS010', 'BV8001I-MSX', 0, '9B2146A03034', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'john mwaitalia', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'HSE MANAGER', 'HSE\r\n', NULL, NULL, NULL, NULL),
(164, 0, 2, 21, '11', '002UPS011', 'BVB00I-MSX', 0, '9B2139A10853', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'hse intern', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'HSE  OFFICE', 'HSE\r\n', NULL, NULL, NULL, NULL),
(165, 0, 2, 21, '12', '002UPS012', 'SMCI500I', 0, '3S1525XO5568', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'sunil.vedd', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'IT MANAGER', 'IT\r\n', NULL, NULL, NULL, NULL),
(166, 0, 2, 21, '13', '002UPS013', 'BV8001-MSX', 0, '9B2139A10854', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'sunil.vedd', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'IT MANAGER', 'IT\r\n', NULL, NULL, NULL, NULL),
(167, 0, 2, 21, '14', '002UPS014', 'BV800I-MSX', 0, '9B2146A03026', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'ALL STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TWIGA CONFERENCE ROOM', 'ALL STAFF\r\n', NULL, NULL, NULL, NULL),
(168, 0, 2, 21, '15', '002UPS015', 'BX650CI-AF', 0, '3B1308X12727', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'E&I TEAM', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'E&I', 'MAINTAINANCE\r\n', NULL, NULL, NULL, NULL),
(169, 0, 2, 21, '16', '002UPS016', 'BACK UPS 651', 0, 'N/A', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'IRON SERVER', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(170, 0, 2, 21, '17', '002UPS017', 'BACK UPS 650', 0, '3B0816X57142', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'MEC TEAM', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MEC', 'IT\r\n', NULL, NULL, NULL, NULL),
(171, 0, 2, 21, '18', '002UPS018', 'STX301032100000', 0, 'P40803 01 022D', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'IT&C', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(172, 0, 2, 21, '19', '002UPS019', 'BX650C1-AF', 0, '3B1429X13740', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'OPERATIONS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'LIBRARY', 'LIBRARY\r\n', NULL, NULL, NULL, NULL),
(173, 0, 2, 21, '20', '002UPS020', 'BX700UI', 0, '3B1818X74709', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'OPERATIONS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'LIBRARY', 'LIBRARY\r\n', NULL, NULL, NULL, NULL),
(174, 0, 2, 21, '21', '002UPS021', 'SMART UPS  1500', 0, '3S1500X02148', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'IT&C', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAIN GATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(175, 0, 1, 21, '22', '002UPS022', 'SUA 1500i', 0, 'AS1124121573', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'Operations', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC 1', 'IT\r\n', NULL, NULL, NULL, NULL),
(176, 0, 1, 21, '23', '002UPS023', 'SUA 1500i', 0, 'AS1110132591', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'Operations', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC 2', 'IT\r\n', NULL, NULL, NULL, NULL),
(177, 0, 1, 21, '24', '002UPS024', 'SMART UPS C 1500', 0, 'AS1404226703', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'Operations', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC 3&4', 'IT\r\n', NULL, NULL, NULL, NULL),
(178, 0, 1, 21, '25', '002UPS025', 'SURT10000XLI', 0, 'NS0637011172', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'Operations', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC 5', 'IT\r\n', NULL, NULL, NULL, NULL),
(179, 0, 1, 21, '26', '002UPS026', 'SMART UPS C 1500', 0, 'AS1404226699', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'Operations', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC 6', 'IT\r\n', NULL, NULL, NULL, NULL),
(180, 0, 4, 21, '27', '002UPS027', 'APC SYMMETRA LX  SYAF16KI', 0, 'QD1321260318', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(181, 0, 4, 21, '28', '002UPS028', 'APC SYMMETRA LX  SYAFSU16', 0, '5D1830T69967', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(182, 0, 4, 21, '29', '002UPS029', 'SOLARTEC AVR100-22', 0, '171400009', 'APC', 'AVR', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(183, 0, 4, 21, '30', '002UPS030', 'B8031FXS', 0, 'EI1W50001', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(184, 0, 2, 21, '31', '002UPS031', 'SMCI500I', 0, 'A51933163511', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'OPERATIONS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CONTROL ROOM', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(185, 0, 2, 21, '32', '002UPS032', 'BX650CI-AF', 0, '3B1429X13735', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'amanda mambona', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SUPPLY CHAIN', 'SUPPLY CHAIN\r\n', NULL, NULL, NULL, NULL),
(186, 0, 2, 21, '33', '002UPS033', 'BX650CI-AF', 0, '3B1435X23323', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'supply chain', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SUPPLY CHAIN', 'SUPPLY CHAIN\r\n', NULL, NULL, NULL, NULL),
(187, 0, 2, 21, '34', '002UPS034', 'BX650CI-AF', 0, '3B1305X10676', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'intern supply chain', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SUPPLY CHAIN', 'SUPPLY CHAIN\r\n', NULL, NULL, NULL, NULL),
(188, 0, 2, 21, '35', '002UPS035', 'BX650CI-AF', 0, '3B1427X0478', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'E&I TEAM', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'E&I', 'MAINTAINANCE\r\n', NULL, NULL, NULL, NULL),
(189, 0, 2, 21, '36', '002UPS036', 'BV800I-MSX', 0, '9B2139A12458', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'mary mwinukuzi', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TECHNICAL MANAGER', 'TECHINICAL \r\n', NULL, NULL, NULL, NULL),
(190, 0, 2, 21, '37', '002UPS037', 'BV800I-MSX', 0, '9B2139A12455', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'saleh salum', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OPERATION MANAGER', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(191, 0, 2, 21, '38', '002UPS038', 'SMC1500I', 0, '3S1541X05448', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR', 'OPERATIONS\r\n', NULL, NULL, NULL, NULL),
(192, 0, 2, 21, '39', '002UPS039', 'BX650CI-AF', 0, '3B1435X23023', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'twairan', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAINTAINANCE OFFICE', 'MAINTAINANCE\r\n', NULL, NULL, NULL, NULL),
(193, 0, 2, 21, '40', '002UPS040', 'BX650CI-AF', 0, '3B1429X14629', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'intern', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAINTAINANCE OFFICE', 'MAINTAINANCE\r\n', NULL, NULL, NULL, NULL),
(194, 0, 2, 21, '41', '002UPS041', 'BV800I-MSX', 0, '9B2139A12032', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'aaron mdemu', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAINTAINANCE MANAGER', 'MAINTAINANCE\r\n', NULL, NULL, NULL, NULL),
(195, 0, 2, 21, '42', '002UPS042', 'B8031FXS', 0, 'EI1Y10001', 'BORRI', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, '', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CCTV ROOM', 'CCTV\r\n', NULL, NULL, NULL, NULL),
(196, 0, 2, 21, '43', '002UPS043', 'BV800I-MSX', 0, '9B2139A12457', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'THIBELY MLUNZA', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'FINANCIA ACCOUNTING MANAGER', 'FINANCE\r\n', NULL, NULL, NULL, NULL),
(197, 0, 2, 21, '44', '002UPS044', 'BV800I-MSX', 0, '9B2139A12031', 'APC', 'UPS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, 'Firmware', 1, 1, 'MICHAEL MNGODO', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'PLANT MANAGER OFFICE', 'ADMINISTRATOR\r\n', NULL, NULL, NULL, NULL),
(198, 0, 2, 11, '1', '002AP001', 'APIN0225', 0, 'CNDFHMV033', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.101.12.29', 1, 12, '', '', '', '44:48:c1:c5:46:6C', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UPP-GROUND FLOOR //finance', 'IT\r\n', NULL, NULL, NULL, NULL),
(199, 0, 2, 11, '2', '002AP002', 'APIN0225', 0, 'CNDFHMV03T', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.101.12.28', 1, 12, '', '', '', '44:48:c1:c5:46:66', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UPP-FIRST FLOOR //technical', 'IT\r\n', NULL, NULL, NULL, NULL),
(200, 0, 2, 11, '3', '002AP003', 'APIN0225', 0, 'CNDFHMV035', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.101.12.39', 1, 12, '', '', '', '44:48:c1:c5:46:82', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UPP-FIRST FLOOR //coffeeroom', 'IT\r\n', NULL, NULL, NULL, NULL),
(201, 0, 2, 11, '4', '002AP004', 'APIN0225', 0, 'CNDFHMV03K', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.101.12.101', 1, 12, '', '', '', '44:48:c1:c5:56:8A', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UPP-GROUND FLOOR //simbaroom', 'IT\r\n', NULL, NULL, NULL, NULL),
(202, 0, 4, 11, '5', '004AP005', 'APIN0225', 0, 'CNHWK9Y1LT', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10..102.1.83', 1, 12, '', '', '', '9C:8C:D8:CF:4E:F8', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE', 'IT\r\n', NULL, NULL, NULL, NULL),
(203, 0, 4, 11, '6', '004AP006', 'APIN0225', 0, 'CNHWK9Y145', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10..102.1.94', 1, 12, '', '', '', '9C:8C:D8:CF:4D:F3', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE', 'IT\r\n', NULL, NULL, NULL, NULL),
(204, 0, 2, 11, '7', '002AP007', 'APIN0225', 0, 'CNDFHMV27R', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.102.12.201', 1, 12, '', '', '', '44:48:C1:C5:46:9E', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ANNEX BUILDING', 'IT\r\n', NULL, NULL, NULL, NULL),
(205, 0, 2, 11, '8', '002AP008', 'APIN0225', 0, 'CNDFHMV27T', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.101.12.130', 1, 12, '', '', '', '44:48:C1:C5:55:8E', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAINTENANCE OFFICE ARKING', 'IT\r\n', NULL, NULL, NULL, NULL),
(206, 0, 2, 11, '9', '002AP009', 'APIN0225', 0, 'CNDFHMV036', 'ARUBA', 'ACCESS POINT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 12, '', '', '', '44:48:C1:C5:46:6C', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SUPPLY CHAIN', 'IT\r\n', NULL, NULL, NULL, NULL),
(207, 0, 2, 9, '1', '002VC001', 'UTR-40', 0, '3720514', 'N/A', 'POWER AMP', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ALL STAFFS', '', '', 'N/A', 'N/A', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TWIGA CONFERENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(208, 0, 2, 9, '2', '002VC002', 'VXM-168LTS', 0, '14062460', 'N/A', 'MICROPHONE', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ALL STAFFS', '', '', 'N/A', 'N/A', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TWIGA CONFERENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(209, 0, 4, 9, '3', '004VC003', '', 0, '8G19304CE798F8', 'N/A', 'trio visual pro', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 3, 1, 'ALL STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TEMBO R-SQUARE', 'IT\r\n', NULL, NULL, NULL, NULL),
(210, 0, 2, 9, '4', '002VC004', 'LFZ - 019', 0, 'JR68210082268', 'LIFE SIZE', 'LIFE SIZE VIDEO CONFERENCE DEVICES', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ALL STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SIMBA CONFERENCE ROOM ', 'IT\r\n', NULL, NULL, NULL, NULL),
(211, 0, 2, 9, '5', '002VC005', 'TRIO 8800', 0, '64167FB85E40', 'POLYCOM', 'trio visual pro SET', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 3, 1, 'ALL STAFFS', '7.2.2.1094', '', '64.16.7F.B8.5E.40', '64.16.7F.B8.5E.41', '64.16.7F.B8.5E.42', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TWIGA CONFERENCE ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(212, 0, 4, 9, '6', '004VC006', 'Real presence group 500', 0, 'N/A', 'POLYCOM', 'VIDEO CONFERENCING KIT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 3, 1, 'ALL STAFFS', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'RHINO R-SQUARE', 'IT\r\n', NULL, NULL, NULL, NULL),
(213, 0, 2, 9, '7', '002VC007', 'TRIO 8800', 0, '0004F2FE6690', 'POLYCOM', 'VIDEO CONFERENCING KIT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 3, 1, 'ALL STAFFS', '', '', '', '00.04.F2.FE.66.91', '00.04.F2.FE.66.92', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SIMBA CONFERENCE ROOM ', 'IT\r\n', NULL, NULL, NULL, NULL),
(214, 0, 3, 9, '8', '003VC008', 'Real presence Trio Visual+', 0, 'N/A', 'POLYCOM', 'VIDEO CONFERENCING KIT', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 3, 1, 'MICHEAL MGONDO', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'PLANT MANAGER OFFICE', 'IT\r\n', NULL, NULL, NULL, NULL),
(215, 0, 1, 13, '1', '113001', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.11', 1, 1, 'WORKSHOP PMCARPARKING -1', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:bf', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WORKSHOP PMCARPARKING -1', 'IT\r\n', NULL, NULL, NULL, NULL),
(216, 0, 1, 13, '2', '113002', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.12', 1, 1, 'WORKSHOP STORE ROOM A/C -1', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:73', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WORKSHOP STORE ROOM A/C -1', 'IT\r\n', NULL, NULL, NULL, NULL),
(217, 0, 1, 13, '3', '113003', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.13', 1, 1, 'WORKSHOP STORE ROOM A/C -2', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:e0', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WORKSHOP STORE ROOM A/C -2', 'IT\r\n', NULL, NULL, NULL, NULL),
(218, 0, 1, 13, '4', '113004', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.14', 1, 1, 'WORKSHOP - 2', '22.5.0.93', '', '1C:C3:16:02:20:0F', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WORKSHOP - 2', 'IT\r\n', NULL, NULL, NULL, NULL),
(219, 0, 1, 13, '5', '113005', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.15', 1, 1, 'WORKSHOP 1', '30.6.0.41', '', '1C:C3:16:11:1B:6F', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WORKSHOP 1', 'IT\r\n', NULL, NULL, NULL, NULL),
(220, 0, 1, 13, '6', '113006', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.16', 1, 1, 'WORKSHOP - WAREHOUSE ENTR', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:9b', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WORKSHOP - WAREHOUSE ENTR', 'IT\r\n', NULL, NULL, NULL, NULL),
(221, 0, 1, 13, '7', '113007', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.18', 1, 1, 'WAREHOUSE FRONT', '22.5.0.93', '', '1C:C3:16:02:3C:34', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WAREHOUSE FRONT', 'IT\r\n', NULL, NULL, NULL, NULL),
(222, 0, 1, 13, '8', '113008', 'MILESIGHT MS-C3262-FPN', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.31', 1, 1, 'UGT2 POLE SOC', '30.6.0.41', '', '1C:C3:16:11:1B:82', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT2 POLE SOC', 'IT\r\n', NULL, NULL, NULL, NULL),
(223, 0, 1, 13, '9', '113009', 'MILESIGHTB MS-C3262-FPN', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.22', 1, 1, 'MCC1 BACK ENTRANCE', '26.5.0.93', '', '1C:C3:16:02:31:5B', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC1 BACK ENTRANCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(224, 0, 1, 13, '10', '113010', 'MILESIGHT MS-C3362-FPN', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.23', 1, 1, 'UGT2 ENTRANCE', '22.5.0.93', '', '1C:C3:16:02:3B:77', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT2 ENTRANCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(225, 0, 1, 13, '11', '113011', 'MILESIGHT MS-C3362-FPN', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.24', 1, 1, 'UGT1 POLE OIL STORAGE', '22.5.0.93', '', '1C:C3:16:02:3B:7D', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT1 POLE OIL STORAGE', 'IT\r\n', NULL, NULL, NULL, NULL),
(226, 0, 1, 13, '12', '113012', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.25', 1, 1, 'UGT2 EXHAUST STACK', '30.6.0.41', '', '1C:C3:16:11:1E:7E', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT2 EXHAUST STACK', 'IT\r\n', NULL, NULL, NULL, NULL),
(227, 0, 1, 13, '13', '113013', 'MILESIGHT MS-C3262-FPN', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.26', 1, 1, 'UGT1/2 FENCE', '26.5.0.93', '', '1C:C3:16:02:31:46', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT1/2 FENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(228, 0, 1, 13, '14', '113014', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.27', 1, 1, 'MCC - 2', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:15', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC - 2', 'IT\r\n', NULL, NULL, NULL, NULL),
(229, 0, 1, 13, '15', '113015', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.28', 1, 1, 'MCC1/2 - 2', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:f3', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC1/2 - 2', 'IT\r\n', NULL, NULL, NULL, NULL),
(230, 0, 1, 13, '16', '113016', 'MILESIGHT MS-C3262-FPN', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.184', 1, 1, 'UGT2 PACKAGE', '30.6.0.41', '', '1C:C3:16:02:3F:99', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT2 PACKAGE', 'IT\r\n', NULL, NULL, NULL, NULL),
(231, 0, 1, 13, '17', '113017', 'MILESIGHT MS-C3262-FPN', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.181', 1, 1, 'UGT1 PACKAGE', '26.5.0.93', '', '1C:C3:16:11:01:2D', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT1 PACKAGE', 'IT\r\n', NULL, NULL, NULL, NULL),
(232, 0, 1, 13, '18', '113018', 'MILESIGHT DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.30', 1, 1, 'ugt1/2 400 SWITCHGEAR', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:9f', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ugt1/2 400 SWITCHGEAR', 'IT\r\n', NULL, NULL, NULL, NULL),
(233, 0, 1, 13, '19', '113019', 'MILESIGHT DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.37', 1, 1, 'SOUTH GATE GUARD HOUSE', 'V5.7.2 build 211230', '', '40:ac:bf:4d:ca:24', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SOUTH GATE GUARD HOUSE', 'IT\r\n', NULL, NULL, NULL, NULL),
(234, 0, 1, 13, '20', '113020', 'MILESIGHT DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.38', 1, 1, 'SOUTH GATE SCRAP YARD FENCE', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6b:24', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SOUTH GATE SCRAP YARD FENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(235, 0, 1, 13, '21', '113021', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.39', 1, 1, 'SOUTH SKID POLE UGT6 - 1', 'V5.7.2 build 211230', '', '40:ac:bf:4d:ca:31', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SOUTH SKID POLE UGT6 - 1', 'IT\r\n', NULL, NULL, NULL, NULL),
(236, 0, 1, 13, '22', '113022', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.40', 1, 1, 'UGT5 - MAINGATE', '30.6.0.25', '', '1C:C3:16:11:01:38', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT5 - MAINGATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(237, 0, 1, 13, '23', '113023', 'IQEYE IQEYE832N', 0, 'N/A', 'IQEYE', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.41', 1, 1, 'SOUTH GATE', '27.5.0.100', '', '1C:C3:16:02:3F:94', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SOUTH GATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(238, 0, 1, 13, '24', '113024', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.42', 1, 1, 'SOUTH GATE-UGT5', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:c4', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SOUTH GATE-UGT5', 'IT\r\n', NULL, NULL, NULL, NULL),
(239, 0, 1, 13, '25', '113025', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.48', 1, 1, 'CHILLER-TANESCO FENCE', 'V5.7.2 build 211230', '', '40:ac:bf:4d:c9:a0', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CHILLER-TANESCO FENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(240, 0, 1, 13, '26', '113026', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.49', 1, 1, 'CHEM STORE TO UGT1', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:e0', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CHEM STORE TO UGT1', 'IT\r\n', NULL, NULL, NULL, NULL),
(241, 0, 1, 13, '27', '113027', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.50', 1, 1, 'CHEM STORE -CHILLERS', 'V5.5.82 build 190130', '', '84:9a:40:eb:61:15', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CHEM STORE -CHILLERS', 'IT\r\n', NULL, NULL, NULL, NULL),
(242, 0, 1, 13, '28', '113028', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.52', 1, 1, 'TANESCO FENCE BEHIND MCC3/4/5', 'V5.7.2 build 211230', '', '40:ac:bf:4d:c9:ef', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TANESCO FENCE BEHIND MCC3/4/5', 'IT\r\n', NULL, NULL, NULL, NULL),
(243, 0, 1, 13, '29', '113029', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.53', 1, 1, 'TANESCO GATE3 NEAR UGT2', '22.5.0.93', '', '1C:C3:16:02:3C:83', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TANESCO GATE3 NEAR UGT2', 'IT\r\n', NULL, NULL, NULL, NULL),
(244, 0, 1, 13, '30', '113030', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.54', 1, 1, 'MCC2 ENTRANCE', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6b:9c', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC2 ENTRANCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(245, 0, 1, 13, '31', '113031', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.55', 1, 1, 'OIL STORAGE TANESCO FENCE', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:8b', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OIL STORAGE TANESCO FENCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(246, 0, 1, 13, '32', '113032', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.60', 1, 1, 'UGT4 GENERATOR BACK DOOR', '30.6.0.25', '', '1C:C3:16:11:01:22', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT4 GENERATOR BACK DOOR', 'IT\r\n', NULL, NULL, NULL, NULL),
(247, 0, 1, 13, '33', '113033', 'MILESIGHT MS-C3566-VP', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.61', 1, 1, 'CABLE TRAY-MCC3/4', '', '', '1C:C3:16:02:3B:7D ', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CABLE TRAY-MCC3/4', 'IT\r\n', NULL, NULL, NULL, NULL),
(248, 0, 1, 13, '34', '113034', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.62', 1, 1, 'MCC3/4 - 2', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:d8', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC3/4 - 2', 'IT\r\n', NULL, NULL, NULL, NULL),
(249, 0, 1, 13, '35', '113035', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.63', 1, 1, 'MCC3/4 - BATTERY ROOM', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:b8', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC3/4 - BATTERY ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(250, 0, 1, 13, '36', '113036', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.64', 1, 1, 'MCC3/4 - 1', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:3c', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC3/4 - 1', 'IT\r\n', NULL, NULL, NULL, NULL),
(251, 0, 1, 13, '37', '113037', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.65', 1, 1, 'CABLE TRAY TO SYMBION', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:be', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CABLE TRAY TO SYMBION', 'IT\r\n', NULL, NULL, NULL, NULL),
(252, 0, 1, 13, '38', '113038', 'IQEYE IQEYE832N', 0, 'N/A', 'IQEYE', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.71', 1, 1, 'UGT3 TANESCO FENCE1', '26.5.0.93', '', '1C:C3:16:11:1B:76', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT3 TANESCO FENCE1', 'IT\r\n', NULL, NULL, NULL, NULL),
(253, 0, 1, 13, '39', '113039', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.66', 1, 1, 'MCC5 -2', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:28', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC5 -2', 'IT\r\n', NULL, NULL, NULL, NULL),
(254, 0, 1, 13, '40', '113040', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.67', 1, 1, 'BEHIND MCC3/4/5', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6b:17', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'BEHIND MCC3/4/5', 'IT\r\n', NULL, NULL, NULL, NULL),
(255, 0, 1, 13, '41', '113041', 'MILESIGHT MS-C3362-FPN', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.68', 1, 1, 'CHILLER AREA3', '22.5.0.93', '', '1C:C3:16:02:3B:75', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CHILLER AREA3', 'IT\r\n', NULL, NULL, NULL, NULL),
(256, 0, 1, 13, '42', '113042', 'HIKIVISION  DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.69', 1, 1, 'PACKING SOC/ANNEX ', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6b:9e', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'PACKING SOC/ANNEX ', 'IT\r\n', NULL, NULL, NULL, NULL),
(257, 0, 1, 13, '43', '113043', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.70', 1, 1, 'MCC3/4/5 ENTRANCE', '30.6.0.41', '', '1C:C3:16:11:1B:76', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC3/4/5 ENTRANCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(258, 0, 1, 13, '44', '113044', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.51', 1, 1, 'CHILLER AREA1', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:f9', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CHILLER AREA1', 'IT\r\n', NULL, NULL, NULL, NULL),
(259, 0, 1, 13, '45', '113045', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.77', 1, 1, 'UGT3 GENERATOR BACK DOOR', 'V5.7.2 build 211230', '', '40:ac:bf:4d:ca:7b', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT3 GENERATOR BACK DOOR', 'IT\r\n', NULL, NULL, NULL, NULL),
(260, 0, 1, 13, '46', '113046', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.78', 1, 1, 'UGT3 -INSTRUMENT AIR', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:cd', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT3 -INSTRUMENT AIR', 'IT\r\n', NULL, NULL, NULL, NULL),
(261, 0, 1, 13, '47', '113047', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.79', 1, 1, 'SYMBION FENCE CABLE TRAY', '30.6.0.41', '', '1C:C3:16:11:1B:71', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SYMBION FENCE CABLE TRAY', 'IT\r\n', NULL, NULL, NULL, NULL),
(262, 0, 1, 13, '48', '113048', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.80', 1, 1, 'UGT3 ATLAS COPCO', '30.6.0.25', '', '1C:C3:16:11:01:28', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT3 ATLAS COPCO', 'IT\r\n', NULL, NULL, NULL, NULL),
(263, 0, 1, 13, '49', '113049', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.82', 1, 1, 'UGT3-4-5-SKID', 'V5.5.82 build 190130', '', '84:9a:40:eb:60:e2', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT3-4-5-SKID', 'IT\r\n', NULL, NULL, NULL, NULL),
(264, 0, 1, 13, '50', '113050', 'HIKIVISION DS-2CD2642FWD-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.81', 1, 1, 'UGT3  TANESCO', 'V5.5.0 build 170725', '', 'b4:a3:82:28:6f:74', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT3  TANESCO', 'IT\r\n', NULL, NULL, NULL, NULL),
(265, 0, 1, 13, '51', '113051', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.86', 1, 1, 'TOWER TO RO TANK', 'V5.7.2 build 211230', '', '40:ac:bf:4d:ca:68', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TOWER TO RO TANK', 'IT\r\n', NULL, NULL, NULL, NULL),
(266, 0, 1, 13, '52', '113052', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.87', 1, 1, 'TOWER TO WAREHOUSE  3', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6b:ac', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TOWER TO WAREHOUSE  3', 'IT\r\n', NULL, NULL, NULL, NULL),
(267, 0, 1, 13, '53', '113053', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.88', 1, 1, 'DM PLANT TO UGT5 LUBE OIL COOLER', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:0a', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'DM PLANT TO UGT5 LUBE OIL COOLER', 'IT\r\n', NULL, NULL, NULL, NULL),
(268, 0, 1, 13, '54', '113054', 'MILESIGHT MS-C3262-FPNA', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.89', 1, 1, 'UGT6 POLE TANESCO FANCE', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:28', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UGT6 POLE TANESCO FANCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(269, 0, 1, 13, '55', '113055', 'HIKIVISION DS-2DE5220IW-AE', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.90', 1, 1, 'PTZ TOWER', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:f3', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'PTZ TOWER', 'IT\r\n', NULL, NULL, NULL, NULL),
(270, 0, 1, 13, '56', '113056', 'MILESIGHT MS-C3262-VP', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.91', 1, 1, 'DM PLANT TO UGT5', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:cc', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'DM PLANT TO UGT5', 'IT\r\n', NULL, NULL, NULL, NULL),
(271, 0, 1, 13, '57', '113057', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.97', 1, 1, 'MCC6 SCARP YARD 1', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6b:5b', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC6 SCARP YARD 1', 'IT\r\n', NULL, NULL, NULL, NULL),
(272, 0, 1, 13, '58', '113058', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.98', 1, 1, 'MCC6 SCRAP YARD 2', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6a:e3', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC6 SCRAP YARD 2', 'IT\r\n', NULL, NULL, NULL, NULL),
(273, 0, 1, 13, '59', '113059', 'HIKIVISION DS-2CD2642FWD-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.99', 1, 1, 'MCC6 SCRAP YARD3', 'V5.5.0 build 170725', '', 'b4:a3:82:28:6e:e9', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC6 SCRAP YARD3', 'IT\r\n', NULL, NULL, NULL, NULL),
(274, 0, 1, 13, '60', '113060', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.100', 1, 1, 'MCC6', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:0a', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC6', 'IT\r\n', NULL, NULL, NULL, NULL),
(275, 0, 1, 13, '61', '113061', 'IQEYE IQEYE832N', 0, 'N/A', 'IQEYE', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.106', 1, 1, 'MAINGATE OUT', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:10', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAINGATE OUT', 'IT\r\n', NULL, NULL, NULL, NULL),
(276, 0, 2, 13, '62', '213062', 'HIKIVISION DS-2CD2642FWD-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.107', 1, 1, 'GUARD HOUSE ROOM', 'V5.5.0 build 170725', '', 'b4:a3:82:28:6f:3d', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'GUARD HOUSE ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(277, 0, 2, 13, '63', '213063', 'DH-IPC-HDW1000SP', 0, 'N/A', 'JHUA', 'CAMERA', 0, 0, '2022-11-11', '2022-11-20 22:50:05', 1, '10.100.13.108', 1, 1, 'GUARD HOUSE VISITORS ROOM', '\"2.420.0000.0.R', ' build \"', '', '4c:11:bf:a5:ad:b0', '', '', '0000-00-00', '0000-00-00', 1, 'uploads/Data.csv', '1', 'GUARD HOUSE VISITORS ROOM', NULL, NULL, NULL, NULL),
(278, 0, 1, 13, '64', '113064', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.109', 1, 1, 'TOWARDS NORTH', 'V5.5.82 build 190130', '', '84:9a:40:eb:61:a4', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TOWARDS NORTH', 'IT\r\n', NULL, NULL, NULL, NULL),
(279, 0, 1, 13, '65', '113065', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.110', 1, 1, 'TOWARDS SOUTH', 'V5.5.82 build 190130', '', '84:9a:40:eb:61:0d', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'TOWARDS SOUTH', 'IT\r\n', NULL, NULL, NULL, NULL),
(280, 0, 2, 13, '66', '213066', 'HIKIVISION DS-2CD2642FWD-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.117', 1, 1, 'DINING HALL', 'V5.5.0 build 170725', '', 'b4:a3:82:28:6f:21', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'DINING HALL', 'IT\r\n', NULL, NULL, NULL, NULL),
(281, 0, 2, 13, '67', '213067', 'HIKIVISION DS-2CD2642FWD-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.118', 1, 1, 'ANNEX CORRIDOR', 'V5.5.0 build 170725', '', 'b4:a3:82:28:6f:5b', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ANNEX CORRIDOR', 'IT\r\n', NULL, NULL, NULL, NULL),
(282, 0, 2, 13, '68', '213068', 'HIKIVISION DS-2CD2642FWD-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.119', 1, 1, 'OnM -TECHNICAL OFFICE', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:b4', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OnM -TECHNICAL OFFICE', 'IT\r\n', NULL, NULL, NULL, NULL),
(283, 0, 2, 13, '69', '213069', 'HIKIVISION DS-2CD2642FWD-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.120', 1, 1, 'ANNEX PARKING', 'V5.5.0 build 170725', '', 'b4:a3:82:28:6f:16', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ANNEX PARKING', 'IT\r\n', NULL, NULL, NULL, NULL),
(284, 0, 2, 13, '70', '213070', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.121', 1, 1, 'FINANCE TO TOILET', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:fb', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'FINANCE TO TOILET', 'IT\r\n', NULL, NULL, NULL, NULL),
(285, 0, 2, 13, '71', '213071', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.123', 1, 1, 'CONF RM 1(TWIGA)', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:cc', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'CONF RM 1(TWIGA)', 'IT\r\n', NULL, NULL, NULL, NULL),
(286, 0, 2, 13, '72', '213072', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.124', 1, 1, 'GF FCM TO PM', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:c5', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'GF FCM TO PM', 'IT\r\n', NULL, NULL, NULL, NULL),
(287, 0, 2, 13, '73', '213073', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.125', 1, 1, 'MCR - ENFAB', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:e2', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR - ENFAB', 'IT\r\n', NULL, NULL, NULL, NULL),
(288, 0, 2, 13, '74', '213074', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.126', 1, 1, 'MCR - CRO-1', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:10', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR - CRO-1', 'IT\r\n', NULL, NULL, NULL, NULL),
(289, 0, 2, 13, '75', '213075', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.127', 1, 1, 'ITM - EXIT DOOR', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:c4', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ITM - EXIT DOOR', 'IT\r\n', NULL, NULL, NULL, NULL),
(290, 0, 2, 13, '76', '213076', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.128', 1, 1, 'LIBRARY', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:f4', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'LIBRARY', 'IT\r\n', NULL, NULL, NULL, NULL),
(291, 0, 2, 13, '77', '213077', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.129', 1, 1, 'OnM -CRO', 'v5.3.0 build 150514', '', 'c4:2f:90:c9:22:dd', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'OnM -CRO', 'IT\r\n', NULL, NULL, NULL, NULL),
(292, 0, 2, 13, '78', '213078', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.130', 1, 1, 'GF - FCM - OFFICE', 'v5.3.0 build 150515', '', 'c4:2f:90:c9:22:bc', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'GF - FCM - OFFICE', 'IT\r\n', NULL, NULL, NULL, NULL),
(293, 0, 2, 13, '79', '213079', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.131', 1, 1, 'UPS ROOM', 'v5.3.0 build 150516', '', 'c4:2f:90:c9:22:fa', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'UPS ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(294, 0, 2, 13, '80', '213080', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.132', 1, 1, 'FF - TOILET - MCR', 'v5.3.0 build 150517', '', 'c4:2f:90:c9:23:16', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'FF - TOILET - MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(295, 0, 2, 13, '81', '213081', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.133', 1, 1, 'MCR-CRO-2', 'v5.3.0 build 150518', '', 'c4:2f:90:c9:22:bd', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR-CRO-2', 'IT\r\n', NULL, NULL, NULL, NULL),
(296, 0, 2, 13, '82', '213082', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.135', 1, 1, 'MAINGATE', 'V5.5.82 build 190130', '', '84:9a:40:eb:61:87', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAINGATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(297, 0, 2, 13, '83', '213083', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.141', 1, 1, 'WAREHOUSE - 3', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6b:2d', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WAREHOUSE - 3', 'IT\r\n', NULL, NULL, NULL, NULL),
(298, 0, 2, 13, '84', '213084', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.140', 1, 1, 'WAREHOUSE - 1', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:23:20', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WAREHOUSE - 1', 'IT\r\n', NULL, NULL, NULL, NULL),
(299, 0, 2, 13, '85', '213085', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.139', 1, 1, 'WAREHOUSE - 2', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:ec', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WAREHOUSE - 2', 'IT\r\n', NULL, NULL, NULL, NULL),
(300, 0, 1, 13, '86', '113086', 'MILESIGHT MS-C3362-FP', 0, 'N/A', 'MILESIGHT', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'WORKSHOP UGT1/2 SKID', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WORKSHOP UGT1/2 SKID', 'IT\r\n', NULL, NULL, NULL, NULL);
INSERT INTO `assetmasterdata` (`assetmasterdataid`, `departmentid`, `locationid`, `asseclassification_id`, `ano`, `acode`, `description`, `modelid`, `serialnumber`, `manufacturer`, `netbiosname`, `usersid`, `createdby`, `createddate`, `createdtime`, `softwaregroupid`, `softwareinstalleddescription`, `ipaddressgroupid`, `vlan`, `switchdescription`, `biosversion`, `biosyear`, `macadressethernet`, `macaddresswifi`, `macadressbluetooth`, `imeinumber`, `purchasedate`, `warrantyperiod`, `assetstateid`, `csv_file`, `locations`, `departments`, `otnetworktypeid`, `otitemnumber`, `otdeviceserialnumber`, `assettypeid`) VALUES
(301, 0, 1, 13, '87', '113087', 'IQEYE IQEYE852', 0, 'N/A', 'IQEYE', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.143', 1, 1, 'WAREHOUSE BACK FANCE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WAREHOUSE BACK FANCE', 'IT\r\n', NULL, NULL, NULL, NULL),
(302, 0, 1, 13, '88', '113088', 'HIKIVISION DS-2CD2642FWD-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.142', 1, 1, 'BEHIND WAREHOUSE', 'V5.5.0 build 170725', '', 'b4:a3:82:28:6e:ec', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'BEHIND WAREHOUSE', 'IT\r\n', NULL, NULL, NULL, NULL),
(303, 0, 1, 13, '89', '113089', 'HIKIVISION DS-2CD2112-I', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.146', 1, 1, 'MCC5 - 1', 'v5.3.0 build 150513', '', 'c4:2f:90:c9:22:db', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC5 - 1', 'IT\r\n', NULL, NULL, NULL, NULL),
(304, 0, 1, 13, '90', '113090', 'UBIQUIT EDGE SWITCH 16 150W', 0, 'N/A', 'UBIQUIT', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ZONE-1', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ZONE-1', 'IT\r\n', NULL, NULL, NULL, NULL),
(305, 0, 1, 13, '91', '113091', 'UBIQUIT EDGE SWITCH 16 150W', 0, 'N/A', 'UBIQUIT', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ZONE-2', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ZONE-2', 'IT\r\n', NULL, NULL, NULL, NULL),
(306, 0, 1, 13, '92', '113092', 'UBIQUIT EDGE SWITCH 16 150W', 0, 'N/A', 'UBIQUIT', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ZONE-4', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ZONE-4', 'IT\r\n', NULL, NULL, NULL, NULL),
(307, 0, 1, 13, '93', '113093', 'UBIQUIT EDGE SWITCH 16 150W', 0, 'N/A', 'UBIQUIT', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ZONE-5', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ZONE-5', 'IT\r\n', NULL, NULL, NULL, NULL),
(308, 0, 1, 13, '94', '113094', 'DIGITUS POE SWITCH', 0, 'N/A', 'DIGITUS', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ZONE-5', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ZONE-5', 'IT\r\n', NULL, NULL, NULL, NULL),
(309, 0, 1, 13, '95', '113095', 'UBIQUIT EDGE SWITCH 16 150W', 0, 'N/A', 'UBIQUIT', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ZONE-6', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ZONE-6', 'IT\r\n', NULL, NULL, NULL, NULL),
(310, 0, 1, 13, '96', '113096', 'UBIQUIT EDGE SWITCH 16 150W', 0, 'N/A', 'UBIQUIT', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ZONE-7', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ZONE-7', 'IT\r\n', NULL, NULL, NULL, NULL),
(311, 0, 1, 13, '97', '113097', 'PLANET IGS-10020HPT', 0, 'N/A', 'PLANET', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'MCC - 6', '', '', 'A8:F7:E0:35:71:62', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC - 6', 'IT\r\n', NULL, NULL, NULL, NULL),
(312, 0, 1, 13, '98', '113098', 'UBIQUIT EDGE SWITCH 16 150W', 0, 'N/A', 'UBIQUIT', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ZONE-3', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ZONE-3', 'IT\r\n', NULL, NULL, NULL, NULL),
(313, 0, 1, 13, '99', '113099', 'CISCO CATALYST 3560G', 0, 'N/A', 'CISCO', 'SWITCH', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'MCC5 FOC NETSWITCH', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCC5 FOC NETSWITCH', 'IT\r\n', NULL, NULL, NULL, NULL),
(314, 0, 2, 13, '100', '213100', 'NITGEN SW101M1R', 0, '14361AAY0046', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'MAIN GATE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAIN GATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(315, 0, 2, 13, '101', '213101', 'NITGEN SW101M1R', 0, '14361aay0048', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'MAIN GATE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAIN GATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(316, 0, 2, 13, '102', '213102', 'NITGEN SW101M1R', 0, '14361aay0047', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, '14361aay0047', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', '14361aay0047', 'IT\r\n', NULL, NULL, NULL, NULL),
(317, 0, 2, 13, '103', '213103', 'NITGEN SW101M1R', 0, '14361aay0049', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'SOUTH GATE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SOUTH GATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(318, 0, 2, 13, '104', '213104', 'MS7120', 0, '2S 14192978', 'MS', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'MAIN GATE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MAIN GATE', 'IT\r\n', NULL, NULL, NULL, NULL),
(319, 0, 2, 13, '105', '213105', 'NITGEN SW101M1R', 0, '14361AAY0046', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'SERVER ROOM', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(320, 0, 2, 13, '106', '213106', 'NITGEN SW101M1R', 0, '14361aay0048', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'WAREHOUSE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WAREHOUSE', 'IT\r\n', NULL, NULL, NULL, NULL),
(321, 0, 2, 13, '107', '213107', 'NITGEN SW101M1R', 0, '14361aay0047', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'WAREHOUSE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'WAREHOUSE', 'IT\r\n', NULL, NULL, NULL, NULL),
(322, 0, 2, 13, '108', '213108', 'NITGEN SW101M1R', 0, '14361aay0049', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'MCR', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'MCR', 'IT\r\n', NULL, NULL, NULL, NULL),
(323, 0, 2, 13, '109', '213109', 'NITGEN SW101M1R', 0, '14361aay0049', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'FIRST FLOOR EXIT DOOR', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'FIRST FLOOR EXIT DOOR', 'IT\r\n', NULL, NULL, NULL, NULL),
(324, 0, 2, 13, '110', '213110', 'NITGEN SW101M1R', 0, '14361aay0049', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'ENTRANCE GROUNG FLOOR', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ENTRANCE GROUNG FLOOR', 'IT\r\n', NULL, NULL, NULL, NULL),
(325, 0, 4, 13, '111', '413111', 'NITGEN SW101M2 R', 0, '18251AD60180', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.102.1.40', 1, 1, 'R-SQUARE SERVER ROOM', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE SERVER ROOM', 'IT\r\n', NULL, NULL, NULL, NULL),
(326, 0, 4, 13, '112', '413112', 'NITGEN SW101M2 R', 0, 'NAA28OO11UTBJBG20310', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.102.1.33', 1, 1, 'R-SQUARE ENTRANCE RECEPTION', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE ENTRANCE RECEPTION', 'IT\r\n', NULL, NULL, NULL, NULL),
(327, 0, 4, 13, '113', '413113', 'NITGEN SW101M2 R', 0, 'N/A', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.102.1.41', 1, 1, 'R-SQUARE EXIT RECEPTION', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE EXIT RECEPTION', 'IT\r\n', NULL, NULL, NULL, NULL),
(328, 0, 4, 13, '114', '413114', 'NITGEN SW101M2 R', 0, '17161AB60045', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.102.1.38', 1, 1, 'R-SQUARE EXIT MD ', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE EXIT MD ', 'IT\r\n', NULL, NULL, NULL, NULL),
(329, 0, 4, 13, '115', '413115', 'NITGEN SW101M2 R', 0, '17161AB60070', 'NITGEN', 'FINGER KEY ACCESS', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.102.1.39', 1, 1, 'ENTRANCE MD R-SQUARE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'ENTRANCE MD R-SQUARE', 'IT\r\n', NULL, NULL, NULL, NULL),
(330, 0, 4, 13, '116', '413116', '', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '', 1, 1, 'R-SQUARE', '', '', '', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'R-SQUARE', 'IT\r\n', NULL, NULL, NULL, NULL),
(331, 0, 1, 13, '117', '113117', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.155', 1, 1, 'SCRAP YARD 4', 'V5.5.88 build 200610', '', 'ec:c8:9c:28:6b:27', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SCRAP YARD 4', 'IT\r\n', NULL, NULL, NULL, NULL),
(332, 0, 1, 13, '118', '113118', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.156', 1, 1, 'SCRAP YARD 5', 'V5.7.2 build 211230', '', '40:ac:bf:4d:c9:c6', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SCRAP YARD 5', 'IT\r\n', NULL, NULL, NULL, NULL),
(333, 0, 1, 13, '119', '113119', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.157', 1, 1, 'SCRAP YARD 7', 'V5.7.2 build 211230', '', '40:ac:bf:4d:ca:6f', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SCRAP YARD 7', 'IT\r\n', NULL, NULL, NULL, NULL),
(334, 0, 1, 13, '120', '113120', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.157', 1, 1, 'SCRAP YARD 7', 'V5.7.2 build 211230', '', '40:ac:bf:4d:ca:6f', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SCRAP YARD 7', 'IT\r\n', NULL, NULL, NULL, NULL),
(335, 0, 1, 13, '121', '113121', 'HIKIVISION DS-2CD1643G0-IZ', 0, 'N/A', 'HIKIVISION', 'CAMERA', 0, 0, '2022-11-11', '2022-11-15 14:05:16', 1, '10.100.13.160', 1, 1, 'SCRAP YARD 9', 'V5.7.2 build 211230', '', '40:ac:bf:4d:ca:12', '', '', 'N/A', '0000-00-00', 'N/A', 1, 'uploads/Data.csv', 'SCRAP YARD 9', 'IT\r\n', NULL, NULL, NULL, NULL),
(336, 0, 7, 24, '9', '172400009', 'DELL', 0, 'CN-04RFMK-64180-54H-1A0S', '', 'CONNECTED TO MAX3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(337, 0, 12, 36, '99', '2123600099', 'WOODWARD MICRONET PLUS DIGITAL CONTROL', 0, '2.17E+11', '', 'MICRONET UGT6', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(338, 0, 12, 25, '100', '2122500100', 'NEXCOM', 0, '', '', 'UGT6 OSM', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(339, 0, 12, 38, '101', '2123800101', '350 BENTLEY NEVADA', 0, '', '', 'COMMUNICATION GATEWAY BENTLY NEVADA', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(340, 0, 7, 34, '102', '273400102', 'Hp Color Laserjet Pro M254nw', 0, '', '', 'GE PRINTER', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(341, 0, 6, 32, '103', '263200103', 'CISCO 892FSP', 0, 'FC22523R11JJ', '', 'GE ROUTER', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(342, 0, 6, 26, '104', '362600104', '', 0, '', '', 'METERING SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(343, 0, 6, 31, '105', '363100105', '', 0, '', '', 'METERING01 OPC W2K3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 2003', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(344, 0, 6, 31, '106', '363100106', '', 0, '', '', 'METERING02 OPC W2K12', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '2012', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(345, 0, 7, 25, '107', '372500107', '', 0, '', '', 'Reports PC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 7', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(346, 0, 7, 25, '108', '372500108', '', 0, '', '', 'W/S ? CR10X connected to OPC WXPSP3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(347, 0, 7, 24, '10', '172400010', 'DELL', 0, 'CN-04RFMK-64180-54H-010S', '', 'CONNECTED TO MAX3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(348, 0, 7, 25, '109', '372500109', '', 0, '', '', 'W/S ? CR1000X - OPC WXPSP3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(349, 0, 6, 31, '110', '363100110', '', 0, '', '', 'MAX6-ETAPRO-OPC W2K12', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(350, 0, 13, 39, '111', '3133900111', '', 0, '', '', 'Campbell CR10x Datalogger', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(351, 0, 13, 39, '112', '3133900112', '', 0, '', '', 'Campbell CR1000 Datalogger', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(352, 0, 7, 26, '113', '372600113', '', 0, '', '', 'PLANET ISW-801T 10/100 S/N:AH00309900057', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, 'N/A', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 3, NULL, NULL, NULL),
(353, 0, 7, 25, '114', '472500114', '', 0, 'CZC138C6ZQ', '', 'CHILLER HMI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '192.168.0.12', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 4, NULL, NULL, NULL),
(354, 0, 7, 40, '115', '474000115', '', 0, '', '', 'CHILLER PLC ALLEN BRADLY COMPACTLOGIX L32E', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 4, NULL, NULL, NULL),
(355, 0, 7, 26, '116', '472600116', '', 0, '', '', 'CHILLER PANNEL SWITCH - KORENIX JETNET 3008 8 PORT', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 4, NULL, NULL, NULL),
(356, 0, 7, 41, '117', '474100117', '', 0, '', '', 'REMOTE I/O RACK', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 4, NULL, NULL, NULL),
(357, 0, 7, 42, '118', '574200118', ' ISW-801T 10/100', 0, '', '', 'YFGW410 Field Wireless Management U02 ', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 5, NULL, NULL, NULL),
(358, 0, 7, 24, '11', '172400011', 'DELL', 0, 'CN-04RFMK-64180-54H-19MS', '', 'CONNECTED TO MAX4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(359, 0, 7, 26, '119', '272600119', '', 0, 'S/N:AH0030990072', '', 'SWITCH ? PLANET  LOCATION: CABINET U02', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(360, 0, 7, 37, '120', '573700120', '', 0, '', '', 'YFGW510A1ANN Gateway F/W: R1.07.01 NAME: BBR001 Standard: ISA100.11a', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 5, NULL, NULL, NULL),
(361, 0, 7, 24, '12', '172400012', 'SAMSUNG', 0, 'SAMSUNG TV08????', '', 'CONNECTED TO MAX4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(362, 0, 7, 24, '13', '172400013', 'DELL', 0, 'CN-04RFMK-64180-54H-19KS', '', 'CONNECTED TO OPER4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(363, 0, 6, 24, '14', '162400014', 'DELL', 0, 'CN-0V7JP5-QDC00-8B5-F4VL-A02', '', 'DISPLAY KVM DCS CABINET(Historian)', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(364, 0, 7, 25, '15', '172500015', 'Precision 5820 8 GB 8 Cores @3.70 GHz 237 GB', 0, '28WZY23', '', 'OPER1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.10172.16.160.10172.17.160.10', '2.0.2', ' ', '68-05-CA-B3-AC-68', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(365, 0, 7, 25, '16', '172500016', 'Precision 5820 8 GB 8 Cores @3.70 GHz 237 GB', 0, '28X4Z23', '', 'OPER2', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.11172.16.160.11172.17.160.11', '2.0.2', ' ', '68-05-CA-B3-B4-QF 68-05-CA-B3-B5-39 E4-54-E8-8F-1F-D8', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(366, 0, 7, 25, '17', '172500017', 'Precision 5820 8 GB 8 Cores @3.70 GHz 237 GB', 0, '28X1Z23', '', 'OPER3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC', 0, 0, '192.168.100.12172.16.160.12172.17.160.12', '2.0.2', ' ', '68-05-CA-B3-B4-23', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(367, 0, 7, 25, '18', '172500018', 'Precision 5820 16 GB 8 Cores @3.70 GHz 476 GB', 0, '28WYY23', '', 'ENG1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC', 0, 0, '192.168.100.13172.16.160.13172.17.160.13', '2.0.2', ' ', '68-05-CA-B3-AA-EA 68-05-CA-B3-AA-E7  68-05-CA-B3-B3-7F C8-F7-50-F4-BE-83 ', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(368, 0, 7, 24, '1', '172400001', 'DELL', 0, 'CN-04RFMK-64180-54H-19WS', '', 'CONNECTED TO  OPER1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(369, 0, 7, 25, '19', '172500019', 'Precision 5820 8 GB 8 Cores @3.70 GHz 237 GB', 0, '28X0Z23', '', 'MAX1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.20172.16.160.20172.17.160.20', '2.0.2', ' ', '68-05-CA-B3-AA-9E 68-05-CA-B3-B4-38  68-05-CA-B3-AB-45 C8-F7-50-F4-EE-3D ', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(370, 0, 7, 25, '20', '172500020', 'Precision 5820 8 GB 8 Cores @3.70 GHz 237 GB', 0, '28X2Z23', '', 'MAX3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.24172.16.160.24172.17.160.24', '2.0.2', ' ', '68-05-CA-B3-B4-3B', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(371, 0, 7, 25, '21', '172500021', 'Precision 5820 8 GB 8 Cores @3.70 GHz 237 GB', 0, '28X3Z23', '', 'MAX4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.26172.16.160.26172.17.160.26', '2.0.2', ' ', '68-05-CA-B3-B3-42', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(372, 0, 7, 25, '22', '172500022', 'Precision 5820 16 GB 8 Cores @3.70 GHz 476 GB', 0, '28XYY23', '', 'OPER4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.16172.16.160.16172.17.160.16', '2.0.2', ' ', '68-05-CA-B3-A9-0D 68-05-CA-B3-B5-06  68-05-CA-B3-B5-36 E4-54-E8-97-E3-F4', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(373, 0, 6, 25, '23', '162500023', 'Precision 5820 32 GB 8 Cores @3.70 GHz 237 GB 1.81 TB', 0, 'FV679T2', '', 'HIST1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.14172.16.160.14172.17.160.14', '1.8.0', ' ', '68-05-CA-8B-8f-52  68-05-CA-8B-5A-6B B4-96-91-46-35-C7 54-BF-64-99-56-2F', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(374, 0, 6, 25, '24', '162500024', 'Precision 5820', 0, 'FV699T2', '', 'HIST2', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.15172.16.160.15172.17.160.15', '1.8.0', ' ', '68-05-CA-8B-8f-54  68-05-CA-8B-58-54 B4-96-91-46-35-BE 54-BF-64-98-88-44', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(375, 0, 6, 25, '25', '162500025', 'Precision 5820', 0, 'FV689T2', '', 'HIST3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.17172.17.160.17172.17.160.17', '1.8.0', ' ', '68-05-CA-8B-5A-5E  B4-96-91-46-35-91 54-BF-64-99-50-EC', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(376, 0, 6, 25, '26', '162500026', 'Precision 5820', 0, 'FV5F9T2', '', 'HIST4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Windows 10 Enterprise LTSC MaxStation Veritas System 21', 0, 0, '192.168.100.18172.16.160.18172.17.160.18', '1.8.0', ' ', '68-05-CA-8B-5A-12  68-05-CA-8B-5B-F9 B4-96-91-46-35-8E 54-BF-64-97-0F-86', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(377, 0, 6, 28, '27', '162800027', 'TRENDNET', 0, 'TK-209K', '', 'KVM IN DCS CABINET(Historian)', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(378, 0, 7, 26, '28', '172600028', 'CISCO WS-C2960X-24TS-L', 0, 'F0C2246T451', '', 'SW1A', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Software 15.2(7)E7', 0, 0, '172.16.200.200', 'Version V05', ' ', '70-18-A7-EC-73-80', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(379, 0, 7, 24, '2', '172400002', 'DELL', 0, 'CN-04RFMK-64180-54H-19RS', '', 'CONNECTED TO OPER1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(380, 0, 7, 26, '29', '172600029', 'CISCO WS-C2960X-24TS-L', 0, 'FCW2238B36U', '', 'SW1B', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Software 15.2(7)E7', 0, 0, '172.17.200.200', 'Version V05', ' ', '34-F8-E7-09-D1-80', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(381, 0, 7, 29, '30', '172900030', 'DPU 4F', 0, '910220', '', 'DPU102 CABINET U01 PRI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.2', 'CP Version: 4.6.2.5 IOM Version:4.D CPLD Version: 5 IOM FPGA Version:C.4shMem FPGA ver: 5DPU Board rev:c/c', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(382, 0, 7, 29, '31', '172900031', 'DPU 4F', 0, '921095', '', 'DPU102 CABINET U01 SEC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.3', 'CP Version: 4.6.2.5 IOM Version:4.D CPLD Version: 5 IOM FPGA Version:C.4shMem FPGA ver: 5DPU Board rev:c/c', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(383, 0, 7, 29, '32', '172900032', 'DPU 4F', 0, '926070', '', 'DPU104 CABINET U02 PRI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.4', 'CP Version: 4.6.2.5 IOM Version:4.D CPLD Version: 5 IOM FPGA Version:C.4shMem FPGA ver: 5DPU Board rev:c/c', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(384, 0, 7, 29, '33', '172900033', 'DPU 4F', 0, '921130', '', 'DPU104 CABINET U02 SEC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.5', 'CP Version: 4.6.2.5 IOM Version:4.D CPLD Version: 5 IOM FPGA Version:C.4shMem FPGA ver: 5DPU Board rev:c/c', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(385, 0, 7, 29, '34', '172900034', 'DPU 4F', 0, '921057', '', 'DPU106 CABINET U03 PRI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.6', 'CP Version: 4.6.2.5 IOM Version:4.D CPLD Version: 5 IOM FPGA Version:C.4shMem FPGA ver: 5DPU Board rev:c/c', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(386, 0, 7, 29, '35', '172900035', 'DPU 4F', 0, '914041', '', 'DPU106 CABINET U03 SEC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.7', 'CP Version: 4.6.2.5 IOM Version:4.D CPLD Version: 5 IOM FPGA Version:C.4shMem FPGA ver: 5DPU Board rev:c/c', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(387, 0, 7, 30, '36', '173000036', 'SYSMETRICOM', 0, '', '', 'GPS SYSMETRICOM', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(388, 0, 8, 29, '37', '182900037', 'DPUMR2', 0, '1936030', '', 'DPU110 CABINET 3 PRI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.10', 'CP Version: 7.0.3.5 IOM Version:6.8 CPLD Version: 5  FPGA Version:5 DPU Board rev:A4/A5', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(389, 0, 8, 29, '38', '182900038', 'DPUMR2', 0, '1936078', '', 'DPU110 CABINET 3 SEC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.11', 'CP Version: 7.0.3.5 IOM Version:6.8 CPLD Version: 5  FPGA Version:5 DPU Board rev:A4/A5', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(390, 0, 7, 24, '3', '172400003', 'DELL', 0, 'CN-04RFMK-64180-54H-19TS', '', 'CONNECTED TO OPER2', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(391, 0, 8, 29, '39', '182900039', 'DPUMR2', 0, '1936029', '', 'DPU 112 CABINET 3 PRI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.12', 'CP Version: 7.0.3.5 IOM Version:6.8 CPLD Version: 5  FPGA Version:5 DPU Board rev:A4/A5', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(392, 0, 8, 29, '40', '182900040', 'DPUMR2', 0, '1936049', '', 'DPU 112 CABINET 3 SEC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.13', 'CP Version: 7.0.3.5 IOM Version:6.8 CPLD Version: 5  FPGA Version:5 DPU Board rev:A4/A5', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(393, 0, 8, 29, '41', '182900041', 'DPUMR2', 0, '1936039', '', 'DPU114 CABINET 4 PRI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.14', 'CP Version: 7.0.3.5 IOM Version:6.8 CPLD Version: 5  FPGA Version:5 DPU Board rev:A4/A5', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(394, 0, 8, 29, '42', '182900042', 'DPUMR2', 0, '1936046', '', 'DPU114 CABINET 4 SEC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.15', 'CP Version: 7.0.3.5 IOM Version:6.8 CPLD Version: 5  FPGA Version:5 DPU Board rev:A4/A5', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(395, 0, 8, 29, '43', '182900043', 'DPUMR2', 0, '1936045', '', 'DPU116 CABINET 4 PRI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.16', 'CP Version: 7.0.3.5 IOM Version:6.8 CPLD Version: 5  FPGA Version:5 DPU Board rev:A4/A5', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(396, 0, 8, 29, '44', '182900044', 'DPUMR2', 0, '1936038', '', 'DPU116 CABINET 4 SEC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.1.17', 'CP Version: 7.0.3.5 IOM Version:6.8 CPLD Version: 5  FPGA Version:5 DPU Board rev:A4/A5', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(397, 0, 8, 26, '45', '182600045', 'CISCO WS-C2960X-24TS-L', 0, 'FCW2238B3NP', '', 'SWITCH SW2A', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Software 15.2(7)E7', 0, 0, '172.16.200.201', 'Version V05', ' ', '34-F8-E7-44-8B-80', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(398, 0, 8, 26, '46', '182600046', 'CISCO WS-C2960X-24TS-L', 0, 'FOC2224T214', '', 'SWITCH SW2B', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Software 15.2(7)E7', 0, 0, '172.17.200.201', 'Version V05', ' ', 'B0-90-7E-AE-B5-80', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(399, 0, 8, 26, '47', '182600047', 'MOXA EDS-405A', 0, 'TAHID1046911', '', 'LINKSW1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Rev 1.2.2 ver 3.8 Build 17051216', 0, 0, '172.18.200.212', '', ' ', '00-90-E8-73-8C-C6', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(400, 0, 8, 26, '48', '182600048', 'MOXA EDS-405A', 0, 'TAHID1046919', '', 'LINKSW2', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Rev 1.2.2 ver 3.8 Build 17051216', 0, 0, '172.18.200.214', '', ' ', '00-90-E8-73-8C-CE', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(401, 0, 7, 24, '4', '172400004', 'DELL', 0, 'CN-04RFMK-64180-54H-19VS', '', 'CONNECTED TO OPER2', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(402, 0, 8, 26, '49', '182600049', 'MOXA EDS-405A', 0, 'TAHID1046920', '', 'LINKSW3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Rev 1.2.2 ver 3.8 Build 17051216', 0, 0, '172.18.200.216', '', ' ', '00-90-E8-73-8C-CF', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(403, 0, 8, 26, '50', '182600050', 'MOXA EDS-405A', 0, 'TAHID1046928', '', 'LINKSW4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Rev 1.2.2 ver 3.8 Build 17051216', 0, 0, '172.18.200.218', '', ' ', '00-90-E8-73-8C-D7', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(404, 0, 8, 26, '51', '182600051', 'MOXA EDS-P510A-8PoE-2GTXSFP', 0, 'TAIAD1073782', '', 'LINKSW5', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '00-90-E8-77-FC-7A', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(405, 0, 6, 26, '52', '162600052', 'CISCO WS-C2960X-24TS-L', 0, 'FCW2238B3BQ', '', 'SWITCH SW1S', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Software 15.2(7)E7', 0, 0, '192.168.100.200', 'Version V05', ' ', '34-f8-e7-44-29-00', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(406, 0, 6, 27, '53', '162700053', 'TS4538BU-RP (4x8 TB) 4GB 4 Core Intel 1.50 GHz', 0, 'Q187114609', '', 'MAX-NAS1 QNAP', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '4.3.6.0805', 0, 0, '192.168.100.222', 'QY74AR11', ' ', '24-5E-BE-2C-QC-81 24-5E-BE-2C-QC-82 24-5E-BE-2C-QC-83 24-5E-BE-2C-QC-84', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(407, 0, 6, 31, '54', '163100054', 'DELL PER 440 2.10 GHz 8 core 32 GB 199 GB 913 GB', 0, '8WQ8TT2', '', 'MAX-ADM1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Server 2019 Standard  Hyper V with MAX-MGR1 MAX-ZBX1 Veritas System recovery 21 Putty', 0, 0, '192.168.100.232', '1.6.11', ' ', 'DQ-94-66-5F-71-D3', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(408, 0, 6, 31, '55', '163100055', 'DELL PER 440 2.10 GHz 8 core 32 GB 199 GB 913 GB', 0, '1384Z23', '', 'MAX-ADM2', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, 'Server 2019 Standard  Hyper V with MAX-MGR2 Veritas System recovery 21 Putty', 0, 0, '192.168.100.238', '1.6.11', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(409, 0, 6, 28, '56', '162800056', 'ServSwitch Wizard DVI DL', 0, 'BLACKBOX 724-746-5500', '', 'KVM IN DCS CABINET (server)', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(410, 0, 6, 57, '57', '165700057', 'DELL', 0, 'CN-0V7JP5-QDC00-8B6-1AYL-A02', '', 'DISPLAY KVM DCS CABINET(server)', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(411, 0, 9, 25, '58', '292500058', 'SIEMENS SIMANTIC IPC547E', 0, 'HN950935', '', 'MCC1 HMI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '10.40.1.31 172.16.168.1', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(412, 0, 7, 24, '5', '172400005', 'DELL', 0, 'CN-084K96-72872-46P-AKVL', '', 'CONNECTED TO  OPER3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(413, 0, 9, 26, '59', '292600059', 'SIEMENS SCALANCE X106-1', 0, '106-I-BB00-2AA3', '', 'MCC1 SIEMENS SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(414, 0, 9, 32, '60', '293200060', 'CISCO Router 867VAE-K9', 0, 'GMK18010027', '', 'MCC1/2 SIEMENS ROUTER', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(415, 0, 9, 33, '61', '293300061', '', 0, '', '', 'Serial/Ethenet Conventer MCC1 SIEMENS Switch', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(416, 0, 9, 34, '62', '293400062', 'OKI C511DN', 0, '4K740476495A3KH2083', '', 'MCC1 Printer', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(417, 0, 9, 35, '63', '293500063', 'ABB PU410', 0, 'SE163501ML', '', 'MCC1 Communication Box MB300', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(418, 0, 9, 26, '64', '292600064', 'RH1-TP/TL', 0, '9.44E+17', '', 'MCC1  HIRSCHMANN SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(419, 0, 9, 33, '65', '293300065', '', 0, '', '', 'Serial/Ethenet Conventer MCC1 HIRSCHMAN SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(420, 0, 10, 25, '66', '2102500066', 'SIEMENS SIMANTIC IPC547E', 0, 'HN950932', '', 'MCC2 HMI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '172.16.168.1 10.40.1.32', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(421, 0, 10, 26, '67', '2102600067', 'SIEMENS SCALANCE X106-1', 0, '106-I-BB00-2AA3', '', 'MCC2 SIEMENS SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(422, 0, 10, 34, '68', '2103400068', 'OKI C532', 0, '2K6A2938975A1KP0041', '', 'MCC2 Printer', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(423, 0, 7, 24, '6', '172400006', 'DELL', 0, 'CN-04RFMK-64180-54H-1A2S', '', 'CONNECTED TO  OPER3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(424, 0, 10, 33, '69', '2103300069', '', 0, '', '', 'Serial/Ethenet Conventer MCC2 HIRSCHMAN Switch', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(425, 0, 10, 26, '70', '2102600070', 'RH1-TP/TL', 0, '9.44E+17', '', 'MCC2 HIRSCHMAN SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(426, 0, 9, 35, '71', '293500071', 'ABB PU410', 0, 'SE163601MM', '', 'MCC2 Communication Box', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(427, 0, 7, 33, '72', '273300072', '', 0, '', '', 'MCC2 HIRSCHMAN CONVERTER', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(428, 0, 7, 33, '73', '273300073', '', 0, '', '', 'Serial/Ethenet Conventer From MCC2 HIRSCHMAN Converter', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(429, 0, 7, 33, '74', '273300074', '', 0, '', '', 'MCR HIRSCHMAN CONVERTER', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(430, 0, 7, 33, '75', '273300075', '', 0, '', '', 'Serial/Ethenet Conventer From MCC1  HIRSCHMAN Switch', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(431, 0, 7, 25, '76', '272500076', 'DELL OPTIPLEX', 0, '9M18622', '', 'ALL IN ONE PC', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '10.40.1.33172.31.250.200 ', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(432, 0, 7, 34, '77', '273400077', 'Hp Color Laserjet Pro M254nw', 0, 'VNC3G07473', '', 'SIEMENS PRINTER', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(433, 0, 11, 26, '78', '2112600078', 'CISCO Catalyst 2960 series SI', 0, 'F0C1422Y12B', '', 'SIEMENS/GE SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(434, 0, 7, 24, '7', '172400007', 'DELL', 0, 'CN-04RFMK-64180-54H-006S', '', 'CONNECTED TO  ENG1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(435, 0, 11, 25, '79', '2112500079', 'HP Z4 G4 WORKSTATION', 0, '2UA491PX5', '', 'MCC3 HMI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(436, 0, 11, 26, '80', '2112600080', 'RS2-TX HIRSCHMANN', 0, '9.44E+17', '', 'MCC3 MICRONET SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(437, 0, 11, 36, '81', '2113600081', 'WOODWARD MICRONET PLUS DIGITAL CONTROL', 0, '21680766', '', 'UGT3 MICRONET', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(438, 0, 11, 26, '82', '2112600082', 'PLANET ISW-80IT', 0, 'AH00309900061', '', 'SWITCH AVR MCC3', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(439, 0, 11, 25, '83', '2112500083', 'NEXCOM', 0, '', '', 'UGT3 OSM', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(440, 0, 11, 26, '84', '2112600084', 'PLANET ISW-80IT', 0, 'AH0030990058', '', 'SWITCH ALL 3456 HMI (monitoring)', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(441, 0, 11, 25, '85', '2112500085', 'HP Z440 WORKSTATION', 0, '2UA8471RCC', '', 'MCC4 HMI', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(442, 0, 11, 26, '86', '2112600086', 'MOXA EDS-P510A-8PoE-2GTXSFP', 0, '', '', 'SWITCH ALL 3456 OSM (monitoring)', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(443, 0, 11, 36, '87', '2113600087', 'RS2-TX HIRSCHMANN', 0, '9.44E+17', '', 'MCC4 MICRONET SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(444, 0, 11, 26, '88', '2112600088', 'PLANET ISW-80IT', 0, 'AH00309900059', '', 'SWITCH AVR MCC4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(445, 0, 7, 24, '8', '172400008', 'DELL', 0, 'CN-OV7JP5-QDC00-8B6-1AYL', '', 'CONNECTED TO MAX1', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 1, NULL, NULL, NULL),
(446, 0, 11, 36, '89', '2113600089', 'WOODWARD MICRONET PLUS DIGITAL CONTROL', 0, '', '', 'MICRONET UGT4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(447, 0, 11, 25, '90', '2112500090', 'NEXCOM', 0, '', '', 'OSM UGT4', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(448, 0, 8, 25, '91', '282500091', 'HP Z440 WORKSTATION', 0, '2UA7291YW7', '', 'HMI MCC5', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(449, 0, 8, 26, '92', '282600092', 'PHOENIX CONTACT', 0, '', '', 'MCC5 MICRONET PRIMARY SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(450, 0, 8, 26, '93', '282600093', 'PHOENIX CONTACT', 0, '', '', 'MCC5 MICRONET SECONDARY SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(451, 0, 8, 25, '94', '282500094', '', 0, '', '', ' ', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(452, 0, 8, 36, '95', '283600095', 'WOODWARD MICRONET PLUS DIGITAL CONTROL', 0, '211045821 711', '', 'MICRONET UGT5 PRIMARY', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(453, 0, 8, 36, '96', '283600096', 'WOODWARD MICRONET PLUS DIGITAL CONTROL', 0, '211045821 711', '', 'MICRONET UGT5 SECONDARY', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(454, 0, 12, 25, '97', '2122500097', 'HP Z440 WORKSTATION', 0, 'GE-NJCA7QRHH34P', '', 'HMI MCC6', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL),
(455, 0, 12, 26, '98', '2122600098', 'PHOENIX CONTACT FLSWITCH SFN8GT', 0, '3034161192', '', 'MCC6  MICRONET SWITCH', 0, 0, '2022-11-11', '2022-11-20 20:16:49', 1, '', 0, 0, '', '', ' ', '', 'N/A', 'N/A', 'N/A', '0000-00-00', ' ', 1, 'uploads/Data.csv', '', '', 2, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `assetmasterdatalogs`
--

CREATE TABLE `assetmasterdatalogs` (
  `assetmasterdatalogsid` int(11) NOT NULL,
  `assetmasterdataid` int(11) NOT NULL,
  `departmentid` int(11) NOT NULL,
  `locationid` int(11) NOT NULL,
  `asseclassification_id` int(11) NOT NULL,
  `ano` varchar(200) NOT NULL,
  `acode` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `modelid` int(11) NOT NULL,
  `serialnumber` varchar(200) NOT NULL,
  `manufacturer` varchar(200) NOT NULL,
  `netbiosname` varchar(200) NOT NULL,
  `usersid` int(11) NOT NULL,
  `createdby` int(11) NOT NULL,
  `createddate` date NOT NULL,
  `createdtime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `softwaregroupid` int(11) NOT NULL,
  `softwareinstalleddescription` varchar(200) NOT NULL,
  `ipaddressgroupid` int(11) NOT NULL,
  `vlan` int(11) NOT NULL,
  `switchdescription` varchar(200) NOT NULL,
  `biosversion` varchar(200) NOT NULL,
  `biosyear` varchar(200) NOT NULL,
  `macadressethernet,` varchar(200) NOT NULL,
  `macaddresswifi` varchar(200) NOT NULL,
  `macadressbluetooth` varchar(200) NOT NULL,
  `imeinumber` varchar(200) NOT NULL,
  `purchasedate` date NOT NULL,
  `warrantyperiod` varchar(200) NOT NULL,
  `assetstateid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `assetstate`
--

CREATE TABLE `assetstate` (
  `assetstateid` int(11) NOT NULL,
  `assetstatename` varchar(200) NOT NULL,
  `assetstatedescription` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `assetstate`
--

INSERT INTO `assetstate` (`assetstateid`, `assetstatename`, `assetstatedescription`) VALUES
(1, 'In Use', 'In Use'),
(2, 'In Store', 'In Store'),
(3, 'In Maintanance', 'In Maintenance');

-- --------------------------------------------------------

--
-- Table structure for table `assettype`
--

CREATE TABLE `assettype` (
  `assettypeid` int(11) NOT NULL,
  `assettypename` varchar(200) NOT NULL,
  `assetypedescription` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `assettype`
--

INSERT INTO `assettype` (`assettypeid`, `assettypename`, `assetypedescription`) VALUES
(1, 'IT equipment (Information Technology)', 'IT'),
(2, 'OT Equipment (Operational Technology)', 'OT');

-- --------------------------------------------------------

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `departmentid` int(11) NOT NULL,
  `departmentname` varchar(200) NOT NULL,
  `departmentdescription` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`departmentid`, `departmentname`, `departmentdescription`) VALUES
(1, 'PLANT MANAGER', 'PM: PLANT MANAGER'),
(2, 'TEMPORARY', 'TP: TEMPORARY'),
(3, 'ADMIN', 'AD: ADMIN'),
(4, 'FINANCE', 'FN: FINANCE'),
(5, 'HUMAN RESOURCE', 'HR: HUMAN RESOURCE'),
(6, 'SUPPLY CHAIN', 'SC: SUPPLY CHAIN'),
(7, 'BUSINESS DEVELOPMENT', 'BD: BUSINESS DEVELOPMENT'),
(8, 'OPERATIONS', 'OP: OPERATIONS'),
(9, 'TECHNICAL', 'TE: TECHNICAL'),
(10, 'HEALTH AND SAFETY', 'HS: HEALTH AND SAFETY'),
(11, 'MAINTENANCE', 'MN: MAINTENANCE'),
(12, 'INFORMATION TECHNOLOGY', 'IT: INFORMATION TECHNOLOGY'),
(13, 'COMMERCIAL', 'CM: COMMERCIAL');

-- --------------------------------------------------------

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `designationid` int(11) NOT NULL,
  `designationname` varchar(200) NOT NULL,
  `designationdescription` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `ipaddressgroup`
--

CREATE TABLE `ipaddressgroup` (
  `ipgroupid` int(11) NOT NULL,
  `ipgroupname` varchar(200) NOT NULL,
  `ipgroupdescription` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ipaddressgroup`
--

INSERT INTO `ipaddressgroup` (`ipgroupid`, `ipgroupname`, `ipgroupdescription`) VALUES
(1, 'Fixed', 'Fixed'),
(2, 'Special', 'Special'),
(3, 'DHCP', 'DHCP');

-- --------------------------------------------------------

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `locationid` int(11) NOT NULL,
  `locationname` varchar(200) NOT NULL,
  `locationdescription` varchar(200) NOT NULL,
  `otid` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`locationid`, `locationname`, `locationdescription`, `otid`) VALUES
(1, 'UPPPLANT - 001', 'UPPPLANT - 001', '00'),
(2, 'UPP OFFICE - 002', 'UPP OFFICE - 002', '00'),
(3, 'WAY/L -  003', 'WAY/LEAVE -  003', '00'),
(4, 'R-SQUARE - 004', 'R-SQUARE - 004', '00'),
(5, 'SSI - 005', 'SSI - 005', '00'),
(6, 'Server Room', 'Server Room', '01'),
(7, 'Main Control Room', 'Main Control Room', '02'),
(8, 'MCC5', 'MCC5', '03'),
(9, 'MCC1', 'MCC1', '04'),
(10, 'MCC2', 'MCC2', '05'),
(11, 'MCC3/4', 'MCC3/4', '06'),
(12, 'MCC6', 'MCC6', '07'),
(13, 'SOC', 'SOC', '08');

-- --------------------------------------------------------

--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `migration`
--

INSERT INTO `migration` (`version`, `apply_time`) VALUES
('m000000_000000_base', 1667909091),
('m130524_201442_init', 1667909122),
('m190124_110200_add_verification_token_column_to_user_table', 1667909122);

-- --------------------------------------------------------

--
-- Table structure for table `modeli`
--

CREATE TABLE `modeli` (
  `modelid` int(11) NOT NULL,
  `modelname` varchar(200) NOT NULL,
  `modeldescription` varchar(200) NOT NULL,
  `assetclassificationid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `otnetworktype`
--

CREATE TABLE `otnetworktype` (
  `otnetworktypeid` int(11) NOT NULL,
  `otnertworktypename` varchar(200) NOT NULL,
  `otnertworktypedesc` varchar(200) DEFAULT NULL,
  `otid` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `otnetworktype`
--

INSERT INTO `otnetworktype` (`otnetworktypeid`, `otnertworktypename`, `otnertworktypedesc`, `otid`) VALUES
(1, 'DCS', 'DCS', '01'),
(2, 'Plant Network', 'Plant Network', '02'),
(3, 'Metering Network', 'Metering Network', '03'),
(4, 'Chiller Network', 'Chiller Network', '04'),
(5, 'Plant Wireless Network', 'Plant Wireless Network', '05');

-- --------------------------------------------------------

--
-- Table structure for table `softwaregroup`
--

CREATE TABLE `softwaregroup` (
  `softwaregroupid` int(11) NOT NULL,
  `softwaregroupname` varchar(200) NOT NULL,
  `softwaregroupdescription` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `softwaregroup`
--

INSERT INTO `softwaregroup` (`softwaregroupid`, `softwaregroupname`, `softwaregroupdescription`) VALUES
(1, 'Common', 'Common'),
(2, 'Linux', 'Linux');

-- --------------------------------------------------------

--
-- Table structure for table `usergroup`
--

CREATE TABLE `usergroup` (
  `usergroupid` int(11) NOT NULL,
  `usergroupname` varchar(200) NOT NULL,
  `usergroupdescription` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `usergroup`
--

INSERT INTO `usergroup` (`usergroupid`, `usergroupname`, `usergroupdescription`) VALUES
(1, 'Admin', 'Admin'),
(2, 'Asset Manager', 'Asset Manager'),
(3, 'Normal user', 'Normal user');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `assetclassification`
--
ALTER TABLE `assetclassification`
  ADD PRIMARY KEY (`assetclassificationid`),
  ADD KEY `assettypeid` (`assettypeid`);

--
-- Indexes for table `assetmasterdata`
--
ALTER TABLE `assetmasterdata`
  ADD PRIMARY KEY (`assetmasterdataid`),
  ADD KEY `departmentid` (`departmentid`),
  ADD KEY `locationid` (`locationid`),
  ADD KEY `asseclassification_id` (`asseclassification_id`),
  ADD KEY `modelid` (`modelid`),
  ADD KEY `usersid` (`usersid`),
  ADD KEY `softwaregroupid` (`softwaregroupid`),
  ADD KEY `ipaddressgroupid` (`ipaddressgroupid`),
  ADD KEY `assetstateid` (`assetstateid`);

--
-- Indexes for table `assetmasterdatalogs`
--
ALTER TABLE `assetmasterdatalogs`
  ADD PRIMARY KEY (`assetmasterdatalogsid`),
  ADD KEY `assetmasterdataid` (`assetmasterdataid`);

--
-- Indexes for table `assetstate`
--
ALTER TABLE `assetstate`
  ADD PRIMARY KEY (`assetstateid`);

--
-- Indexes for table `assettype`
--
ALTER TABLE `assettype`
  ADD PRIMARY KEY (`assettypeid`);

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`departmentid`);

--
-- Indexes for table `designations`
--
ALTER TABLE `designations`
  ADD PRIMARY KEY (`designationid`);

--
-- Indexes for table `ipaddressgroup`
--
ALTER TABLE `ipaddressgroup`
  ADD PRIMARY KEY (`ipgroupid`);

--
-- Indexes for table `location`
--
ALTER TABLE `location`
  ADD PRIMARY KEY (`locationid`);

--
-- Indexes for table `migration`
--
ALTER TABLE `migration`
  ADD PRIMARY KEY (`version`);

--
-- Indexes for table `modeli`
--
ALTER TABLE `modeli`
  ADD PRIMARY KEY (`modelid`),
  ADD KEY `assetclassificationid` (`assetclassificationid`);

--
-- Indexes for table `otnetworktype`
--
ALTER TABLE `otnetworktype`
  ADD PRIMARY KEY (`otnetworktypeid`);

--
-- Indexes for table `softwaregroup`
--
ALTER TABLE `softwaregroup`
  ADD PRIMARY KEY (`softwaregroupid`);

--
-- Indexes for table `usergroup`
--
ALTER TABLE `usergroup`
  ADD PRIMARY KEY (`usergroupid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `assetclassification`
--
ALTER TABLE `assetclassification`
  MODIFY `assetclassificationid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `assetmasterdata`
--
ALTER TABLE `assetmasterdata`
  MODIFY `assetmasterdataid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=456;

--
-- AUTO_INCREMENT for table `assetmasterdatalogs`
--
ALTER TABLE `assetmasterdatalogs`
  MODIFY `assetmasterdatalogsid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assetstate`
--
ALTER TABLE `assetstate`
  MODIFY `assetstateid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `assettype`
--
ALTER TABLE `assettype`
  MODIFY `assettypeid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `departmentid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `designationid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ipaddressgroup`
--
ALTER TABLE `ipaddressgroup`
  MODIFY `ipgroupid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `location`
--
ALTER TABLE `location`
  MODIFY `locationid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `modeli`
--
ALTER TABLE `modeli`
  MODIFY `modelid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `otnetworktype`
--
ALTER TABLE `otnetworktype`
  MODIFY `otnetworktypeid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `softwaregroup`
--
ALTER TABLE `softwaregroup`
  MODIFY `softwaregroupid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `usergroup`
--
ALTER TABLE `usergroup`
  MODIFY `usergroupid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

