========================2022-05-06 07:50:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BPL8NEG parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 6C29952D82325C3F28CA sCDKey = 361074279643 sName = DESKTOP-BPL8NEG ========================2022-05-06 07:50:36======================== 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 = '361074279643' AND r.app_code = '046' AND r.app_block = 0 ========================2022-05-06 07:50:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds7098' ========================2022-05-06 07:50:36======================== SELECT idx FROM macs WHERE mac_addr = '6C29952D82325C3F28CA' AND app_code = '046' ========================2022-05-06 07:50:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '366313' ========================2022-05-06 07:50:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '366313' ========================2022-05-06 07:50:36======================== UPDATE mac_detail SET pc_name = 'DESKTOP-BPL8NEG', os_type = '110', user_id = 'ds7098', user_name = '덕수상사[곽회출]', screen_w = '1280', screen_h = '720', cdkey = '361074279643' WHERE mac_idx = '366313' ========================2022-05-06 08:52:55======================== noteurl_start parm_app_code = 048 parm_pc_name = 김대훈 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E9915C2A0A8EFAB9 sCDKey = 434133617514 sName = 김대훈 ========================2022-05-06 08:52: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2022-05-06 08:52:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2022-05-06 08:52:55======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9915C2A0A8EFAB9' AND app_code = '048' ========================2022-05-06 08:52:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '354076' ========================2022-05-06 08:52:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '354076' ========================2022-05-06 08:52:55======================== UPDATE mac_detail SET pc_name = '김대훈', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '354076' ========================2022-05-06 09:41:08======================== noteurl_start parm_app_code = 048 parm_pc_name = 2층사무실1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E914FD92B860C755 sCDKey = 434133617514 sName = 2층사무실1 ========================2022-05-06 09:41:08======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2022-05-06 09:41:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2022-05-06 09:41:08======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E914FD92B860C755' AND app_code = '048' ========================2022-05-06 09:41:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '324425' ========================2022-05-06 09:41:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '324425' ========================2022-05-06 09:41:08======================== UPDATE mac_detail SET pc_name = '2층사무실1', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '324425' ========================2022-05-06 10:16:48======================== noteurl_start parm_app_code = 046 parm_pc_name = OWNER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C6F659EE5C770DDD279 sCDKey = 361074279643 sName = OWNER-PC ========================2022-05-06 10:16: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 = '361074279643' AND r.app_code = '046' AND r.app_block = 0 ========================2022-05-06 10:16:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds7098' ========================2022-05-06 10:16:48======================== SELECT idx FROM macs WHERE mac_addr = '1C6F659EE5C770DDD279' AND app_code = '046' ========================2022-05-06 10:16:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288562' ========================2022-05-06 10:16:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288562' ========================2022-05-06 10:16:48======================== UPDATE mac_detail SET pc_name = 'OWNER-PC', os_type = '90', user_id = 'ds7098', user_name = '덕수상사[곽회출]', screen_w = '1920', screen_h = '1080', cdkey = '361074279643' WHERE mac_idx = '288562' ========================2022-05-06 13:24:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UK0DBGN parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = B482FE3261E8A23CB376 sCDKey = 453015259105 sName = DESKTOP-UK0DBGN ========================2022-05-06 13:24: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 = '453015259105' AND r.app_code = '039' AND r.app_block = 0 ========================2022-05-06 13:24:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'w787654' ========================2022-05-06 13:24:02======================== SELECT idx FROM macs WHERE mac_addr = 'B482FE3261E8A23CB376' AND app_code = '039' ========================2022-05-06 13:24:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '366366' ========================2022-05-06 13:24:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '366366' ========================2022-05-06 13:24: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 ( '366366', 'B482FE3261E8A23CB376', '039', 'DESKTOP-UK0DBGN', '110', '1360', '768', 'w787654', 'W기공소[임상욱]', '453015259105' ) ========================2022-05-06 14:16:49======================== noteurl_start parm_app_code = 048 parm_pc_name = 주차장 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E914BA0E02F63433 sCDKey = 434133617514 sName = 주차장 ========================2022-05-06 14:16:49======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2022-05-06 14:16:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2022-05-06 14:16:49======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E914BA0E02F63433' AND app_code = '048' ========================2022-05-06 14:16:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322140' ========================2022-05-06 14:16:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322140' ========================2022-05-06 14:16:49======================== UPDATE mac_detail SET pc_name = '주차장', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '322140' ========================2022-05-06 14:32:40======================== noteurl_start parm_app_code = 048 parm_pc_name = 2021함안2층출입 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C809A82B872A34AB5220 sCDKey = 434133617514 sName = 2021함안2층출입 ========================2022-05-06 14:32: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2022-05-06 14:32:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2022-05-06 14:32:40======================== SELECT idx FROM macs WHERE mac_addr = 'C809A82B872A34AB5220' AND app_code = '048' ========================2022-05-06 14:32:40======================== 값이 없을 경우 ========================2022-05-06 15:47:10======================== noteurl_start parm_app_code = 048 parm_pc_name = 2021함안2층출입 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E900225034AB5220 sCDKey = 434133617514 sName = 2021함안2층출입 ========================2022-05-06 15:47:10======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2022-05-06 15:47:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2022-05-06 15:47:10======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E900225034AB5220' AND app_code = '048' ========================2022-05-06 15:47:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304024' ========================2022-05-06 15:47:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304024' ========================2022-05-06 15:47:10======================== UPDATE mac_detail SET pc_name = '2021함안2층출입', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '304024' ========================2022-05-06 15:48:13======================== noteurl_start parm_app_code = 051 parm_pc_name = KIMNAMSU-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73A209683B sCDKey = 885396620872 sName = KIMNAMSU-PC ========================2022-05-06 15:48:13======================== 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 = '885396620872' AND r.app_code = '051' AND r.app_block = 0 ========================2022-05-06 15:48:20======================== noteurl_start parm_app_code = 051 parm_pc_name = KIMNAMSU-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73A209683B sCDKey = 885396620872 sName = KIMNAMSU-PC ========================2022-05-06 15:48:20======================== 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 = '885396620872' AND r.app_code = '051' AND r.app_block = 0 ========================2022-05-06 15:48:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kak0936' ========================2022-05-06 15:48:20======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73A209683B' AND app_code = '051' ========================2022-05-06 15:48:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336665' ========================2022-05-06 15:48:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '336665' ========================2022-05-06 15:48:20======================== UPDATE mac_detail SET pc_name = 'KIMNAMSU-PC', os_type = '109', user_id = 'kak0936', user_name = '엠제이소프트11[김남수]', screen_w = '1920', screen_h = '1080', cdkey = '885396620872' WHERE mac_idx = '336665' ========================2022-05-06 16:34:00======================== noteurl_start parm_app_code = 051 parm_pc_name = KIMNAMSU-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 885396620872 sName = KIMNAMSU-PC ========================2022-05-06 16:34:00======================== 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 = '885396620872' AND r.app_code = '051' AND r.app_block = 0 ========================2022-05-06 16:34:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kak0936' ========================2022-05-06 16:34:00======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73F08A9CF6' AND app_code = '051' ========================2022-05-06 16:34:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '214233' ========================2022-05-06 16:34:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '214233' ========================2022-05-06 16:34:00======================== UPDATE mac_detail SET pc_name = 'KIMNAMSU-PC', os_type = '109', user_id = 'kak0936', user_name = '엠제이소프트11[김남수]', screen_w = '1920', screen_h = '1080', cdkey = '885396620872' WHERE mac_idx = '214233' ========================2022-05-06 16:48:59======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BSS1T5D parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 705DCCF6AFEDC26727C5 sCDKey = 859402867910 sName = DESKTOP-BSS1T5D ========================2022-05-06 16:48:59======================== 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 = '859402867910' AND r.app_code = '046' AND r.app_block = 0 ========================2022-05-06 16:48:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daesa' ========================2022-05-06 16:48:59======================== SELECT idx FROM macs WHERE mac_addr = '705DCCF6AFEDC26727C5' AND app_code = '046' ========================2022-05-06 16:48:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '366379' ========================2022-05-06 16:48:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '366379' ========================2022-05-06 16:48:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '366379', '705DCCF6AFEDC26727C5', '046', 'DESKTOP-BSS1T5D', '110', '1920', '1080', 'daesa', '지선상사[정해경]', '859402867910' ) ========================2022-05-06 17:35:02======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D85ED3A43C6A1E1D2260 sCDKey = 361074279643 sName = POS-MAIN ========================2022-05-06 17:35: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 = '361074279643' AND r.app_code = '046' AND r.app_block = 0 ========================2022-05-06 17:35:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds7098' ========================2022-05-06 17:35:02======================== SELECT idx FROM macs WHERE mac_addr = 'D85ED3A43C6A1E1D2260' AND app_code = '046' ========================2022-05-06 17:35:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '366382' ========================2022-05-06 17:35:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '366382' ========================2022-05-06 17:35: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 ( '366382', 'D85ED3A43C6A1E1D2260', '046', 'POS-MAIN', '110', '1920', '1080', 'ds7098', '덕수상사[곽회출]', '361074279643' ) ========================2022-05-06 17:35:07======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D85ED3A43C6A1E1D2260 sCDKey = 361074279643 sName = POS-MAIN ========================2022-05-06 17:35:07======================== 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 = '361074279643' AND r.app_code = '046' AND r.app_block = 0 ========================2022-05-06 17:35:42======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D85ED3A43C6A1E1D2260 sCDKey = 361074279643 sName = POS-MAIN ========================2022-05-06 17:35:42======================== 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 = '361074279643' AND r.app_code = '046' AND r.app_block = 0 ========================2022-05-06 17:35:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds7098' ========================2022-05-06 17:35:42======================== SELECT idx FROM macs WHERE mac_addr = 'D85ED3A43C6A1E1D2260' AND app_code = '046' ========================2022-05-06 17:35:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '366382' ========================2022-05-06 17:35:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '366382' ========================2022-05-06 17:35:42======================== UPDATE mac_detail SET pc_name = 'POS-MAIN', os_type = '110', user_id = 'ds7098', user_name = '덕수상사[곽회출]', screen_w = '1920', screen_h = '1080', cdkey = '361074279643' WHERE mac_idx = '366382' ========================2022-05-06 21:24:18======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8I0SJKE parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 4CCC6AD47A4A6E4392E7 sCDKey = 278126570271 sName = 임시임시 ========================2022-05-06 21:24: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-05-06 21:24:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-05-06 21:24:18======================== SELECT idx FROM macs WHERE mac_addr = '4CCC6AD47A4A6E4392E7' AND app_code = '047' ========================2022-05-06 21:24:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359370' ========================2022-05-06 21:24:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359370' ========================2022-05-06 21:24:18======================== UPDATE mac_detail SET pc_name = '임시임시', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '359370'