========================2021-05-26 10:17:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-TTG4330 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = CCD9AC4DE310C6450B7A sCDKey = 204096420552 sName = DESKTOP-TTG4330 ========================2021-05-26 10:17:26======================== 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 = '204096420552' AND r.app_code = '039' AND r.app_block = 0 ========================2021-05-26 10:17:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ki0889' ========================2021-05-26 10:17:26======================== SELECT idx FROM macs WHERE mac_addr = 'CCD9AC4DE310C6450B7A' AND app_code = '039' ========================2021-05-26 10:17:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344131' ========================2021-05-26 10:17:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344131' ========================2021-05-26 10:17:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '344131', 'CCD9AC4DE310C6450B7A', '039', 'DESKTOP-TTG4330', '110', '1920', '1080', 'ki0889', '경일포장[김기춘]', '204096420552' ) ========================2021-05-26 13:48:57======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 24F5AAAE8B8336902760 sCDKey = 204096420552 sName = SEC ========================2021-05-26 13:48:57======================== 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 = '204096420552' AND r.app_code = '039' AND r.app_block = 0 ========================2021-05-26 13:48:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ki0889' ========================2021-05-26 13:48:57======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAAE8B8336902760' AND app_code = '039' ========================2021-05-26 13:48:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223264' ========================2021-05-26 13:48:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223264' ========================2021-05-26 13:48:57======================== UPDATE mac_detail SET pc_name = 'SEC', os_type = '110', user_id = 'ki0889', user_name = '경일포장[김기춘]', screen_w = '1366', screen_h = '768', cdkey = '204096420552' WHERE mac_idx = '223264' ========================2021-05-26 13:58:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RTPEE2R parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 18C04D98AC9EE6264379 sCDKey = 768252437481 sName = DESKTOP-RTPEE2R ========================2021-05-26 13:58:02======================== 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 = '768252437481' AND r.app_code = '039' AND r.app_block = 0 ========================2021-05-26 13:58:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'askig750' ========================2021-05-26 13:58:02======================== SELECT idx FROM macs WHERE mac_addr = '18C04D98AC9EE6264379' AND app_code = '039' ========================2021-05-26 13:58:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344162' ========================2021-05-26 13:58:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344162' ========================2021-05-26 13:58: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 ( '344162', '18C04D98AC9EE6264379', '039', 'DESKTOP-RTPEE2R', '110', '1360', '768', 'askig750', '혜일정공[정나영]', '768252437481' ) ========================2021-05-26 15:30:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q1671TK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8BBC119715890C13917 sCDKey = 644547527760 sName = DESKTOP-Q1671TK ========================2021-05-26 15:30: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 = '644547527760' AND r.app_code = '039' AND r.app_block = 0 ========================2021-05-26 15:30:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeong4023' ========================2021-05-26 15:30:18======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC119715890C13917' AND app_code = '039' ========================2021-05-26 15:30:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342771' ========================2021-05-26 15:30:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342771' ========================2021-05-26 15:30: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 ( '342771', 'D8BBC119715890C13917', '039', 'DESKTOP-Q1671TK', '110', '1920', '1080', 'jeong4023', '[김태정]', '644547527760' ) ========================2021-05-26 16:24:26======================== noteurl_start parm_app_code = 046 parm_pc_name = CHOCO-2DD4BEC4A parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F04DA2EF4B1F70979762 sCDKey = 620618697812 sName = 포스PC ========================2021-05-26 16:24:26======================== 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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-26 16:24:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-26 16:24:26======================== SELECT idx FROM macs WHERE mac_addr = 'F04DA2EF4B1F70979762' AND app_code = '046' ========================2021-05-26 16:24:26======================== 값이 없을 경우 ========================2021-05-26 16:24:50======================== noteurl_start parm_app_code = 046 parm_pc_name = CHOCO-2DD4BEC4A parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F04DA2EF4B1F70979762 sCDKey = 620618697812 sName = 포스PC ========================2021-05-26 16:24:50======================== 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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-26 16:24:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-26 16:24:50======================== SELECT idx FROM macs WHERE mac_addr = 'F04DA2EF4B1F70979762' AND app_code = '046' ========================2021-05-26 16:24:50======================== 값이 없을 경우 ========================2021-05-26 16:25:58======================== noteurl_start parm_app_code = 046 parm_pc_name = CHOCO-2DD4BEC4A parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F04DA2EF4B1F70979762 sCDKey = 620618697812 sName = CHOCO-2DD4BEC4A ========================2021-05-26 16:25:58======================== 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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-26 16:25:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-26 16:25:58======================== SELECT idx FROM macs WHERE mac_addr = 'F04DA2EF4B1F70979762' AND app_code = '046' ========================2021-05-26 16:25:58======================== 값이 없을 경우 ========================2021-05-26 16:26:40======================== noteurl_start parm_app_code = 046 parm_pc_name = CHOCO-2DD4BEC4A parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F04DA2EF4B1F70979762 sCDKey = 620618697812 sName = 포스PC ========================2021-05-26 16:26: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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-26 16:26:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-26 16:26:40======================== SELECT idx FROM macs WHERE mac_addr = 'F04DA2EF4B1F70979762' AND app_code = '046' ========================2021-05-26 16:26:40======================== 값이 없을 경우 ========================2021-05-26 16:39:48======================== noteurl_start parm_app_code = 046 parm_pc_name = SDHVB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 1440 parm_user_mac = 080027A6D2FC280D8FDA sCDKey = 555555555555 sName = SDHVB ========================2021-05-26 16:39: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 = '555555555555' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-26 16:40:37======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-MLMCTF6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1596B603F8E7DA426 sCDKey = 620618697812 sName = DESKTOP-MLMCTF6 ========================2021-05-26 16:40: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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-26 16:40:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-26 16:40:37======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1596B603F8E7DA426' AND app_code = '046' ========================2021-05-26 16:40:37======================== 값이 없을 경우 ========================2021-05-26 16:41:52======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-MLMCTF6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1596B603F8E7DA426 sCDKey = 620618697812 sName = DESKTOP-MLMCTF6 ========================2021-05-26 16:41: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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-26 16:41:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-26 16:41:52======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1596B603F8E7DA426' AND app_code = '046' ========================2021-05-26 16:41:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344184' ========================2021-05-26 16:41:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344184' ========================2021-05-26 16:41: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 ( '344184', 'A8A1596B603F8E7DA426', '046', 'DESKTOP-MLMCTF6', '110', '1920', '1080', 'k4074356', '주식회사배관공구24시[김귀한]', '620618697812' ) ========================2021-05-26 16:44:53======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-MLMCTF6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1596B603F8E7DA426 sCDKey = 620618697812 sName = DESKTOP-MLMCTF6 ========================2021-05-26 16:44:53======================== 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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-26 16:44:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-26 16:44:54======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1596B603F8E7DA426' AND app_code = '046' ========================2021-05-26 16:44:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344184' ========================2021-05-26 16:44:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344184' ========================2021-05-26 16:44:54======================== UPDATE mac_detail SET pc_name = 'DESKTOP-MLMCTF6', os_type = '110', user_id = 'k4074356', user_name = '주식회사배관공구24시[김귀한]', screen_w = '1920', screen_h = '1080', cdkey = '620618697812' WHERE mac_idx = '344184' ========================2021-05-26 22:24:26======================== noteurl_start parm_app_code = 048 parm_pc_name = TOROXMCS11 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1866DA0F6A17E2734FC3 sCDKey = 566190602039 sName = divepark ========================2021-05-26 22:24:26======================== 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 = '566190602039' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-26 22:25:21======================== noteurl_start parm_app_code = 048 parm_pc_name = TOROXMCS11 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1866DA0F6A17E2734FC3 sCDKey = 566190602039 sName = 박인 ========================2021-05-26 22:25:21======================== 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 = '566190602039' AND r.app_code = '048' AND r.app_block = 0