========================2019-04-15 09:53:20======================== noteurl_start parm_app_code = 039 parm_pc_name = EUNJEUNG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D850E6BBC2F620DAC30A sCDKey = 603376903308 sName = EUNJEUNG-PC ========================2019-04-15 09:53:20======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '603376903308' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-15 09:53:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'donghwa' ========================2019-04-15 09:53:20======================== SELECT idx FROM macs WHERE mac_addr = 'D850E6BBC2F620DAC30A' AND app_code = '039' ========================2019-04-15 09:53:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283394' ========================2019-04-15 09:53:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283394' ========================2019-04-15 09:53:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283394', 'D850E6BBC2F620DAC30A', '039', 'EUNJEUNG-PC', '90', '1920', '1080', 'donghwa', '동화사[최은정]', '603376903308' ) ========================2019-04-15 09:55:22======================== noteurl_start parm_app_code = 039 parm_pc_name = EUNJEUNG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D850E6BBC2F68CF70DFB sCDKey = 603376903308 sName = EUNJEUNG-PC ========================2019-04-15 09:55:22======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '603376903308' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-15 09:55:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'donghwa' ========================2019-04-15 09:55:22======================== SELECT idx FROM macs WHERE mac_addr = 'D850E6BBC2F68CF70DFB' AND app_code = '039' ========================2019-04-15 09:55:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283396' ========================2019-04-15 09:55:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283396' ========================2019-04-15 09:55:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283396', 'D850E6BBC2F68CF70DFB', '039', 'EUNJEUNG-PC', '90', '1920', '1080', 'donghwa', '동화사[최은정]', '603376903308' ) ========================2019-04-15 11:12:40======================== noteurl_start parm_app_code = 050 parm_pc_name = ATIV-1711141730 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E8039ABF238D230CF430 sCDKey = 185107552507 sName = ATIV-1711141730 ========================2019-04-15 11:12:40======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '185107552507' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 11:12:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daeja0108' ========================2019-04-15 11:12:40======================== SELECT idx FROM macs WHERE mac_addr = 'E8039ABF238D230CF430' AND app_code = '050' ========================2019-04-15 11:12:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281545' ========================2019-04-15 11:12:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281545' ========================2019-04-15 11:12:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '281545', 'E8039ABF238D230CF430', '050', 'ATIV-1711141730', '90', '1366', '768', 'daeja0108', '대자유치원[박선영]', '185107552507' ) ========================2019-04-15 11:38:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VDCILBR parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = E0D55EBBB5D1887E1B9C sCDKey = 252447530356 sName = DESKTOP-VDCILBR ========================2019-04-15 11:38:04======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '252447530356' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-15 11:38:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daigeq' ========================2019-04-15 11:38:04======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EBBB5D1887E1B9C' AND app_code = '039' ========================2019-04-15 11:38:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283410' ========================2019-04-15 11:38:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283410' ========================2019-04-15 11:38:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283410', 'E0D55EBBB5D1887E1B9C', '039', 'DESKTOP-VDCILBR', '110', '1280', '1024', 'daigeq', '(주)삼원에스엠테크[조혜정]', '252447530356' ) ========================2019-04-15 13:28:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-TAK3FEM parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = F44D30BA94D2748B10A1 sCDKey = 224375302376 sName = DESKTOP-TAK3FEM ========================2019-04-15 13:28:52======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '224375302376' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-15 13:28:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ilha09' ========================2019-04-15 13:28:52======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BA94D2748B10A1' AND app_code = '039' ========================2019-04-15 13:28:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248023' ========================2019-04-15 13:28:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248023' ========================2019-04-15 13:28:52======================== UPDATE mac_detail SET pc_name = 'DESKTOP-TAK3FEM', os_type = '110', user_id = 'ilha09', user_name = '일해유통[엄재섭]', screen_w = '1440', screen_h = '900', cdkey = '224375302376' WHERE mac_idx = '248023' ========================2019-04-15 14:35:12======================== noteurl_start parm_app_code = 039 parm_pc_name = PUBLIC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039AB8C1DDA68905BB sCDKey = 829833893775 sName = PUBLIC ========================2019-04-15 14:35:12======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '829833893775' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-15 14:35:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eswire' ========================2019-04-15 14:35:12======================== SELECT idx FROM macs WHERE mac_addr = 'E8039AB8C1DDA68905BB' AND app_code = '039' ========================2019-04-15 14:35:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283402' ========================2019-04-15 14:35:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283402' ========================2019-04-15 14:35:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283402', 'E8039AB8C1DDA68905BB', '039', 'PUBLIC', '90', '1920', '1080', 'eswire', '은성선재[채돈희]', '829833893775' ) ========================2019-04-15 14:35:15======================== noteurl_start parm_app_code = 039 parm_pc_name = PUBLIC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039AB8C1DDA68905BB sCDKey = 829833893775 sName = PUBLIC ========================2019-04-15 14:35:15======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '829833893775' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-15 15:59:57======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-D20IFS9 parm_os_type = 109 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 50B7C3ACBD016CE576DF sCDKey = 170166571539 sName = 경기도교육청북부청사 ========================2019-04-15 15:59:57======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '170166571539' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 15:59:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bukbu' ========================2019-04-15 15:59:57======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3ACBD016CE576DF' AND app_code = '050' ========================2019-04-15 15:59:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283157' ========================2019-04-15 15:59:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283157' ========================2019-04-15 15:59:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283157', '50B7C3ACBD016CE576DF', '050', '경기도교육청북부청사', '109', '1600', '900', 'bukbu', '경기도교육청북부청사[이재정]', '170166571539' ) ========================2019-04-15 16:11:08======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-O5BMSQF parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E4E4DA8B3DA0F sCDKey = 670894355181 sName = DESKTOP-O5BMSQF ========================2019-04-15 16:11:08======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '670894355181' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 16:11:26======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-O5BMSQF parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E4E4DA8B3DA0F sCDKey = 670894355181 sName = DESKTOP-O5BMSQF ========================2019-04-15 16:11:26======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '670894355181' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 16:12:18======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-O5BMSQF parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E4E4DA8B3DA0F sCDKey = 670894355181 sName = DESKTOP-O5BMSQF ========================2019-04-15 16:12:18======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '670894355181' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 16:15:15======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-O5BMSQF parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E4E4DA8B3DA0F sCDKey = 670894355181 sName = DESKTOP-O5BMSQF ========================2019-04-15 16:15:15======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '670894355181' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 16:16:25======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-O5BMSQF parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E4E4DA8B3DA0F sCDKey = 670894355181 sName = DESKTOP-O5BMSQF ========================2019-04-15 16:16:25======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '670894355181' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 16:20:36======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-O5BMSQF parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E4E4DA8B3DA0F sCDKey = 670894355181 sName = DESKTOP-O5BMSQF ========================2019-04-15 16:20:36======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '670894355181' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 16:21:45======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-O5BMSQF parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E4E4DA8B3DA0F sCDKey = 670894355181 sName = DESKTOP-O5BMSQF ========================2019-04-15 16:21:45======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '670894355181' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 16:24:34======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-O5BMSQF parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E4E4DA8B3DA0F sCDKey = 670894355181 sName = DESKTOP-O5BMSQF ========================2019-04-15 16:24:34======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '670894355181' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-15 17:07:09======================== noteurl_start parm_app_code = 039 parm_pc_name = JHC_1324 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CFDA15B38E832D8FCD3 sCDKey = 283376018728 sName = JHC_1324 ========================2019-04-15 17:07:09======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '283376018728' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-15 17:07:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hg0169' ========================2019-04-15 17:07:09======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15B38E832D8FCD3' AND app_code = '039' ========================2019-04-15 17:07:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283465' ========================2019-04-15 17:07:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283465' ========================2019-04-15 17:07:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283465', '2CFDA15B38E832D8FCD3', '039', 'JHC_1324', '110', '1920', '1080', 'hg0169', '한길산업[황인옥]', '283376018728' )