========================2020-08-14 13:38:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-91AG4DG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAEC82CE12A3E273 sCDKey = 999859363809 sName = DESKTOP-91AG4DG ========================2020-08-14 13:38:28======================== 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 = '999859363809' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-14 13:38:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nkh10710' ========================2020-08-14 13:38:28======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEC82CE12A3E273' AND app_code = '039' ========================2020-08-14 13:38:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '192926' ========================2020-08-14 13:38:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '192926' ========================2020-08-14 13:38:28======================== UPDATE mac_detail SET pc_name = 'DESKTOP-91AG4DG', os_type = '110', user_id = 'nkh10710', user_name = '벧엘콘테이너[나광훈]', screen_w = '1920', screen_h = '1080', cdkey = '999859363809' WHERE mac_idx = '192926' ========================2020-08-14 14:09:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6M0K0DC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE8068325BEAE16348 sCDKey = 977860147426 sName = DESKTOP-6M0K0DC ========================2020-08-14 14:09: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 = '977860147426' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-14 14:09:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bongbong0407' ========================2020-08-14 14:09:37======================== SELECT idx FROM macs WHERE mac_addr = '94DE8068325BEAE16348' AND app_code = '039' ========================2020-08-14 14:09:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '324062' ========================2020-08-14 14:09:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '324062' ========================2020-08-14 14:09:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '324062', '94DE8068325BEAE16348', '039', 'DESKTOP-6M0K0DC', '110', '1920', '1080', 'bongbong0407', '대광가스[신봉식]', '977860147426' ) ========================2020-08-14 15:06:56======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-R6KEDKN parm_os_type = 110 parm_screen_w = 2048 parm_screen_h = 1152 parm_user_mac = B06EBF7FCD6754FAC911 sCDKey = 189211469524 sName = DESKTOP-R6KEDKN ========================2020-08-14 15:06:56======================== 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 = '189211469524' AND r.app_code = '045' AND r.app_block = 0 ========================2020-08-14 15:06:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mdatlas' ========================2020-08-14 15:06:56======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBF7FCD6754FAC911' AND app_code = '045' ========================2020-08-14 15:06:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '324067' ========================2020-08-14 15:06:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '324067' ========================2020-08-14 15:06:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '324067', 'B06EBF7FCD6754FAC911', '045', 'DESKTOP-R6KEDKN', '110', '2048', '1152', 'mdatlas', '동창베어링상사[박재천]', '189211469524' ) ========================2020-08-14 16:13:51======================== noteurl_start parm_app_code = 048 parm_pc_name = SDH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F4B52017918E1C4E35F8 sCDKey = 114615321871 sName = SDH ========================2020-08-14 16:13:51======================== 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 = '114615321871' AND r.app_code = '048' AND r.app_block = 0 ========================2020-08-14 16:13:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nenara999' ========================2020-08-14 16:13:52======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52017918E1C4E35F8' AND app_code = '048' ========================2020-08-14 16:13:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320688' ========================2020-08-14 16:13:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320688' ========================2020-08-14 16:13: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 ( '320688', 'F4B52017918E1C4E35F8', '048', 'SDH', '�쐢�룄�슦 10', '0', '0', 'nenara999', '[성대휘]', '114615321871' ) ========================2020-08-14 17:55:39======================== noteurl_start parm_app_code = 048 parm_pc_name = SDH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F4B52017918E1C4E35F8 sCDKey = 114615321871 sName = SDH ========================2020-08-14 17:55:39======================== 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 = '114615321871' AND r.app_code = '048' AND r.app_block = 0 ========================2020-08-14 17:55:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nenara999' ========================2020-08-14 17:55:39======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52017918E1C4E35F8' AND app_code = '048' ========================2020-08-14 17:55:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320688' ========================2020-08-14 17:55:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320688' ========================2020-08-14 17:55:39======================== UPDATE mac_detail SET pc_name = 'SDH', os_type = '�쐢�룄�슦 10', user_id = 'nenara999', user_name = '[성대휘]', screen_w = '0', screen_h = '0', cdkey = '114615321871' WHERE mac_idx = '320688'