========================2019-07-23 15:45:59======================== noteurl_start parm_app_code = 039 parm_pc_name = 김창원 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB3E06A5DC0D8 sCDKey = 657168061937 sName = 김창원 ========================2019-07-23 15:45:59======================== 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 = '657168061937' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:45:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klmm12' ========================2019-07-23 15:45:59======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E06A5DC0D8' AND app_code = '039' ========================2019-07-23 15:45:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223020' ========================2019-07-23 15:45:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223020' ========================2019-07-23 15:45:59======================== UPDATE mac_detail SET pc_name = '김창원', os_type = '110', user_id = 'klmm12', user_name = '엠제이소프트[김창원]', screen_w = '1920', screen_h = '1080', cdkey = '657168061937' WHERE mac_idx = '223020' ========================2019-07-23 15:46:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NTKVTT0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 982CBCC5BC55AE39B9D4 sCDKey = 151317336230 sName = DESKTOP-NTKVTT0 ========================2019-07-23 15:46: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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:46:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yessal' ========================2019-07-23 15:46:13======================== SELECT idx FROM macs WHERE mac_addr = '982CBCC5BC55AE39B9D4' AND app_code = '039' ========================2019-07-23 15:46:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290855' ========================2019-07-23 15:46:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290855' ========================2019-07-23 15:46:13======================== UPDATE mac_detail SET pc_name = 'DESKTOP-NTKVTT0', os_type = '110', user_id = 'yessal', user_name = '제이에스테크[심재섭]', screen_w = '1536', screen_h = '864', cdkey = '151317336230' WHERE mac_idx = '290855' ========================2019-07-23 15:48:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NTKVTT0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 982CBCC5BC55AE39B9D4 sCDKey = 151317336230 sName = DESKTOP-NTKVTT0 ========================2019-07-23 15:48:39======================== 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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:48:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yessal' ========================2019-07-23 15:48:39======================== SELECT idx FROM macs WHERE mac_addr = '982CBCC5BC55AE39B9D4' AND app_code = '039' ========================2019-07-23 15:48:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290855' ========================2019-07-23 15:48:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290855' ========================2019-07-23 15:48:39======================== UPDATE mac_detail SET pc_name = 'DESKTOP-NTKVTT0', os_type = '110', user_id = 'yessal', user_name = '제이에스테크[심재섭]', screen_w = '1536', screen_h = '864', cdkey = '151317336230' WHERE mac_idx = '290855' ========================2019-07-23 15:49:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NTKVTT0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 32AABABACFD6AE39B9D4 sCDKey = 151317336230 sName = DESKTOP-NTKVTT0 ========================2019-07-23 15:49:29======================== 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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:49:36======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NTKVTT0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 32AABABACFD6AE39B9D4 sCDKey = 151317336230 sName = DESKTOP-NTKVTT0 ========================2019-07-23 15:49: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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:50:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NTKVTT0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 32AABABACFD6AE39B9D4 sCDKey = 151317336230 sName = DESKTOP-NTKVTT0 ========================2019-07-23 15:50: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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:51:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NTKVTT0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 982CBCC5BC55AE39B9D4 sCDKey = 151317336230 sName = DESKTOP-NTKVTT0 ========================2019-07-23 15:51:29======================== 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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:51:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yessal' ========================2019-07-23 15:51:29======================== SELECT idx FROM macs WHERE mac_addr = '982CBCC5BC55AE39B9D4' AND app_code = '039' ========================2019-07-23 15:51:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290855' ========================2019-07-23 15:51:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290855' ========================2019-07-23 15:51:29======================== UPDATE mac_detail SET pc_name = 'DESKTOP-NTKVTT0', os_type = '110', user_id = 'yessal', user_name = '제이에스테크[심재섭]', screen_w = '1536', screen_h = '864', cdkey = '151317336230' WHERE mac_idx = '290855' ========================2019-07-23 15:51:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KDNP329 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0C9D9264032368429A64 sCDKey = 283237621132 sName = DESKTOP-KDNP329 ========================2019-07-23 15:51: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 = '283237621132' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:51:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'viojoy' ========================2019-07-23 15:51:52======================== SELECT idx FROM macs WHERE mac_addr = '0C9D9264032368429A64' AND app_code = '039' ========================2019-07-23 15:51:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291452' ========================2019-07-23 15:51:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291452' ========================2019-07-23 15:51:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291452', '0C9D9264032368429A64', '039', 'DESKTOP-KDNP329', '110', '1920', '1080', 'viojoy', '디자인생기[박희현]', '283237621132' ) ========================2019-07-23 15:55:49======================== noteurl_start parm_app_code = 039 parm_pc_name = 서울상담 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 98838937EE071523563F sCDKey = 127014886641 sName = 서울상담 ========================2019-07-23 15:55:49======================== 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 = '127014886641' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 15:55:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2019-07-23 15:55:49======================== SELECT idx FROM macs WHERE mac_addr = '98838937EE071523563F' AND app_code = '039' ========================2019-07-23 15:55:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291454' ========================2019-07-23 15:55:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291454' ========================2019-07-23 15:55:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291454', '98838937EE071523563F', '039', '서울상담', '110', '1536', '864', 'adam5352', '오상목해피아울렛농업회사법인(주)[해피아울렛농업회사법인(주)]테스트[오상목해피아울렛농업회사법인(주)[해피]', '127014886641' ) ========================2019-07-23 16:31:31======================== noteurl_start parm_app_code = 047 parm_pc_name = PARKEUNU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838980109B0CBD94A7 sCDKey = 749447224532 sName = PARKEUNU ========================2019-07-23 16:31: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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-23 16:31:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nexus' ========================2019-07-23 16:31:31======================== SELECT idx FROM macs WHERE mac_addr = '98838980109B0CBD94A7' AND app_code = '047' ========================2019-07-23 16:31:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291190' ========================2019-07-23 16:31:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291190' ========================2019-07-23 16:31:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291190', '98838980109B0CBD94A7', '047', 'PARKEUNU', '�쐢�룄�슦 10', '0', '0', 'nexus', '넥서스메디케어[박종국]', '749447224532' ) ========================2019-07-23 16:31:37======================== noteurl_start parm_app_code = 047 parm_pc_name = PARKEUNU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838980109B0CBD94A7 sCDKey = 749447224532 sName = PARKEUNU ========================2019-07-23 16:31:37======================== 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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-23 16:32:04======================== noteurl_start parm_app_code = 047 parm_pc_name = PARKEUNU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838980109B0CBD94A7 sCDKey = 749447224532 sName = PARKEUNU ========================2019-07-23 16:32: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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-23 16:32:06======================== noteurl_start parm_app_code = 047 parm_pc_name = PARKEUNU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838980109B0CBD94A7 sCDKey = 749447224532 sName = PARKEUNU ========================2019-07-23 16:32: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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-23 16:32:10======================== noteurl_start parm_app_code = 047 parm_pc_name = PARKEUNU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838980109B0CBD94A7 sCDKey = 749447224532 sName = PARKEUNU ========================2019-07-23 16:32:10======================== 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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-23 16:32:15======================== noteurl_start parm_app_code = 047 parm_pc_name = PARKEUNU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838980109B0CBD94A7 sCDKey = 749447224532 sName = PARKEUNU ========================2019-07-23 16:32: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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-23 16:32:17======================== noteurl_start parm_app_code = 047 parm_pc_name = PARKEUNU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838980109B0CBD94A7 sCDKey = 749447224532 sName = PARKEUNU ========================2019-07-23 16:32:17======================== 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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-23 17:25:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NTKVTT0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 32AABABACFD6AE39B9D4 sCDKey = 151317336230 sName = DESKTOP-NTKVTT0 ========================2019-07-23 17:25: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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 18:45:27======================== noteurl_start parm_app_code = 039 parm_pc_name = USER5 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C22B0D0AEA892D5 sCDKey = 396433598527 sName = USER5 ========================2019-07-23 18:45: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 = '396433598527' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-23 18:45:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dulub8899' ========================2019-07-23 18:45:27======================== SELECT idx FROM macs WHERE mac_addr = '408D5C22B0D0AEA892D5' AND app_code = '039' ========================2019-07-23 18:45:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291465' ========================2019-07-23 18:45:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291465' ========================2019-07-23 18:45: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 ( '291465', '408D5C22B0D0AEA892D5', '039', 'USER5', '110', '1920', '1080', 'dulub8899', '듀루브코리아(주)[김소영]', '396433598527' )