========================2020-05-07 09:44:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G9FED92 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98E743CA6CEBBA0DF4E0 sCDKey = 422114683375 sName = DESKTOP-G9FED92 ========================2020-05-07 09:44:34======================== 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 ========================2020-05-07 09:44:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'id4love' ========================2020-05-07 09:44:34======================== SELECT idx FROM macs WHERE mac_addr = '98E743CA6CEBBA0DF4E0' AND app_code = '039' ========================2020-05-07 09:44:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '316752' ========================2020-05-07 09:44:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '316752' ========================2020-05-07 09:44:34======================== UPDATE mac_detail SET pc_name = 'DESKTOP-G9FED92', os_type = '110', user_id = 'id4love', user_name = '파란컴퓨터[김현우]', screen_w = '1920', screen_h = '1080', cdkey = '422114683375' WHERE mac_idx = '316752' ========================2020-05-07 09:54:40======================== noteurl_start parm_app_code = 045 parm_pc_name = MISEON parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883898010BDCBD94A7 sCDKey = 682789246839 sName = MISEON ========================2020-05-07 09:54: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 = '682789246839' AND r.app_code = '045' AND r.app_block = 0 ========================2020-05-07 09:54:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chonha00' ========================2020-05-07 09:54:40======================== SELECT idx FROM macs WHERE mac_addr = '9883898010BDCBD94A7' AND app_code = '045' ========================2020-05-07 09:54:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '316911' ========================2020-05-07 09:54:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '316911' ========================2020-05-07 09:54:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '316911', '9883898010BDCBD94A7', '045', 'MISEON', '110', '1920', '1080', 'chonha00', '[손현일]', '682789246839' ) ========================2020-05-07 10:04:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-YUE59FG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389895AF26EFD7E7B sCDKey = 670895645247 sName = DESKTOP-YUE59FG ========================2020-05-07 10:04: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 = '670895645247' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-07 13:11:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VVKN1V6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99E8AF8E6489C12 sCDKey = 583226112659 sName = DESKTOP-VVKN1V6 ========================2020-05-07 13:11: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 = '583226112659' AND r.app_code = '039' AND r.app_block = 0 ========================2020-05-07 13:11:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs572' ========================2020-05-07 13:11:52======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99E8AF8E6489C12' AND app_code = '039' ========================2020-05-07 13:11:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '316940' ========================2020-05-07 13:11:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '316940' ========================2020-05-07 13:11: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 ( '316940', 'B42E99E8AF8E6489C12', '039', 'DESKTOP-VVKN1V6', '110', '1920', '1080', 'bs572', '부여대한지게차[부산지사]', '583226112659' ) ========================2020-05-07 21:35:37======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-S9B4SAJ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10E7C6044A5554340062 sCDKey = 362230354924 sName = DESKTOP-S9B4SAJ ========================2020-05-07 21:35:37======================== 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 = '362230354924' AND r.app_code = '050' AND r.app_block = 0 ========================2020-05-07 21:36:06======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-S9B4SAJ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10E7C6044A5554340062 sCDKey = 362230354924 sName = DESKTOP-S9B4SAJ ========================2020-05-07 21:36: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 = '362230354924' AND r.app_code = '050' AND r.app_block = 0