========================2021-04-29 01:01:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-O90G52F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E085DD28D6DE747547 sCDKey = 422114683375 sName = DESKTOP-O90G52F ========================2021-04-29 01:01: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 = '422114683375' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-29 01:01:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'id4love' ========================2021-04-29 01:01:13======================== SELECT idx FROM macs WHERE mac_addr = '50E085DD28D6DE747547' AND app_code = '039' ========================2021-04-29 01:01:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342213' ========================2021-04-29 01:01:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342213' ========================2021-04-29 01:01:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '342213', '50E085DD28D6DE747547', '039', 'DESKTOP-O90G52F', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375' ) ========================2021-04-29 10:15:07======================== noteurl_start parm_app_code = 039 parm_pc_name = SDF2 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8975AA929D5BCBDEA3E sCDKey = 888494165868 sName = SDF2 ========================2021-04-29 10:15:07======================== 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 = '888494165868' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-29 10:15:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sdf73' ========================2021-04-29 10:15:07======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AA929D5BCBDEA3E' AND app_code = '039' ========================2021-04-29 10:15:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240793' ========================2021-04-29 10:15:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240793' ========================2021-04-29 10:15:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240793', 'B8975AA929D5BCBDEA3E', '039', 'SDF2', '90', '1920', '1080', 'sdf73', '에스디에프[김수강산]', '888494165868' ) ========================2021-04-29 10:33:29======================== noteurl_start parm_app_code = 039 parm_pc_name = SDF6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EBB38ACBA626698 sCDKey = 888494165868 sName = SDF6 ========================2021-04-29 10:33: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 = '888494165868' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-29 10:33:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sdf73' ========================2021-04-29 10:33:29======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EBB38ACBA626698' AND app_code = '039' ========================2021-04-29 10:33:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271340' ========================2021-04-29 10:33:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271340' ========================2021-04-29 10:33:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271340', 'E0D55EBB38ACBA626698', '039', 'SDF6', '110', '1920', '1080', 'sdf73', '에스디에프[김수강산]', '888494165868' ) ========================2021-04-29 11:08:14======================== noteurl_start parm_app_code = 046 parm_pc_name = J-SERIES parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = F4B52013496B25E127F sCDKey = 825937582852 sName = J-SERIES ========================2021-04-29 11:08:14======================== 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 = '825937582852' AND r.app_code = '046' AND r.app_block = 0 ========================2021-04-29 11:08:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yook1317' ========================2021-04-29 11:08:14======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52013496B25E127F' AND app_code = '046' ========================2021-04-29 11:08:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342229' ========================2021-04-29 11:08:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342229' ========================2021-04-29 11:08: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 ( '342229', 'F4B52013496B25E127F', '046', 'J-SERIES', '90', '1024', '768', 'yook1317', '놀부펫마트[고혜경]', '825937582852' ) ========================2021-04-29 14:13:24======================== noteurl_start parm_app_code = 047 parm_pc_name = JOY-LJK parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C3088F881E43C1EC sCDKey = 113389258542 sName = JOY-LJK ========================2021-04-29 14:13: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 = '113389258542' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-29 14:13:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dy1087' ========================2021-04-29 14:13:25======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3088F881E43C1EC' AND app_code = '047' ========================2021-04-29 14:13:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342246' ========================2021-04-29 14:13:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342246' ========================2021-04-29 14:13:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '342246', '50B7C3088F881E43C1EC', '047', 'JOY-LJK', '�쐢�룄�슦 10', '0', '0', 'dy1087', '대영종합상사[이중근]', '113389258542' ) ========================2021-04-29 15:00:10======================== noteurl_start parm_app_code = 039 parm_pc_name = KANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DB931882EBC7890 sCDKey = 720357298336 sName = KANG ========================2021-04-29 15:00: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 = '720357298336' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-29 15:00:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'almoco7844' ========================2021-04-29 15:00:11======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DB931882EBC7890' AND app_code = '039' ========================2021-04-29 15:00:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221644' ========================2021-04-29 15:00:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '221644' ========================2021-04-29 15:00:11======================== UPDATE mac_detail SET pc_name = 'KANG', os_type = '110', user_id = 'almoco7844', user_name = '(주)알모코[배한숙]', screen_w = '1920', screen_h = '1080', cdkey = '720357298336' WHERE mac_idx = '221644' ========================2021-04-29 16:13:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A78STT0 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8F408EE4DBE1E1BCB2A sCDKey = 640084514736 sName = DESKTOP-A78STT0 ========================2021-04-29 16:13: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 = '640084514736' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-29 16:13:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksmo1901' ========================2021-04-29 16:13:06======================== SELECT idx FROM macs WHERE mac_addr = 'E8F408EE4DBE1E1BCB2A' AND app_code = '039' ========================2021-04-29 16:13:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342263' ========================2021-04-29 16:13:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342263' ========================2021-04-29 16:13:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '342263', 'E8F408EE4DBE1E1BCB2A', '039', 'DESKTOP-A78STT0', '110', '1600', '900', 'ksmo1901', '코네스[홍옥자]', '640084514736' )