========================2022-12-12 09:29:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1QUCC54 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23E60CB92E87FB70 sCDKey = 524683033828 sName = DESKTOP-1QUCC54 ========================2022-12-12 09:29: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 = '524683033828' AND r.app_code = '039' AND r.app_block = 0 ========================2022-12-12 09:29:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hellobang' ========================2022-12-12 09:29:48======================== SELECT idx FROM macs WHERE mac_addr = '309C23E60CB92E87FB70' AND app_code = '039' ========================2022-12-12 09:29:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '377770' ========================2022-12-12 09:29:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '377770' ========================2022-12-12 09:29: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 ( '377770', '309C23E60CB92E87FB70', '039', 'DESKTOP-1QUCC54', '110', '1920', '1080', 'hellobang', '엠제이소프트[방정애]', '524683033828' ) ========================2022-12-12 13:03:01======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-R4TK2S6 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = C81F66101CDDBA23AA9E sCDKey = 990376709320 sName = DESKTOP-R4TK2S6 ========================2022-12-12 13:03:01======================== 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 = '990376709320' AND r.app_code = '046' AND r.app_block = 0 ========================2022-12-12 13:03:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hotdog_hm' ========================2022-12-12 13:03:02======================== SELECT idx FROM macs WHERE mac_addr = 'C81F66101CDDBA23AA9E' AND app_code = '046' ========================2022-12-12 13:03:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '378684' ========================2022-12-12 13:03:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '378684' ========================2022-12-12 13:03:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '378684', 'C81F66101CDDBA23AA9E', '046', 'DESKTOP-R4TK2S6', '110', '1600', '900', 'hotdog_hm', '핫독애견용품 화명점[최수빈]', '990376709320' ) ========================2022-12-12 13:32:47======================== noteurl_start parm_app_code = 039 parm_pc_name = 2F-PC2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1078D23254619E883E5F sCDKey = 528590564511 sName = 2F-PC2 ========================2022-12-12 13:32:47======================== 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 = '528590564511' AND r.app_code = '039' AND r.app_block = 0 ========================2022-12-12 13:32:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jw3071' ========================2022-12-12 13:32:47======================== SELECT idx FROM macs WHERE mac_addr = '1078D23254619E883E5F' AND app_code = '039' ========================2022-12-12 13:32:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334300' ========================2022-12-12 13:32:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334300' ========================2022-12-12 13:32:47======================== UPDATE mac_detail SET pc_name = '2F-PC2', os_type = '110', user_id = 'jw3071', user_name = '(주)정우전기통신[정채욱]', screen_w = '1920', screen_h = '1080', cdkey = '528590564511' WHERE mac_idx = '334300' ========================2022-12-12 13:48:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-ERVBSER parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E8039A641DE874BA0CC9 sCDKey = 528590564511 sName = DESKTOP-ERVBSER ========================2022-12-12 13:48: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 = '528590564511' AND r.app_code = '039' AND r.app_block = 0 ========================2022-12-12 13:48:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jw3071' ========================2022-12-12 13:48:18======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A641DE874BA0CC9' AND app_code = '039' ========================2022-12-12 13:48:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '378694' ========================2022-12-12 13:48:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '378694' ========================2022-12-12 13:48: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 ( '378694', 'E8039A641DE874BA0CC9', '039', 'DESKTOP-ERVBSER', '110', '1680', '1050', 'jw3071', '(주)정우전기통신[정채욱]', '528590564511' )