========================2019-07-22 10:00:03======================== noteurl_start parm_app_code = 039 parm_pc_name = KIMYUNG-DESKTOP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B346A663FA5D462B sCDKey = 320740016468 sName = KIMYUNG-DESKTOP ========================2019-07-22 10:00:03======================== 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 = '320740016468' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 10:00:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimyng7538' ========================2019-07-22 10:00:03======================== SELECT idx FROM macs WHERE mac_addr = '902B346A663FA5D462B' AND app_code = '039' ========================2019-07-22 10:00:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '289210' ========================2019-07-22 10:00:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '289210' ========================2019-07-22 10:00:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '289210', '902B346A663FA5D462B', '039', 'KIMYUNG-DESKTOP', '110', '1920', '1080', 'kimyng7538', '센추리 공조 시스템[김영호]', '320740016468' ) ========================2019-07-22 10:34:44======================== noteurl_start parm_app_code = 039 parm_pc_name = PJS parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003018A18AEC682074B1 sCDKey = 602903636174 sName = PJS ========================2019-07-22 10:34:44======================== 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 = '602903636174' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 10:34:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'minsunmall' ========================2019-07-22 10:34:44======================== SELECT idx FROM macs WHERE mac_addr = '003018A18AEC682074B1' AND app_code = '039' ========================2019-07-22 10:34:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '151063' ========================2019-07-22 10:34:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '151063' ========================2019-07-22 10:34:44======================== UPDATE mac_detail SET pc_name = 'PJS', os_type = '90', user_id = 'minsunmall', user_name = '민선종합상사[박종성]', screen_w = '1920', screen_h = '1080', cdkey = '602903636174' WHERE mac_idx = '151063' ========================2019-07-22 10:37:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3MLF9KT parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E991D1B0796C83BF5 sCDKey = 912639507488 sName = DESKTOP-3MLF9KT ========================2019-07-22 10:37:32======================== 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 = '912639507488' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 10:37:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dainct2019' ========================2019-07-22 10:37:32======================== SELECT idx FROM macs WHERE mac_addr = 'B42E991D1B0796C83BF5' AND app_code = '039' ========================2019-07-22 10:37:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291303' ========================2019-07-22 10:37:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291303' ========================2019-07-22 10:37:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291303', 'B42E991D1B0796C83BF5', '039', 'DESKTOP-3MLF9KT', '110', '1920', '1080', 'dainct2019', '다인컨테이너[박소정]', '912639507488' ) ========================2019-07-22 11:10:01======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-PC parm_os_type = 90 parm_screen_w = 1152 parm_screen_h = 864 parm_user_mac = 001A920873D86D296A5 sCDKey = 375832259223 sName = WINDOWS-PC ========================2019-07-22 11:10:01======================== 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 = '375832259223' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 11:10:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kec573' ========================2019-07-22 11:10:01======================== SELECT idx FROM macs WHERE mac_addr = '001A920873D86D296A5' AND app_code = '039' ========================2019-07-22 11:10:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291307' ========================2019-07-22 11:10:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291307' ========================2019-07-22 11:10:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291307', '001A920873D86D296A5', '039', 'WINDOWS-PC', '90', '1152', '864', 'kec573', '기흥전기[송인환]', '375832259223' ) ========================2019-07-22 11:17:00======================== noteurl_start parm_app_code = 046 parm_pc_name = ONSIL2-CL parm_os_type = 90 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 04D4C4A8F53C70D143EA sCDKey = 145512776901 sName = ONSIL2-CL ========================2019-07-22 11:17:00======================== 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 = '145512776901' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-22 11:17:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onsil2' ========================2019-07-22 11:17:00======================== SELECT idx FROM macs WHERE mac_addr = '04D4C4A8F53C70D143EA' AND app_code = '046' ========================2019-07-22 11:17:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291310' ========================2019-07-22 11:17:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291310' ========================2019-07-22 11:17:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291310', '04D4C4A8F53C70D143EA', '046', 'ONSIL2-CL', '90', '1360', '768', 'onsil2', '동아자재[박훈성]', '145512776901' ) ========================2019-07-22 11:59:52======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CT1TR7O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1C1B0D8952D03621E802 sCDKey = 967548682712 sName = DESKTOP-CT1TR7O ========================2019-07-22 11:59: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 = '967548682712' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-22 12:00:08======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CT1TR7O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1C1B0D8952D03621E802 sCDKey = 967548682712 sName = DESKTOP-CT1TR7O ========================2019-07-22 12:00: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 = '967548682712' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-22 12:00:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bulmoim' ========================2019-07-22 12:00:08======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D8952D03621E802' AND app_code = '047' ========================2019-07-22 12:00:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291205' ========================2019-07-22 12:00:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291205' ========================2019-07-22 12:00:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291205', '1C1B0D8952D03621E802', '047', 'DESKTOP-CT1TR7O', '�쐢�룄�슦 10', '0', '0', 'bulmoim', '불모임[고영하]', '967548682712' ) ========================2019-07-22 12:07:48======================== noteurl_start parm_app_code = 039 parm_pc_name = 남일천막-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF454FF846E9782DF sCDKey = 565697760140 sName = 남일천막-PC ========================2019-07-22 12:07:48======================== 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 = '565697760140' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 12:09:19======================== noteurl_start parm_app_code = 039 parm_pc_name = 남일천막-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF454FF846E9782DF sCDKey = 565697760140 sName = 남일천막-PC ========================2019-07-22 12:09:19======================== 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 = '565697760140' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 13:45:13======================== noteurl_start parm_app_code = 039 parm_pc_name = 남일천막-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF454FF846E9782DF sCDKey = 565697760140 sName = 남일천막-PC ========================2019-07-22 13:45:13======================== 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 = '565697760140' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 13:47:06======================== noteurl_start parm_app_code = 039 parm_pc_name = 남일천막-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF454FF846E9782DF sCDKey = 565697760140 sName = 남일천막-PC ========================2019-07-22 13:47:06======================== 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 = '565697760140' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 13:47:48======================== noteurl_start parm_app_code = 039 parm_pc_name = 남일천막-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF454FF846E9782DF sCDKey = 565697760140 sName = 남일천막-PC ========================2019-07-22 13:47:48======================== 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 = '565697760140' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 13:49:28======================== noteurl_start parm_app_code = 039 parm_pc_name = 남일천막-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF454FF846E9782DF sCDKey = 591741000977 sName = 남일천막-PC ========================2019-07-22 13:49:28======================== 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 = '591741000977' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 13:49:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khh0515' ========================2019-07-22 13:49:28======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF454FF846E9782DF' AND app_code = '039' ========================2019-07-22 13:49:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291313' ========================2019-07-22 13:49:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291313' ========================2019-07-22 13:49:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291313', 'BC5FF454FF846E9782DF', '039', '남일천막-PC', '90', '1920', '1080', 'khh0515', '광성철재천막[김현호]', '591741000977' ) ========================2019-07-22 13:50:31======================== noteurl_start parm_app_code = 039 parm_pc_name = 남일천막-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF454FF846E9782DF sCDKey = 565697760140 sName = 남일천막-PC ========================2019-07-22 13:50:31======================== 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 = '565697760140' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 13:50:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khh0510' ========================2019-07-22 13:50:31======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF454FF846E9782DF' AND app_code = '039' ========================2019-07-22 13:50:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291313' ========================2019-07-22 13:50:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291313' ========================2019-07-22 13:50:31======================== UPDATE mac_detail SET pc_name = '남일천막-PC', os_type = '90', user_id = 'khh0510', user_name = '남일천막사[김현호]', screen_w = '1920', screen_h = '1080', cdkey = '565697760140' WHERE mac_idx = '291313' ========================2019-07-22 14:36:36======================== noteurl_start parm_app_code = 039 parm_pc_name = PC11 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1078D228E363507FDBF2 sCDKey = 189243361192 sName = PC11 ========================2019-07-22 14:36: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 = '189243361192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 14:36:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hsjchj8368' ========================2019-07-22 14:36:36======================== SELECT idx FROM macs WHERE mac_addr = '1078D228E363507FDBF2' AND app_code = '039' ========================2019-07-22 14:36:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290615' ========================2019-07-22 14:36:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290615' ========================2019-07-22 14:36:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290615', '1078D228E363507FDBF2', '039', 'PC11', '90', '1920', '1080', 'hsjchj8368', '해성정공[천철주]', '189243361192' ) ========================2019-07-22 17:48:27======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00FFB02B641E76D7F1ED sCDKey = 943551094481 sName = HANDO ========================2019-07-22 17:48:27======================== 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 = '943551094481' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-22 17:48:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kaf0303' ========================2019-07-22 17:48:27======================== SELECT idx FROM macs WHERE mac_addr = '00FFB02B641E76D7F1ED' AND app_code = '039' ========================2019-07-22 17:48:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291357' ========================2019-07-22 17:48:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291357' ========================2019-07-22 17:48:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291357', '00FFB02B641E76D7F1ED', '039', 'HANDO', '110', '1920', '1080', 'kaf0303', '한도시스템(주)[임문희]', '943551094481' )