========================2020-07-20 09:20:24======================== noteurl_start parm_app_code = 045 parm_pc_name = WIN-GGP95J9GS5Q parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D43D7EF67E5D705DE530 sCDKey = 244076831899 sName = WIN-GGP95J9GS5Q ========================2020-07-20 09:20: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 = '244076831899' AND r.app_code = '045' AND r.app_block = 0 ========================2020-07-20 09:20:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hohoinja' ========================2020-07-20 09:20:24======================== SELECT idx FROM macs WHERE mac_addr = 'D43D7EF67E5D705DE530' AND app_code = '045' ========================2020-07-20 09:20:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322158' ========================2020-07-20 09:20:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322158' ========================2020-07-20 09:20:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322158', 'D43D7EF67E5D705DE530', '045', 'WIN-GGP95J9GS5Q', '90', '1920', '1080', 'hohoinja', '세명컴퓨터[김동현]', '244076831899' ) ========================2020-07-20 09:25:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-97F3VO3 parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 98838999D441A5440CB sCDKey = 872903449106 sName = DESKTOP-97F3VO3 ========================2020-07-20 09:25:25======================== 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 = '872903449106' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-20 09:25:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nmw11055' ========================2020-07-20 09:25:25======================== SELECT idx FROM macs WHERE mac_addr = '98838999D441A5440CB' AND app_code = '039' ========================2020-07-20 09:25:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313415' ========================2020-07-20 09:25:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313415' ========================2020-07-20 09:25:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313415', '98838999D441A5440CB', '039', 'DESKTOP-97F3VO3', '110', '1360', '768', 'nmw11055', '신한텍스[남만우]', '872903449106' ) ========================2020-07-20 09:49:38======================== noteurl_start parm_app_code = 039 parm_pc_name = COM1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3497F6A2848DDAAD00B2 sCDKey = 798264532872 sName = COM1 ========================2020-07-20 09:49: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 = '798264532872' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-20 09:49:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sangwuk' ========================2020-07-20 09:49:38======================== SELECT idx FROM macs WHERE mac_addr = '3497F6A2848DDAAD00B2' AND app_code = '039' ========================2020-07-20 09:49:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322162' ========================2020-07-20 09:49:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322162' ========================2020-07-20 09:49:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322162', '3497F6A2848DDAAD00B2', '039', 'COM1', '110', '1920', '1080', 'sangwuk', '성일분체[서상욱]', '798264532872' ) ========================2020-07-20 10:09:28======================== noteurl_start parm_app_code = 051 parm_pc_name = SKIN20NB00082 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3822E21FDF45280A2BBE sCDKey = 003401679376 sName = SKIN20NB00082 ========================2020-07-20 10:09: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2020-07-20 10:09:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2020-07-20 10:09:28======================== SELECT idx FROM macs WHERE mac_addr = '3822E21FDF45280A2BBE' AND app_code = '051' ========================2020-07-20 10:09:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319336' ========================2020-07-20 10:09:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319336' ========================2020-07-20 10:09:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319336', '3822E21FDF45280A2BBE', '051', 'SKIN20NB00082', '109', '1920', '1080', 'skinfosec', '인포섹[이대윤]', '003401679376' ) ========================2020-07-20 10:17:41======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-BI01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC73327728DF2 sCDKey = 409643186656 sName = WIN-BI01 ========================2020-07-20 10:17: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 = '409643186656' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-20 10:17:46======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-BI01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC73327728DF2 sCDKey = 409643186656 sName = WIN-BI01 ========================2020-07-20 10:17: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 = '409643186656' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-20 10:18:03======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-BI01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC73327728DF2 sCDKey = 409643186656 sName = WIN-BI01 ========================2020-07-20 10:18:03======================== 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 = '409643186656' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-20 10:20:13======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-BI01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC73327728DF2 sCDKey = 409643186656 sName = WIN-BI01 ========================2020-07-20 10:20: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 = '409643186656' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-20 10:20:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs445' ========================2020-07-20 10:20:13======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AC73327728DF2' AND app_code = '046' ========================2020-07-20 10:20:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '176304' ========================2020-07-20 10:20:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '176304' ========================2020-07-20 10:20:13======================== UPDATE mac_detail SET pc_name = 'WIN-BI01', os_type = '64', user_id = 'bs445', user_name = '부일수산[부산지사]', screen_w = '1024', screen_h = '768', cdkey = '409643186656' WHERE mac_idx = '176304' ========================2020-07-20 10:22:17======================== noteurl_start parm_app_code = 046 parm_pc_name = ANNA parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 755061866111 sName = ANNA ========================2020-07-20 10:22:17======================== 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 = '755061866111' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-20 10:22:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyein1127' ========================2020-07-20 10:22:17======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '046' ========================2020-07-20 10:22:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250690' ========================2020-07-20 10:22:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250690' ========================2020-07-20 10:22:17======================== UPDATE mac_detail SET pc_name = 'ANNA', os_type = '110', user_id = 'hyein1127', user_name = '[황혜인]', screen_w = '1920', screen_h = '1080', cdkey = '755061866111' WHERE mac_idx = '250690' ========================2020-07-20 11:01:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-K9J5B93 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80F957E25CD123B8 sCDKey = 753494539793 sName = DESKTOP-K9J5B93 ========================2020-07-20 11:01: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 = '753494539793' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-20 11:01:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wonproto' ========================2020-07-20 11:01:32======================== SELECT idx FROM macs WHERE mac_addr = '94DE80F957E25CD123B8' AND app_code = '039' ========================2020-07-20 11:01:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322108' ========================2020-07-20 11:01:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322108' ========================2020-07-20 11:01: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 ( '322108', '94DE80F957E25CD123B8', '039', 'DESKTOP-K9J5B93', '110', '1920', '1080', 'wonproto', '원프로토[이응호]', '753494539793' ) ========================2020-07-20 11:01:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-K9J5B93 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80F957E25CD123B8 sCDKey = 753494539793 sName = DESKTOP-K9J5B93 ========================2020-07-20 11:01:54======================== 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 = '753494539793' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-20 13:09:27======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EFREHQA parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = D05099028CE8F07E15BF sCDKey = 924530203570 sName = EFREHQA ========================2020-07-20 13:09:27======================== 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 = '924530203570' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-20 13:09:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EFREHQA parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = D05099028CE8F07E15BF sCDKey = 924530203570 sName = EFREHQA ========================2020-07-20 13:09: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 = '924530203570' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-20 13:09:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bukwang2272' ========================2020-07-20 13:09:40======================== SELECT idx FROM macs WHERE mac_addr = 'D05099028CE8F07E15BF' AND app_code = '039' ========================2020-07-20 13:09:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322208' ========================2020-07-20 13:09:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322208' ========================2020-07-20 13:09: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 ( '322208', 'D05099028CE8F07E15BF', '039', 'EFREHQA', '110', '1360', '768', 'bukwang2272', '부광포장[박효정]', '924530203570' ) ========================2020-07-20 13:58:39======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3ADE8D6D7A84FC0 sCDKey = 076965795036 sName = SAMSUNG-PC ========================2020-07-20 13:58: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 = '076965795036' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-20 13:58:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'leesgym' ========================2020-07-20 13:58:40======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3ADE8D6D7A84FC0' AND app_code = '039' ========================2020-07-20 13:58:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322214' ========================2020-07-20 13:58:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322214' ========================2020-07-20 13:58: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 ( '322214', '50B7C3ADE8D6D7A84FC0', '039', 'SAMSUNG-PC', '90', '1920', '1080', 'leesgym', '명지인더스트리[이한규]', '076965795036' ) ========================2020-07-20 14:40:27======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E839DFAC0B0D28EAE371 sCDKey = 152474805527 sName = USER-PC ========================2020-07-20 14:40:27======================== 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 = '152474805527' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-20 14:40:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jsu111' ========================2020-07-20 14:40:27======================== SELECT idx FROM macs WHERE mac_addr = 'E839DFAC0B0D28EAE371' AND app_code = '039' ========================2020-07-20 14:40:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319238' ========================2020-07-20 14:40:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319238' ========================2020-07-20 14:40:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319238', 'E839DFAC0B0D28EAE371', '039', 'USER-PC', '90', '1366', '768', 'jsu111', '실버그린[주성열]', '152474805527' ) ========================2020-07-20 17:36:01======================== noteurl_start parm_app_code = 047 parm_pc_name = HOME parm_os_type = �쐢�룄�슦 8 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C8F733A0A2B7707E6B63 sCDKey = 767095042850 sName = HOME ========================2020-07-20 17:36: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 = '767095042850' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-20 17:36:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'emekorea' ========================2020-07-20 17:36:01======================== SELECT idx FROM macs WHERE mac_addr = 'C8F733A0A2B7707E6B63' AND app_code = '047' ========================2020-07-20 17:36:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322259' ========================2020-07-20 17:36:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322259' ========================2020-07-20 17:36:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322259', 'C8F733A0A2B7707E6B63', '047', 'HOME', '�쐢�룄�슦 8', '0', '0', 'emekorea', '이엠이코리아[김덕인]', '767095042850' )