========================2022-08-31 06:45:37======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PP96E8B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D45D642687A3C0071E37 sCDKey = 278126570271 sName = DESKTOP-PP96E8B ========================2022-08-31 06:45: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 06:45:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-08-31 06:45:37======================== SELECT idx FROM macs WHERE mac_addr = 'D45D642687A3C0071E37' AND app_code = '047' ========================2022-08-31 06:45:37======================== 값이 없을 경우 ========================2022-08-31 06:46:42======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PP96E8B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D45D642687A3C0071E37 sCDKey = 278126570271 sName = DESKTOP-PP96E8B ========================2022-08-31 06:46: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 06:46:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-08-31 06:46:42======================== SELECT idx FROM macs WHERE mac_addr = 'D45D642687A3C0071E37' AND app_code = '047' ========================2022-08-31 06:46:42======================== 값이 없을 경우 ========================2022-08-31 06:46:45======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PP96E8B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D45D642687A3C0071E37 sCDKey = 278126570271 sName = DESKTOP-PP96E8B ========================2022-08-31 06:46:45======================== 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-08-31 06:46:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-08-31 06:46:45======================== SELECT idx FROM macs WHERE mac_addr = 'D45D642687A3C0071E37' AND app_code = '047' ========================2022-08-31 06:46:45======================== 값이 없을 경우 ========================2022-08-31 06:51:21======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-RCHSPGR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FC34979E54CF10263735 sCDKey = 278126570271 sName = DESKTOP-RCHSPGR ========================2022-08-31 06:51: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 06:51:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-08-31 06:51:21======================== SELECT idx FROM macs WHERE mac_addr = 'FC34979E54CF10263735' AND app_code = '047' ========================2022-08-31 06:51:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372780' ========================2022-08-31 06:51:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372780' ========================2022-08-31 06:51:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372780', 'FC34979E54CF10263735', '047', 'DESKTOP-RCHSPGR', '�쐢�룄�슦 10', '0', '0', 'hmh563', '동광종합물산[한민희]', '278126570271' ) ========================2022-08-31 07:07:36======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PP96E8B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D45D642687A3C0071E37 sCDKey = 278126570271 sName = DESKTOP-PP96E8B ========================2022-08-31 07:07: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 07:07:38======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PP96E8B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D45D642687A3C0071E37 sCDKey = 278126570271 sName = DESKTOP-PP96E8B ========================2022-08-31 07:07: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 07:07:41======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PP96E8B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D45D642687A3C0071E37 sCDKey = 278126570271 sName = DESKTOP-PP96E8B ========================2022-08-31 07:07: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 07:18:28======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-8NHG7QE parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E9944FBFF2DE67F8 sCDKey = 434133617514 sName = DESKTOP-8NHG7QE ========================2022-08-31 07:18: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2022-08-31 07:18:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2022-08-31 07:18:28======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9944FBFF2DE67F8' AND app_code = '048' ========================2022-08-31 07:18:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '364338' ========================2022-08-31 07:18:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '364338' ========================2022-08-31 07:18:28======================== UPDATE mac_detail SET pc_name = 'DESKTOP-8NHG7QE', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '364338' ========================2022-08-31 08:50:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DI-PC1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C7B2023FE360B27 sCDKey = 978266053238 sName = DI-PC1 ========================2022-08-31 08:50: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 = '978266053238' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 09:11:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DI-PC1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C7B2023FE360B27 sCDKey = 978266053238 sName = DI-PC1 ========================2022-08-31 09:11: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 = '978266053238' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 09:11:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daeil4' ========================2022-08-31 09:11:50======================== SELECT idx FROM macs WHERE mac_addr = '408D5C7B2023FE360B27' AND app_code = '039' ========================2022-08-31 09:11:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372788' ========================2022-08-31 09:11:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372788' ========================2022-08-31 09:11:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372788', '408D5C7B2023FE360B27', '039', 'DI-PC1', '110', '1920', '1080', 'daeil4', '대일사[김광일]', '978266053238' ) ========================2022-08-31 09:12:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DI-PC1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C7B2023FE360B27 sCDKey = 978266053238 sName = DI-PC1 ========================2022-08-31 09:12: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 = '978266053238' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 09:23:05======================== noteurl_start parm_app_code = 039 parm_pc_name = WOOSUNG3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99E6F9D936244D07 sCDKey = 926397806972 sName = WOOSUNG3 ========================2022-08-31 09:23:05======================== 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 = '926397806972' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 09:23:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kiml20' ========================2022-08-31 09:23:05======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99E6F9D936244D07' AND app_code = '039' ========================2022-08-31 09:23:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372785' ========================2022-08-31 09:23:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372785' ========================2022-08-31 09:23:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372785', 'B42E99E6F9D936244D07', '039', 'WOOSUNG3', '110', '1920', '1080', 'kiml20', '우성금속[김정섭]', '926397806972' ) ========================2022-08-31 09:36:14======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PP96E8B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D45D642687A3C0071E37 sCDKey = 278126570271 sName = 콜센터3번 ========================2022-08-31 09:36: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 09:36:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-08-31 09:36:14======================== SELECT idx FROM macs WHERE mac_addr = 'D45D642687A3C0071E37' AND app_code = '047' ========================2022-08-31 09:36:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372782' ========================2022-08-31 09:36:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372782' ========================2022-08-31 09:36: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 ( '372782', 'D45D642687A3C0071E37', '047', '콜센터3번', '�쐢�룄�슦 10', '0', '0', 'hmh563', '동광종합물산[한민희]', '278126570271' ) ========================2022-08-31 09:39:38======================== noteurl_start parm_app_code = 047 parm_pc_name = BST-POS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 68EDA43A7055A0DA1136 sCDKey = 131563965794 sName = BST-POS ========================2022-08-31 09:39: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 = '131563965794' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 09:44:29======================== noteurl_start parm_app_code = 046 parm_pc_name = BST-POS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA43A7055A0DA1136 sCDKey = 131563965794 sName = BST-POS ========================2022-08-31 09:44:29======================== 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 = '131563965794' AND r.app_code = '046' AND r.app_block = 0 ========================2022-08-31 09:44:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'astros729' ========================2022-08-31 09:44:29======================== SELECT idx FROM macs WHERE mac_addr = '68EDA43A7055A0DA1136' AND app_code = '046' ========================2022-08-31 09:44:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '345691' ========================2022-08-31 09:44:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '345691' ========================2022-08-31 09:44:29======================== UPDATE mac_detail SET pc_name = 'BST-POS', os_type = '110', user_id = 'astros729', user_name = '단지유통[박인수]', screen_w = '1024', screen_h = '768', cdkey = '131563965794' WHERE mac_idx = '345691' ========================2022-08-31 09:59:24======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-EOEFT0D parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 3C7C3F13ED280A5B8398 sCDKey = 380824684722 sName = DESKTOP-EOEFT0D ========================2022-08-31 09:59: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 = '380824684722' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 09:59:57======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-EOEFT0D parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 3C7C3F13ED280A5B8398 sCDKey = 380824684722 sName = DESKTOP-EOEFT0D ========================2022-08-31 09:59: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 = '380824684722' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 10:12:49======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-EOEFT0D parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 3C7C3F13ED280A5B8398 sCDKey = 380824684722 sName = DESKTOP-EOEFT0D ========================2022-08-31 10:12: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 = '380824684722' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 10:12:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'naacoop1' ========================2022-08-31 10:12:49======================== SELECT idx FROM macs WHERE mac_addr = '3C7C3F13ED280A5B8398' AND app_code = '047' ========================2022-08-31 10:12:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372716' ========================2022-08-31 10:12:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372716' ========================2022-08-31 10:12:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372716', '3C7C3F13ED280A5B8398', '047', 'DESKTOP-EOEFT0D', '�쐢�룄�슦 10', '0', '0', 'naacoop1', '나아협동조합[김승환]', '380824684722' ) ========================2022-08-31 10:39:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6RIQ9I6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D48760B34F528EF sCDKey = 329041319400 sName = DESKTOP-6RIQ9I6 ========================2022-08-31 10:39: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 = '329041319400' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 10:39:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lsg1686' ========================2022-08-31 10:39:41======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D48760B34F528EF' AND app_code = '039' ========================2022-08-31 10:39:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334558' ========================2022-08-31 10:39:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334558' ========================2022-08-31 10:39:41======================== UPDATE mac_detail SET pc_name = 'DESKTOP-6RIQ9I6', os_type = '110', user_id = 'lsg1686', user_name = '성신인쇄사[이승규]', screen_w = '1920', screen_h = '1080', cdkey = '329041319400' WHERE mac_idx = '334558' ========================2022-08-31 10:54:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FRHI59B parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99C9CF21220617E4 sCDKey = 583230978058 sName = DESKTOP-FRHI59B ========================2022-08-31 10: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 = '583230978058' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 10:54:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjs4040' ========================2022-08-31 10:54:40======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C9CF21220617E4' AND app_code = '039' ========================2022-08-31 10:54:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372831' ========================2022-08-31 10:54:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372831' ========================2022-08-31 10: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 ( '372831', 'B42E99C9CF21220617E4', '039', 'DESKTOP-FRHI59B', '110', '1920', '1080', 'cjs4040', '제일수출포장[최진식]', '583230978058' ) ========================2022-08-31 11:11:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HLF4ATU parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 5811220B81DA9429EC3C sCDKey = 682793846707 sName = DESKTOP-HLF4ATU ========================2022-08-31 11:11:30======================== 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 = '682793846707' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 11:11:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pariboys' ========================2022-08-31 11:11:30======================== SELECT idx FROM macs WHERE mac_addr = '5811220B81DA9429EC3C' AND app_code = '039' ========================2022-08-31 11:11:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '370311' ========================2022-08-31 11:11:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '370311' ========================2022-08-31 11:11:30======================== UPDATE mac_detail SET pc_name = 'DESKTOP-HLF4ATU', os_type = '110', user_id = 'pariboys', user_name = '현대상사[최규준]', screen_w = '2560', screen_h = '1440', cdkey = '682793846707' WHERE mac_idx = '370311' ========================2022-08-31 11:21:20======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-RCHSPGR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FC34979E54CF10263735 sCDKey = 278126570271 sName = DESKTOP-RCHSPGR ========================2022-08-31 11:21: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 11:21:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-08-31 11:21:20======================== SELECT idx FROM macs WHERE mac_addr = 'FC34979E54CF10263735' AND app_code = '047' ========================2022-08-31 11:21:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372780' ========================2022-08-31 11:21:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372780' ========================2022-08-31 11:21:20======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RCHSPGR', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '372780' ========================2022-08-31 11:21:24======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-OPSIRN4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E79AB34175B3D45 sCDKey = 847210892454 sName = DESKTOP-OPSIRN4 ========================2022-08-31 11:21: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 = '847210892454' AND r.app_code = '046' AND r.app_block = 0 ========================2022-08-31 11:22:32======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-OPSIRN4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E79AB34175B3D45 sCDKey = 847210892454 sName = DESKTOP-OPSIRN4 ========================2022-08-31 11:22:32======================== 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 = '847210892454' AND r.app_code = '046' AND r.app_block = 0 ========================2022-08-31 11:22:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'anwnwpdlf322' ========================2022-08-31 11:22:32======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E79AB34175B3D45' AND app_code = '046' ========================2022-08-31 11:22:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372834' ========================2022-08-31 11:22:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372834' ========================2022-08-31 11:22:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372834', 'E0D55E79AB34175B3D45', '046', 'DESKTOP-OPSIRN4', '110', '1920', '1080', 'anwnwpdlf322', '무주제일건재[이승훈]', '847210892454' ) ========================2022-08-31 12:39:08======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-A8UGJPD parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00051B904D39C63FA195 sCDKey = 639449125243 sName = DESKTOP-A8UGJPD ========================2022-08-31 12:39: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 = '639449125243' AND r.app_code = '050' AND r.app_block = 0 ========================2022-08-31 12:39:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sfasemicon' ========================2022-08-31 12:39:08======================== SELECT idx FROM macs WHERE mac_addr = '00051B904D39C63FA195' AND app_code = '050' ========================2022-08-31 12:39:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372683' ========================2022-08-31 12:39:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372683' ========================2022-08-31 12:39:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372683', '00051B904D39C63FA195', '050', 'DESKTOP-A8UGJPD', '109', '1920', '1080', 'sfasemicon', '(주)에스에프에이반도체[김성민]', '639449125243' ) ========================2022-08-31 13:21:45======================== noteurl_start parm_app_code = 050 parm_pc_name = LAPTOP-LUO5IQDQ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E04C682F368C3E6D2C sCDKey = 452775506015 sName = LAPTOP-LUO5IQDQ ========================2022-08-31 13:21:45======================== 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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2022-08-31 13:21:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ecstel' ========================2022-08-31 13:21:45======================== SELECT idx FROM macs WHERE mac_addr = '00E04C682F368C3E6D2C' AND app_code = '050' ========================2022-08-31 13:21:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372840' ========================2022-08-31 13:21:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372840' ========================2022-08-31 13:21:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372840', '00E04C682F368C3E6D2C', '050', 'LAPTOP-LUO5IQDQ', '109', '1920', '1080', 'ecstel', '(주)이씨에스텔레콤[유지해]', '452775506015' ) ========================2022-08-31 13:30:37======================== noteurl_start parm_app_code = 047 parm_pc_name = K-PC-1 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00301852A74DAE3CF573 sCDKey = 035781315441 sName = K-PC-1 ========================2022-08-31 13:30: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 = '035781315441' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 13:30:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'min1001pnc' ========================2022-08-31 13:30:37======================== SELECT idx FROM macs WHERE mac_addr = '00301852A74DAE3CF573' AND app_code = '047' ========================2022-08-31 13:30:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372852' ========================2022-08-31 13:30:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372852' ========================2022-08-31 13:30: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 ( '372852', '00301852A74DAE3CF573', '047', 'K-PC-1', '�쐢�룄�슦 7', '0', '0', 'min1001pnc', '천일피앤씨[민지홍]', '035781315441' ) ========================2022-08-31 16:00:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-PQPD029 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 3E91F1476B4F605D0FE5 sCDKey = 001409448751 sName = DESKTOP-PQPD029 ========================2022-08-31 16:00: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 = '001409448751' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 16:00:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sam9140701' ========================2022-08-31 16:00:21======================== SELECT idx FROM macs WHERE mac_addr = '3E91F1476B4F605D0FE5' AND app_code = '039' ========================2022-08-31 16:00:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372882' ========================2022-08-31 16:00:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372882' ========================2022-08-31 16:00:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372882', '3E91F1476B4F605D0FE5', '039', 'DESKTOP-PQPD029', '110', '1536', '864', 'sam9140701', '한국유통[권상구]', '001409448751' ) ========================2022-08-31 16:09:26======================== noteurl_start parm_app_code = 050 parm_pc_name = KHLEE parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C018508463C226B4F482 sCDKey = 708128512512 sName = KHLEE ========================2022-08-31 16:09: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2022-08-31 16:09:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2022-08-31 16:09:26======================== SELECT idx FROM macs WHERE mac_addr = 'C018508463C226B4F482' AND app_code = '050' ========================2022-08-31 16:09:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372884' ========================2022-08-31 16:09:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372884' ========================2022-08-31 16:09: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 ( '372884', 'C018508463C226B4F482', '050', 'KHLEE', '109', '1536', '864', 'jinsung2', '(주)진성이엔지[나인석]', '708128512512' ) ========================2022-08-31 16:51:02======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-N3B77P0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D579192760354 sCDKey = 278126570271 sName = 포스2번 ========================2022-08-31 16:51: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-08-31 16:51:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-08-31 16:51:02======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D579192760354' AND app_code = '047' ========================2022-08-31 16:51:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359662' ========================2022-08-31 16:51:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359662' ========================2022-08-31 16:51:02======================== UPDATE mac_detail SET pc_name = '포스2번', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '359662' ========================2022-08-31 17:29:58======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-48KBQE8K parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 768 parm_user_mac = 38FC986210156E7F28C8 sCDKey = 832055398131 sName = LAPTOP-48KBQE8K ========================2022-08-31 17:29: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 = '832055398131' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 17:29:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuki325' ========================2022-08-31 17:29:58======================== SELECT idx FROM macs WHERE mac_addr = '38FC986210156E7F28C8' AND app_code = '039' ========================2022-08-31 17:29:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372894' ========================2022-08-31 17:29:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372894' ========================2022-08-31 17:29:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372894', '38FC986210156E7F28C8', '039', 'LAPTOP-48KBQE8K', '110', '1280', '768', 'yuki325', '화성건업[이광호]', '832055398131' ) ========================2022-08-31 19:15:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8D97E3J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A159BBDD11543F330E sCDKey = 112645303364 sName = DESKTOP-8D97E3J ========================2022-08-31 19:15:23======================== 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 = '112645303364' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 19:15:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8D97E3J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A159BBDD11543F330E sCDKey = 112645303364 sName = DESKTOP-8D97E3J ========================2022-08-31 19:15: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 = '112645303364' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 19:16:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8D97E3J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A159BBDD11543F330E sCDKey = 112645303364 sName = DESKTOP-8D97E3J ========================2022-08-31 19:16:32======================== 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 = '112645303364' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-31 19:17:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8D97E3J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A159BBDD11543F330E sCDKey = 112645303364 sName = DESKTOP-8D97E3J ========================2022-08-31 19:17:01======================== 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 = '112645303364' AND r.app_code = '039' AND r.app_block = 0