========================2021-11-23 10:54:46======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-UA98KIG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A45E60D4C7F302469FF7 sCDKey = 389590212593 sName = DESKTOP-UA98KIG ========================2021-11-23 10:54: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 = '389590212593' AND r.app_code = '048' AND r.app_block = 0 ========================2021-11-23 10:54:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mushia' ========================2021-11-23 10:54:46======================== SELECT idx FROM macs WHERE mac_addr = 'A45E60D4C7F302469FF7' AND app_code = '048' ========================2021-11-23 10:54:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355042' ========================2021-11-23 10:54:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355042' ========================2021-11-23 10:54:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355042', 'A45E60D4C7F302469FF7', '048', 'DESKTOP-UA98KIG', '�쐢�룄�슦 10', '0', '0', 'mushia', '농업회사법인(주)뜰아채[권경열]', '389590212593' ) ========================2021-11-23 11:39:52======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4GFO20O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 705DCCF1F4002A786276 sCDKey = 258870946981 sName = JA5 ========================2021-11-23 11:39: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 = '258870946981' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-23 11:39:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jangangun' ========================2021-11-23 11:39:52======================== SELECT idx FROM macs WHERE mac_addr = '705DCCF1F4002A786276' AND app_code = '047' ========================2021-11-23 11:39:52======================== 값이 없을 경우 ========================2021-11-23 11:39:55======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4GFO20O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 705DCCF1F4002A786276 sCDKey = 258870946981 sName = JA5 ========================2021-11-23 11:39:55======================== 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 = '258870946981' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-23 11:39:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jangangun' ========================2021-11-23 11:39:55======================== SELECT idx FROM macs WHERE mac_addr = '705DCCF1F4002A786276' AND app_code = '047' ========================2021-11-23 11:39:55======================== 값이 없을 경우 ========================2021-11-23 11:41:23======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4GFO20O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 705DCCF1F4002A786276 sCDKey = 258870946981 sName = DESKTOP-4GFO20O ========================2021-11-23 11:41:23======================== 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 = '258870946981' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-23 11:41:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jangangun' ========================2021-11-23 11:41:23======================== SELECT idx FROM macs WHERE mac_addr = '705DCCF1F4002A786276' AND app_code = '047' ========================2021-11-23 11:41:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355046' ========================2021-11-23 11:41:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355046' ========================2021-11-23 11:41:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355046', '705DCCF1F4002A786276', '047', 'DESKTOP-4GFO20O', '�쐢�룄�슦 10', '0', '0', 'jangangun', '장안건[임종희]', '258870946981' ) ========================2021-11-23 15:41:48======================== noteurl_start parm_app_code = 039 parm_pc_name = JSR parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = D050999A040C1ED4B546 sCDKey = 362250364013 sName = JSR ========================2021-11-23 15:41: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 = '362250364013' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-23 15:41:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qnc1425' ========================2021-11-23 15:41:48======================== SELECT idx FROM macs WHERE mac_addr = 'D050999A040C1ED4B546' AND app_code = '039' ========================2021-11-23 15:41:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355067' ========================2021-11-23 15:41:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355067' ========================2021-11-23 15:41:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355067', 'D050999A040C1ED4B546', '039', 'JSR', '110', '1920', '1200', 'qnc1425', '(주)큐엔씨B2B점[은효미]', '362250364013' ) ========================2021-11-23 17:11:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MFV7TIV parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFBC060FCA6C931BE sCDKey = 557476796053 sName = DESKTOP-MFV7TIV ========================2021-11-23 17:11:40======================== 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 = '557476796053' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-23 17:12:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MFV7TIV parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFBC060FCA6C931BE sCDKey = 557476796053 sName = DESKTOP-MFV7TIV ========================2021-11-23 17:12: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 = '557476796053' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-23 17:13:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MFV7TIV parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFBC060FCA6C931BE sCDKey = 557476796053 sName = DESKTOP-MFV7TIV ========================2021-11-23 17:13: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 = '557476796053' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-23 17:13:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kidswins' ========================2021-11-23 17:13:04======================== SELECT idx FROM macs WHERE mac_addr = '4CEDFBC060FCA6C931BE' AND app_code = '039' ========================2021-11-23 17:13:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355081' ========================2021-11-23 17:13:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355081' ========================2021-11-23 17:13:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355081', '4CEDFBC060FCA6C931BE', '039', 'DESKTOP-MFV7TIV', '110', '1920', '1080', 'kidswins', '승리실업[임제석]', '557476796053' ) ========================2021-11-23 17:13:10======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MFV7TIV parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFBC060FCA6C931BE sCDKey = 557476796053 sName = DESKTOP-MFV7TIV ========================2021-11-23 17:13: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 = '557476796053' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-23 22:25:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-T9FHCL2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 84A9386A7CEC7C89AAB4 sCDKey = 422114683375 sName = DESKTOP-T9FHCL2 ========================2021-11-23 22:25:55======================== 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