========================2020-09-11 10:32:24======================== noteurl_start parm_app_code = 039 parm_pc_name = COM-A402 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99DAFF3F16AE9BEF sCDKey = 625904807748 sName = COM-A402 ========================2020-09-11 10:32: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 = '625904807748' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-11 10:32:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gkswls1212' ========================2020-09-11 10:32:24======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99DAFF3F16AE9BEF' AND app_code = '039' ========================2020-09-11 10:32:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323814' ========================2020-09-11 10:32:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323814' ========================2020-09-11 10:32:24======================== UPDATE mac_detail SET pc_name = 'COM-A402', os_type = '110', user_id = 'gkswls1212', user_name = '(주)에스제이로지스틱스[이재민]', screen_w = '1920', screen_h = '1080', cdkey = '625904807748' WHERE mac_idx = '323814' ========================2020-09-11 10:44:31======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4C72B97BC007E09C8485 sCDKey = 793826742661 sName = USER-PC ========================2020-09-11 10:44:31======================== 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 = '793826742661' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-11 10:44:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljh820526' ========================2020-09-11 10:44:31======================== SELECT idx FROM macs WHERE mac_addr = '4C72B97BC007E09C8485' AND app_code = '039' ========================2020-09-11 10:44:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270489' ========================2020-09-11 10:44:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270489' ========================2020-09-11 10:44:31======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'ljh820526', user_name = 'kgb상주지점[이재혁]', screen_w = '1920', screen_h = '1080', cdkey = '793826742661' WHERE mac_idx = '270489' ========================2020-09-11 11:44:52======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D05099312FCADDE41AB9 sCDKey = 638321752964 sName = PC ========================2020-09-11 11:44: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 = '638321752964' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-11 11:44:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rth1513' ========================2020-09-11 11:44:52======================== SELECT idx FROM macs WHERE mac_addr = 'D05099312FCADDE41AB9' AND app_code = '039' ========================2020-09-11 11:44:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326027' ========================2020-09-11 11:44:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '326027' ========================2020-09-11 11:44:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '326027', 'D05099312FCADDE41AB9', '039', 'PC', '110', '1600', '900', 'rth1513', '세기건설산업[류태희]', '638321752964' ) ========================2020-09-11 13:49:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A72UK8O parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D83BBF93555372507326 sCDKey = 551061671146 sName = DESKTOP-A72UK8O ========================2020-09-11 13:49:15======================== 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 = '551061671146' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-11 13:49:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'huahc' ========================2020-09-11 13:49:16======================== SELECT idx FROM macs WHERE mac_addr = 'D83BBF93555372507326' AND app_code = '039' ========================2020-09-11 13:49:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326041' ========================2020-09-11 13:49:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '326041' ========================2020-09-11 13:49:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '326041', 'D83BBF93555372507326', '039', 'DESKTOP-A72UK8O', '110', '1536', '864', 'huahc', '한울AHC[이공엽]', '551061671146' )