========================2019-04-01 08:59:56======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389103ECEB442232E sCDKey = 396262440743 sName = SEC ========================2019-04-01 08:59:56======================== 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 = '396262440743' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 09:00:39======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389103ECEB442232E sCDKey = 396262440743 sName = SEC ========================2019-04-01 09:00: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 = '396262440743' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 09:00:42======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389103ECEB442232E sCDKey = 396262440743 sName = SEC ========================2019-04-01 09:00:42======================== 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 = '396262440743' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 09:01:27======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389103ECEB442232E sCDKey = 396262440743 sName = SEC ========================2019-04-01 09:01: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 = '396262440743' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 09:01:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'king0901' ========================2019-04-01 09:01:27======================== SELECT idx FROM macs WHERE mac_addr = '988389103ECEB442232E' AND app_code = '039' ========================2019-04-01 09:01:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280349' ========================2019-04-01 09:01:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280349' ========================2019-04-01 09:01: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 ( '280349', '988389103ECEB442232E', '039', 'SEC', '110', '1920', '1080', 'king0901', '신대왕상회[김갑룡]', '396262440743' ) ========================2019-04-01 09:01:39======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389103ECEB442232E sCDKey = 396262440743 sName = 대왕상회 ========================2019-04-01 09:01: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 = '396262440743' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 09:41:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1U08AFU parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 48F17F38520C8A3B632C sCDKey = 699676022619 sName = DESKTOP-1U08AFU ========================2019-04-01 09:41:46======================== 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 = '699676022619' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 09:41:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ko613200' ========================2019-04-01 09:41:46======================== SELECT idx FROM macs WHERE mac_addr = '48F17F38520C8A3B632C' AND app_code = '039' ========================2019-04-01 09:41:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1U08AFU parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 48F17F38520C8A3B632C sCDKey = 699676022619 sName = DESKTOP-1U08AFU ========================2019-04-01 09:41:46======================== 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 = '699676022619' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 09:41:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ko613200' ========================2019-04-01 09:41:46======================== SELECT idx FROM macs WHERE mac_addr = '48F17F38520C8A3B632C' AND app_code = '039' ========================2019-04-01 09:41:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281976' ========================2019-04-01 09:41:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281976' ========================2019-04-01 09:41:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281976' ========================2019-04-01 09:41:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281976' ========================2019-04-01 09:41:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '281976', '48F17F38520C8A3B632C', '039', 'DESKTOP-1U08AFU', '110', '1680', '1050', 'ko613200', '대경산업[이숙자]', '699676022619' ) ========================2019-04-01 09:41:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '281976', '48F17F38520C8A3B632C', '039', 'DESKTOP-1U08AFU', '110', '1680', '1050', 'ko613200', '대경산업[이숙자]', '699676022619' ) ========================2019-04-01 10:41:54======================== noteurl_start parm_app_code = 046 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 50B7C3A832E3D4343EBF sCDKey = 342918991698 sName = SAMSUNG ========================2019-04-01 10:41:54======================== 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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-01 10:41:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2019-04-01 10:41:54======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A832E3D4343EBF' AND app_code = '046' ========================2019-04-01 10:41:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281387' ========================2019-04-01 10:41:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281387' ========================2019-04-01 10:41:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '281387', '50B7C3A832E3D4343EBF', '046', 'SAMSUNG', '110', '1600', '900', 'jun9317718', '한농연농자재영농조합법인[전종석]', '342918991698' ) ========================2019-04-01 11:14:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MIC2O4L parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C69135CBDA22768C31 sCDKey = 851112038872 sName = DESKTOP-MIC2O4L ========================2019-04-01 11:14: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 = '851112038872' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 11:14:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goclick01' ========================2019-04-01 11:14:12======================== SELECT idx FROM macs WHERE mac_addr = '94C69135CBDA22768C31' AND app_code = '039' ========================2019-04-01 11:14:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282117' ========================2019-04-01 11:14:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282117' ========================2019-04-01 11:14: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 ( '282117', '94C69135CBDA22768C31', '039', 'DESKTOP-MIC2O4L', '110', '1920', '1080', 'goclick01', '제텍코리아[김형준]', '851112038872' ) ========================2019-04-01 11:27:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-H4F6V6L parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 702C1F112B0F26E53153 sCDKey = 979755277718 sName = DESKTOP-H4F6V6L ========================2019-04-01 11:27:24======================== 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 = '979755277718' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-01 11:27:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dongmuh1' ========================2019-04-01 11:27:24======================== SELECT idx FROM macs WHERE mac_addr = '702C1F112B0F26E53153' AND app_code = '039' ========================2019-04-01 11:27:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274803' ========================2019-04-01 11:27:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274803' ========================2019-04-01 11:27:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274803', '702C1F112B0F26E53153', '039', 'DESKTOP-H4F6V6L', '110', '1920', '1080', 'dongmuh1', '(주)아이유[박동무]', '979755277718' ) ========================2019-04-01 17:01:18======================== noteurl_start parm_app_code = 045 parm_pc_name = SY1001-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E549E5F4E3DC24A30A sCDKey = 789192585329 sName = SY1001-PC ========================2019-04-01 17:01: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 = '789192585329' AND r.app_code = '045' AND r.app_block = 0 ========================2019-04-01 17:01:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kissusa' ========================2019-04-01 17:01:18======================== SELECT idx FROM macs WHERE mac_addr = '50E549E5F4E3DC24A30A' AND app_code = '045' ========================2019-04-01 17:01:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282178' ========================2019-04-01 17:01:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282178' ========================2019-04-01 17:01:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '282178', '50E549E5F4E3DC24A30A', '045', 'SY1001-PC', '90', '1920', '1080', 'kissusa', '(주)제일에듀케이션[김광태]', '789192585329' ) ========================2019-04-01 17:51:34======================== noteurl_start parm_app_code = 048 parm_pc_name = KIMHANDO-NB parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05A0748CCAA34B831 sCDKey = 838267735728 sName = KIMHANDO-NB ========================2019-04-01 17:51: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 = '838267735728' AND r.app_code = '048' AND r.app_block = 0 ========================2019-04-01 17:51:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimhando' ========================2019-04-01 17:51:34======================== SELECT idx FROM macs WHERE mac_addr = '2CD05A0748CCAA34B831' AND app_code = '048' ========================2019-04-01 17:51:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278956' ========================2019-04-01 17:51:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278956' ========================2019-04-01 17:51:34======================== UPDATE mac_detail SET pc_name = 'KIMHANDO-NB', os_type = '�쐢�룄�슦 7', user_id = 'kimhando', user_name = '주식회사 종합유통[김한도]', screen_w = '0', screen_h = '0', cdkey = '838267735728' WHERE mac_idx = '278956'