========================2020-12-02 11:31:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-TJEUAP8 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1078D2217FAF40A2B77D sCDKey = 519313570827 sName = DESKTOP-TJEUAP8 ========================2020-12-02 11:31:41======================== 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 = '519313570827' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-02 11:31:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gldrhks' ========================2020-12-02 11:31:41======================== SELECT idx FROM macs WHERE mac_addr = '1078D2217FAF40A2B77D' AND app_code = '039' ========================2020-12-02 11:31:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331386' ========================2020-12-02 11:31:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331386' ========================2020-12-02 11:31:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331386', '1078D2217FAF40A2B77D', '039', 'DESKTOP-TJEUAP8', '110', '1920', '1080', 'gldrhks', '만나화학[정형관]', '519313570827' ) ========================2020-12-02 13:25:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MNE97UO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050993535D4FE2A849A sCDKey = 033809572186 sName = DESKTOP-MNE97UO ========================2020-12-02 13:25:14======================== 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 = '033809572186' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-02 13:25:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jikunho7' ========================2020-12-02 13:25:14======================== SELECT idx FROM macs WHERE mac_addr = 'D050993535D4FE2A849A' AND app_code = '039' ========================2020-12-02 13:25:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331389' ========================2020-12-02 13:25:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331389' ========================2020-12-02 13:25:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331389', 'D050993535D4FE2A849A', '039', 'DESKTOP-MNE97UO', '110', '1920', '1080', 'jikunho7', '유경공구연삭[지건호]', '033809572186' ) ========================2020-12-02 13:59:22======================== noteurl_start parm_app_code = 047 parm_pc_name = KIMNAMSU-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 38D547280D73A209683B sCDKey = 188728650429 sName = KIMNAMSU-PC ========================2020-12-02 13:59:22======================== 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 = '188728650429' AND r.app_code = '047' AND r.app_block = 0 ========================2020-12-02 13:59:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kak0936' ========================2020-12-02 13:59:22======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73A209683B' AND app_code = '047' ========================2020-12-02 13:59:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317409' ========================2020-12-02 13:59:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317409' ========================2020-12-02 13:59:22======================== UPDATE mac_detail SET pc_name = 'KIMNAMSU-PC', os_type = '�쐢�룄�슦 10', user_id = 'kak0936', user_name = '[김남수]', screen_w = '0', screen_h = '0', cdkey = '188728650429' WHERE mac_idx = '317409' ========================2020-12-02 15:18:46======================== noteurl_start parm_app_code = 055 parm_pc_name = CHOISH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 305A3A58E5C6782808EF sCDKey = 111222222222 sName = CHOISH-PC ========================2020-12-02 15:18:46======================== 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 = '111222222222' AND r.app_code = '055' AND r.app_block = 0 ========================2020-12-02 15:19:24======================== noteurl_start parm_app_code = 055 parm_pc_name = CHOISH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 305A3A58E5C6782808EF sCDKey = 111222222222 sName = CHOISH-PC ========================2020-12-02 15:19: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 = '111222222222' AND r.app_code = '055' AND r.app_block = 0 ========================2020-12-02 16:19:12======================== noteurl_start parm_app_code = 055 parm_pc_name = CHOISH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 305A3A58E5C6782808EF sCDKey = 129847358632 sName = CHOISH-PC ========================2020-12-02 16:19:12======================== 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 = '129847358632' AND r.app_code = '055' AND r.app_block = 0 ========================2020-12-02 16:19:16======================== noteurl_start parm_app_code = 055 parm_pc_name = CHOISH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 305A3A58E5C6782808EF sCDKey = 129847358631 sName = CHOISH-PC ========================2020-12-02 16:19:16======================== 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 = '129847358631' AND r.app_code = '055' AND r.app_block = 0 ========================2020-12-02 16:19:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mjdev' ========================2020-12-02 16:19:16======================== SELECT idx FROM macs WHERE mac_addr = '305A3A58E5C6782808EF' AND app_code = '055' ========================2020-12-02 16:19:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329988' ========================2020-12-02 16:19:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329988' ========================2020-12-02 16:19: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 ( '329988', '305A3A58E5C6782808EF', '055', 'CHOISH-PC', '�쐢�룄�슦 10', '0', '0', 'mjdev', '엠제이소프트[최상호]', '129847358631' ) ========================2020-12-02 16:21:38======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-4AGGGL7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99F0C48B441BD27 sCDKey = 094475644696 sName = DESKTOP-4AGGGL7 ========================2020-12-02 16:21:38======================== 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 = '094475644696' AND r.app_code = '045' AND r.app_block = 0 ========================2020-12-02 16:21:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'saehansystem' ========================2020-12-02 16:21:38======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99F0C48B441BD27' AND app_code = '045' ========================2020-12-02 16:21:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329180' ========================2020-12-02 16:21:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329180' ========================2020-12-02 16:21:38======================== UPDATE mac_detail SET pc_name = 'DESKTOP-4AGGGL7', os_type = '110', user_id = 'saehansystem', user_name = '새한시스템[김대중]', screen_w = '1920', screen_h = '1080', cdkey = '094475644696' WHERE mac_idx = '329180' ========================2020-12-02 16:36:41======================== noteurl_start parm_app_code = 039 parm_pc_name = JBH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA1421AD52BC1368E0 sCDKey = 550400830049 sName = JBH-PC ========================2020-12-02 16:36:41======================== 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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-02 16:38:16======================== noteurl_start parm_app_code = 039 parm_pc_name = JBH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA1421AD52BC1368E0 sCDKey = 550400830049 sName = JBH-PC ========================2020-12-02 16:38:16======================== 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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-02 16:38:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bmtec' ========================2020-12-02 16:38:16======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA1421AD52BC1368E0' AND app_code = '039' ========================2020-12-02 16:38:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331429' ========================2020-12-02 16:38:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331429' ========================2020-12-02 16:38: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 ( '331429', 'FCAA1421AD52BC1368E0', '039', 'JBH-PC', '110', '1920', '1080', 'bmtec', 'BMTEC[전보현]', '550400830049' )