========================2019-12-30 09:27:13======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-I32F46K parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 185680ABF2B6F0967D65 sCDKey = 389590212593 sName = DESKTOP-I32F46K ========================2019-12-30 09:27: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 = '389590212593' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-30 09:27:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mushia' ========================2019-12-30 09:27:14======================== SELECT idx FROM macs WHERE mac_addr = '185680ABF2B6F0967D65' AND app_code = '048' ========================2019-12-30 09:27:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290740' ========================2019-12-30 09:27:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290740' ========================2019-12-30 09:27:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290740', '185680ABF2B6F0967D65', '048', 'DESKTOP-I32F46K', '�쐢�룄�슦 10', '0', '0', 'mushia', '농업회사법인(주)뜰아채[권경열]', '389590212593' ) ========================2019-12-30 09:35:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-J2LHTO4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 107B449105A0F6448F44 sCDKey = 204297080946 sName = 메인포스(박정옥) ========================2019-12-30 09:35:35======================== 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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2019-12-30 09:35:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2019-12-30 09:35:35======================== SELECT idx FROM macs WHERE mac_addr = '107B449105A0F6448F44' AND app_code = '047' ========================2019-12-30 09:35:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306541' ========================2019-12-30 09:35:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306541' ========================2019-12-30 09:35:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '306541', '107B449105A0F6448F44', '047', '메인포스(박정옥)', '�쐢�룄�슦 10', '0', '0', 'ulsanwood', '연암철물공구종합상사[박동진]', '204297080946' ) ========================2019-12-30 10:08:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S7MC94K parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF468182F720A2A74 sCDKey = rysk7rl75rs7 sName = DESKTOP-S7MC94K ========================2019-12-30 10:08: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 = 'RYSK7RL75RS7' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-30 10:08:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S7MC94K parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF468182F720A2A74 sCDKey = 000000000000 sName = DESKTOP-S7MC94K ========================2019-12-30 10:08: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 = '000000000000' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-30 10:08:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S7MC94K parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF468182F720A2A74 sCDKey = 000000000001 sName = DESKTOP-S7MC94K ========================2019-12-30 10:08: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 = '000000000001' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-30 10:08:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S7MC94K parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF468182F720A2A74 sCDKey = 0123456789xx sName = DESKTOP-S7MC94K ========================2019-12-30 10:08: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 = '0123456789XX' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-30 10:38:19======================== noteurl_start parm_app_code = 039 parm_pc_name = JY-20191218ZHMS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A15902C1F2866D36EE sCDKey = 780420206219 sName = JY-20191218ZHMS ========================2019-12-30 10:38: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 = '780420206219' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-30 10:38:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssal5707' ========================2019-12-30 10:38:19======================== SELECT idx FROM macs WHERE mac_addr = 'A8A15902C1F2866D36EE' AND app_code = '039' ========================2019-12-30 10:38:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306639' ========================2019-12-30 10:38:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306639' ========================2019-12-30 10:38:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '306639', 'A8A15902C1F2866D36EE', '039', 'JY-20191218ZHMS', '110', '1920', '1080', 'ssal5707', '좋은이웃[조형석]', '780420206219' ) ========================2019-12-30 11:15:02======================== noteurl_start parm_app_code = 039 parm_pc_name = JY-20191218ZHMS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A15902C1F2866D36EE sCDKey = 780420206219 sName = JY-20191218ZHMS ========================2019-12-30 11:15:02======================== 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 = '780420206219' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-30 11:15:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssal5707' ========================2019-12-30 11:15:02======================== SELECT idx FROM macs WHERE mac_addr = 'A8A15902C1F2866D36EE' AND app_code = '039' ========================2019-12-30 11:15:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306639' ========================2019-12-30 11:15:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306639' ========================2019-12-30 11:15:02======================== UPDATE mac_detail SET pc_name = 'JY-20191218ZHMS', os_type = '110', user_id = 'ssal5707', user_name = '좋은이웃[조형석]', screen_w = '1920', screen_h = '1080', cdkey = '780420206219' WHERE mac_idx = '306639' ========================2019-12-30 11:15:16======================== noteurl_start parm_app_code = 039 parm_pc_name = JY-20191218VEDZ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A15902C21A866D36EE sCDKey = 780420206219 sName = JY-20191218VEDZ ========================2019-12-30 11:15:16======================== 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 = '780420206219' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-30 11:15:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssal5707' ========================2019-12-30 11:15:17======================== SELECT idx FROM macs WHERE mac_addr = 'A8A15902C21A866D36EE' AND app_code = '039' ========================2019-12-30 11:15:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306652' ========================2019-12-30 11:15:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306652' ========================2019-12-30 11:15:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '306652', 'A8A15902C21A866D36EE', '039', 'JY-20191218VEDZ', '110', '1920', '1080', 'ssal5707', '좋은이웃[조형석]', '780420206219' ) ========================2019-12-30 15:09:32======================== noteurl_start parm_app_code = 046 parm_pc_name = DM700 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039AF3480424659202 sCDKey = 343408108096 sName = DM700 ========================2019-12-30 15:09: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 = '343408108096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-30 15:10:39======================== noteurl_start parm_app_code = 046 parm_pc_name = DM700 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039AF3480424659202 sCDKey = 343408108095 sName = DM700 ========================2019-12-30 15:10: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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-30 15:10:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rain1479' ========================2019-12-30 15:10:39======================== SELECT idx FROM macs WHERE mac_addr = 'E8039AF3480424659202' AND app_code = '046' ========================2019-12-30 15:10:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '217579' ========================2019-12-30 15:10:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '217579' ========================2019-12-30 15:10:39======================== UPDATE mac_detail SET pc_name = 'DM700', os_type = '90', user_id = 'rain1479', user_name = '한영사[고경태]', screen_w = '1920', screen_h = '1080', cdkey = '343408108095' WHERE mac_idx = '217579' ========================2019-12-30 16:42:30======================== noteurl_start parm_app_code = 047 parm_pc_name = APROMAN-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74D435AF540FEE1999FD sCDKey = 230362309828 sName = APROMAN-PC임시 ========================2019-12-30 16:42:30======================== 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 = '230362309828' AND r.app_code = '047' AND r.app_block = 0 ========================2019-12-30 16:42:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jclocal' ========================2019-12-30 16:42:30======================== SELECT idx FROM macs WHERE mac_addr = '74D435AF540FEE1999FD' AND app_code = '047' ========================2019-12-30 16:42:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293596' ========================2019-12-30 16:42:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293596' ========================2019-12-30 16:42:30======================== UPDATE mac_detail SET pc_name = 'APROMAN-PC임시', os_type = '�쐢�룄�슦 7', user_id = 'jclocal', user_name = '제천로컬푸드협동조합[김현주]', screen_w = '0', screen_h = '0', cdkey = '230362309828' WHERE mac_idx = '293596'