========================2018-06-22 10:36:03======================== noteurl_start parm_app_code = 047 parm_pc_name = CHANGIL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D3000A4EED031CA00 sCDKey = 506344942986 sName = CHANGIL ========================2018-06-22 10:36: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 = '506344942986' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-22 10:41:49======================== noteurl_start parm_app_code = 047 parm_pc_name = CHANGIL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D3000A4EED031CA00 sCDKey = 506344942986 sName = CHANGIL ========================2018-06-22 10:41: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 = '506344942986' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-22 10:45:50======================== noteurl_start parm_app_code = 047 parm_pc_name = CHANGIL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D3000A4EED031CA00 sCDKey = 506344942986 sName = CHANGIL ========================2018-06-22 10:45: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 = '506344942986' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-22 10:46:26======================== noteurl_start parm_app_code = 047 parm_pc_name = CHANGIL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D3000A4EED031CA00 sCDKey = 506444942986 sName = CHANGIL ========================2018-06-22 10:46: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 = '506444942986' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-22 10:46:31======================== noteurl_start parm_app_code = 047 parm_pc_name = CHANGIL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D3000A4EED031CA00 sCDKey = 506344942986 sName = CHANGIL ========================2018-06-22 10:46:31======================== 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 = '506344942986' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-22 10:53:43======================== noteurl_start parm_app_code = 047 parm_pc_name = CHANGIL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D3000A4EED031CA00 sCDKey = 506344942986 sName = CHANGIL ========================2018-06-22 10:53:43======================== 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 = '506344942986' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-22 10:54:10======================== noteurl_start parm_app_code = 047 parm_pc_name = CHANGIL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D3000A4EED031CA00 sCDKey = 473775145285 sName = CHANGIL ========================2018-06-22 10:54: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 = '473775145285' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-22 10:54:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ci2016' ========================2018-06-22 10:54:10======================== SELECT idx FROM macs WHERE mac_addr = 'F44D3000A4EED031CA00' AND app_code = '047' ========================2018-06-22 10:54:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252604' ========================2018-06-22 10:54:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252604' ========================2018-06-22 10:54:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252604', 'F44D3000A4EED031CA00', '047', 'CHANGIL', '�쐢�룄�슦 10', '0', '0', 'ci2016', '창일종합상사[허성욱]', '473775145285' ) ========================2018-06-22 11:48:49======================== noteurl_start parm_app_code = 048 parm_pc_name = MIJIN_JUNPYO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 3497F693221638540FC2 sCDKey = 493095055925 sName = MIJIN_JUNPYO ========================2018-06-22 11:48: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 = '493095055925' AND r.app_code = '048' AND r.app_block = 0 ========================2018-06-22 11:48:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'novasix' ========================2018-06-22 11:48:49======================== SELECT idx FROM macs WHERE mac_addr = '3497F693221638540FC2' AND app_code = '048' ========================2018-06-22 11:48:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252602' ========================2018-06-22 11:48:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252602' ========================2018-06-22 11:48: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 ( '252602', '3497F693221638540FC2', '048', 'MIJIN_JUNPYO', '�쐢�룄�슦 10', '0', '0', 'novasix', 'MJ소프트[여욱동]', '493095055925' ) ========================2018-06-22 13:56:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2BG1UR7 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 2A4120524153203BB51B sCDKey = 753290361069 sName = 메인pc ========================2018-06-22 13:56: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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 13:56:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 13:56:29======================== SELECT idx FROM macs WHERE mac_addr = '2A4120524153203BB51B' AND app_code = '039' ========================2018-06-22 13:56:29======================== 값이 없을 경우 ========================2018-06-22 14:00:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2BG1UR7 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 2A4120524153203BB51B sCDKey = 753290361069 sName = DESKTOP-2BG1UR7 ========================2018-06-22 14:00:06======================== 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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:00:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 14:00:06======================== SELECT idx FROM macs WHERE mac_addr = '2A4120524153203BB51B' AND app_code = '039' ========================2018-06-22 14:00:06======================== 값이 없을 경우 ========================2018-06-22 14:00:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-AU0NRCM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 5AF220524153D812F52A sCDKey = 753290361069 sName = DESKTOP-AU0NRCM ========================2018-06-22 14:00:51======================== 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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:00:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 14:00:51======================== SELECT idx FROM macs WHERE mac_addr = '5AF220524153D812F52A' AND app_code = '039' ========================2018-06-22 14:00:51======================== 값이 없을 경우 ========================2018-06-22 14:01:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2BG1UR7 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 2A4120524153203BB51B sCDKey = 753290361069 sName = DESKTOP-2BG1UR7 ========================2018-06-22 14:01: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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:01:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 14:01:48======================== SELECT idx FROM macs WHERE mac_addr = '2A4120524153203BB51B' AND app_code = '039' ========================2018-06-22 14:01:48======================== 값이 없을 경우 ========================2018-06-22 14:04:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2BG1UR7 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 2A4120524153203BB51B sCDKey = 753290361069 sName = DESKTOP-2BG1UR7 ========================2018-06-22 14:04:35======================== 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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:04:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 14:04:35======================== SELECT idx FROM macs WHERE mac_addr = '2A4120524153203BB51B' AND app_code = '039' ========================2018-06-22 14:04:35======================== 값이 없을 경우 ========================2018-06-22 14:08:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-AU0NRCM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F60920524153D812F52A sCDKey = 753290361069 sName = DESKTOP-AU0NRCM ========================2018-06-22 14:08: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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:08:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 14:08:29======================== SELECT idx FROM macs WHERE mac_addr = 'F60920524153D812F52A' AND app_code = '039' ========================2018-06-22 14:08:29======================== 값이 없을 경우 ========================2018-06-22 14:10:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2BG1UR7 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = EC5920524153203BB51B sCDKey = 753290361069 sName = DESKTOP-2BG1UR7 ========================2018-06-22 14:10: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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:10:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 14:10:46======================== SELECT idx FROM macs WHERE mac_addr = 'EC5920524153203BB51B' AND app_code = '039' ========================2018-06-22 14:10:46======================== 값이 없을 경우 ========================2018-06-22 14:11:59======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 868420524153345CC662 sCDKey = 389572720374 sName = 11 ========================2018-06-22 14:11: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 = '389572720374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:11:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vizz' ========================2018-06-22 14:11:59======================== SELECT idx FROM macs WHERE mac_addr = '868420524153345CC662' AND app_code = '039' ========================2018-06-22 14:11:59======================== 값이 없을 경우 ========================2018-06-22 14:12:36======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 868420524153345CC662 sCDKey = 389572720374 sName = 3241234 ========================2018-06-22 14:12: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 = '389572720374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:12:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vizz' ========================2018-06-22 14:12:36======================== SELECT idx FROM macs WHERE mac_addr = '868420524153345CC662' AND app_code = '039' ========================2018-06-22 14:12:36======================== 값이 없을 경우 ========================2018-06-22 14:12:40======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 868420524153345CC662 sCDKey = 389572720374 sName = 3241234 ========================2018-06-22 14:12: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 = '389572720374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:12:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vizz' ========================2018-06-22 14:12:40======================== SELECT idx FROM macs WHERE mac_addr = '868420524153345CC662' AND app_code = '039' ========================2018-06-22 14:12:40======================== 값이 없을 경우 ========================2018-06-22 14:16:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-AU0NRCM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C275A20AD812F52A sCDKey = 753290361069 sName = DESKTOP-AU0NRCM ========================2018-06-22 14:16: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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:16:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 14:16:42======================== SELECT idx FROM macs WHERE mac_addr = '7085C275A20AD812F52A' AND app_code = '039' ========================2018-06-22 14:16:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252630' ========================2018-06-22 14:16:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252630' ========================2018-06-22 14:16:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252630', '7085C275A20AD812F52A', '039', 'DESKTOP-AU0NRCM', '110', '1920', '1080', 'gras1718', '제이제이유통[정길호]', '753290361069' ) ========================2018-06-22 14:17:54======================== noteurl_start parm_app_code = 039 parm_pc_name = 김창원 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E63920524153A5DC0D8 sCDKey = 657168061937 sName = 김창원 ========================2018-06-22 14:17: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 = '657168061937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:17:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klmm12' ========================2018-06-22 14:17:54======================== SELECT idx FROM macs WHERE mac_addr = 'E63920524153A5DC0D8' AND app_code = '039' ========================2018-06-22 14:17:54======================== 값이 없을 경우 ========================2018-06-22 14:18:14======================== noteurl_start parm_app_code = 039 parm_pc_name = 김창원 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E63920524153A5DC0D8 sCDKey = 657168061937 sName = 김창원 ========================2018-06-22 14:18: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 = '657168061937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:18:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klmm12' ========================2018-06-22 14:18:14======================== SELECT idx FROM macs WHERE mac_addr = 'E63920524153A5DC0D8' AND app_code = '039' ========================2018-06-22 14:18:14======================== 값이 없을 경우 ========================2018-06-22 14:19:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2BG1UR7 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = D050999DFC6C203BB51B sCDKey = 753290361069 sName = DESKTOP-2BG1UR7 ========================2018-06-22 14:19: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 = '753290361069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:19:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gras1718' ========================2018-06-22 14:19:01======================== SELECT idx FROM macs WHERE mac_addr = 'D050999DFC6C203BB51B' AND app_code = '039' ========================2018-06-22 14:19:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252629' ========================2018-06-22 14:19:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252629' ========================2018-06-22 14:19: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 ( '252629', 'D050999DFC6C203BB51B', '039', 'DESKTOP-2BG1UR7', '110', '2560', '1440', 'gras1718', '제이제이유통[정길호]', '753290361069' ) ========================2018-06-22 14:20:21======================== noteurl_start parm_app_code = 039 parm_pc_name = 김창원 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB3E06A5DC0D8 sCDKey = 657168061937 sName = 김창원 ========================2018-06-22 14:20: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 = '657168061937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:20:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klmm12' ========================2018-06-22 14:20:21======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E06A5DC0D8' AND app_code = '039' ========================2018-06-22 14:20:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223020' ========================2018-06-22 14:20:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223020' ========================2018-06-22 14:20:21======================== UPDATE mac_detail SET pc_name = '김창원', os_type = '110', user_id = 'klmm12', user_name = '엠제이소프트[김창원]', screen_w = '1920', screen_h = '1080', cdkey = '657168061937' WHERE mac_idx = '223020' ========================2018-06-22 14:27:54======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL5CG750649D parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = D4258B944A492C617E06 sCDKey = 851095746023 sName = SEOWL17H1518 ========================2018-06-22 14:27: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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2018-06-22 14:27:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ik549892' ========================2018-06-22 14:27:54======================== SELECT idx FROM macs WHERE mac_addr = 'D4258B944A492C617E06' AND app_code = '051' ========================2018-06-22 14:27:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243612' ========================2018-06-22 14:27:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243612' ========================2018-06-22 14:27:54======================== UPDATE mac_detail SET pc_name = 'SEOWL17H1518', os_type = '109', user_id = 'ik549892', user_name = '지에스케이(GSK)[김인배]', screen_w = '1366', screen_h = '768', cdkey = '851095746023' WHERE mac_idx = '243612' ========================2018-06-22 14:47:08======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F045205241536033E3EA sCDKey = 852815921316 sName = AHN-PC ========================2018-06-22 14:47: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:47:29======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F045205241536033E3EA sCDKey = 852815921316 sName = AHN-PC ========================2018-06-22 14:47: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:47:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 14:47:29======================== SELECT idx FROM macs WHERE mac_addr = 'F045205241536033E3EA' AND app_code = '039' ========================2018-06-22 14:47:29======================== 값이 없을 경우 ========================2018-06-22 14:47:51======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F045205241536033E3EA sCDKey = 852815921316 sName = AHN-PC ========================2018-06-22 14:47:51======================== 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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:47:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 14:47:51======================== SELECT idx FROM macs WHERE mac_addr = 'F045205241536033E3EA' AND app_code = '039' ========================2018-06-22 14:47:51======================== 값이 없을 경우 ========================2018-06-22 14:49:54======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F045205241536033E3EA sCDKey = 852815921316 sName = AHN-PC ========================2018-06-22 14:49: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:50:08======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F045205241536033E3EA sCDKey = 852815921316 sName = AHN-PC ========================2018-06-22 14:50: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:50:14======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F045205241536033E3EA sCDKey = 852815921316 sName = AHN-PC ========================2018-06-22 14:50: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:50:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 14:50:14======================== SELECT idx FROM macs WHERE mac_addr = 'F045205241536033E3EA' AND app_code = '039' ========================2018-06-22 14:50:14======================== 값이 없을 경우 ========================2018-06-22 14:50:28======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F045205241536033E3EA sCDKey = 852815921316 sName = AHN-PC ========================2018-06-22 14:50: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:50:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 14:50:28======================== SELECT idx FROM macs WHERE mac_addr = 'F045205241536033E3EA' AND app_code = '039' ========================2018-06-22 14:50:28======================== 값이 없을 경우 ========================2018-06-22 14:50:53======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F045205241536033E3EA sCDKey = 852815921316 sName = AHN-PC ========================2018-06-22 14:50: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:50:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 14:50:53======================== SELECT idx FROM macs WHERE mac_addr = 'F045205241536033E3EA' AND app_code = '039' ========================2018-06-22 14:50:53======================== 값이 없을 경우 ========================2018-06-22 14:52:43======================== noteurl_start parm_app_code = 039 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 33506F453030280D8FDA sCDKey = 852815921316 sName = VB ========================2018-06-22 14:52:43======================== 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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:52:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 14:52:43======================== SELECT idx FROM macs WHERE mac_addr = '33506F453030280D8FDA' AND app_code = '039' ========================2018-06-22 14:52:43======================== 값이 없을 경우 ========================2018-06-22 14:57:13======================== noteurl_start parm_app_code = 039 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 33506F453030280D8FDA sCDKey = 852815921316 sName = VB ========================2018-06-22 14:57: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:57:21======================== noteurl_start parm_app_code = 039 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 33506F453030280D8FDA sCDKey = 852815921316 sName = VB ========================2018-06-22 14:57: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 14:57:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 14:57:21======================== SELECT idx FROM macs WHERE mac_addr = '33506F453030280D8FDA' AND app_code = '039' ========================2018-06-22 14:57:21======================== 값이 없을 경우 ========================2018-06-22 15:00:18======================== noteurl_start parm_app_code = 039 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 33506F453030280D8FDA sCDKey = 852815921316 sName = VB ========================2018-06-22 15:00: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:00:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:00:18======================== SELECT idx FROM macs WHERE mac_addr = '33506F453030280D8FDA' AND app_code = '039' ========================2018-06-22 15:00:18======================== 값이 없을 경우 ========================2018-06-22 15:03:29======================== noteurl_start parm_app_code = 039 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 33506F453030280D8FDA sCDKey = 852815921316 sName = VB ========================2018-06-22 15:03: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:03:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:03:29======================== SELECT idx FROM macs WHERE mac_addr = '33506F453030280D8FDA' AND app_code = '039' ========================2018-06-22 15:03:29======================== 값이 없을 경우 ========================2018-06-22 15:03:54======================== noteurl_start parm_app_code = 039 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 33506F453030280D8FDA sCDKey = 852815921316 sName = VB ========================2018-06-22 15:03: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:03:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:03:54======================== SELECT idx FROM macs WHERE mac_addr = '33506F453030280D8FDA' AND app_code = '039' ========================2018-06-22 15:03:54======================== 값이 없을 경우 ========================2018-06-22 15:06:45======================== noteurl_start parm_app_code = 039 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D16817280D8FDA sCDKey = 852815921316 sName = VB ========================2018-06-22 15:06: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:06:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:06:45======================== SELECT idx FROM macs WHERE mac_addr = '080027D16817280D8FDA' AND app_code = '039' ========================2018-06-22 15:06:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251257' ========================2018-06-22 15:06:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251257' ========================2018-06-22 15:06: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 ( '251257', '080027D16817280D8FDA', '039', 'VB', '64', '1920', '976', 'aej123456', '엠제이소프트[안은준]', '852815921316' ) ========================2018-06-22 15:11:30======================== noteurl_start parm_app_code = 039 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D16817280D8FDA sCDKey = 852815921316 sName = VB ========================2018-06-22 15: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:11:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:11:30======================== SELECT idx FROM macs WHERE mac_addr = '080027D16817280D8FDA' AND app_code = '039' ========================2018-06-22 15:11:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251257' ========================2018-06-22 15:11:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251257' ========================2018-06-22 15:11:30======================== UPDATE mac_detail SET pc_name = 'VB', os_type = '64', user_id = 'aej123456', user_name = '엠제이소프트[안은준]', screen_w = '1920', screen_h = '976', cdkey = '852815921316' WHERE mac_idx = '251257' ========================2018-06-22 15:18:32======================== noteurl_start parm_app_code = 039 parm_pc_name = KR parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D16817280D8FDA sCDKey = 852815921316 sName = KR ========================2018-06-22 15:18: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:18:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:18:32======================== SELECT idx FROM macs WHERE mac_addr = '080027D16817280D8FDA' AND app_code = '039' ========================2018-06-22 15:18:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251257' ========================2018-06-22 15:18:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251257' ========================2018-06-22 15:18:32======================== UPDATE mac_detail SET pc_name = 'KR', os_type = '64', user_id = 'aej123456', user_name = '엠제이소프트[안은준]', screen_w = '1920', screen_h = '976', cdkey = '852815921316' WHERE mac_idx = '251257' ========================2018-06-22 15:22:11======================== noteurl_start parm_app_code = 039 parm_pc_name = KR parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027985830280D8FDA sCDKey = 852815921316 sName = KR ========================2018-06-22 15:22:11======================== 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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:22:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:22:11======================== SELECT idx FROM macs WHERE mac_addr = '080027985830280D8FDA' AND app_code = '039' ========================2018-06-22 15:22:11======================== 값이 없을 경우 ========================2018-06-22 15:25:29======================== noteurl_start parm_app_code = 039 parm_pc_name = KR parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027FAECDE280D8FDA sCDKey = 852815921316 sName = KR ========================2018-06-22 15:25: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:25:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:25:29======================== SELECT idx FROM macs WHERE mac_addr = '080027FAECDE280D8FDA' AND app_code = '039' ========================2018-06-22 15:25:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251262' ========================2018-06-22 15:25:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251262' ========================2018-06-22 15:25:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251262', '080027FAECDE280D8FDA', '039', 'KR', '64', '1920', '976', 'aej123456', '엠제이소프트[안은준]', '852815921316' ) ========================2018-06-22 15:28:08======================== noteurl_start parm_app_code = 039 parm_pc_name = KR parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027985830280D8FDA sCDKey = 852815921316 sName = KR ========================2018-06-22 15:28: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 = '852815921316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:28:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-22 15:28:08======================== SELECT idx FROM macs WHERE mac_addr = '080027985830280D8FDA' AND app_code = '039' ========================2018-06-22 15:28:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252645' ========================2018-06-22 15:28:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252645' ========================2018-06-22 15:28: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 ( '252645', '080027985830280D8FDA', '039', 'KR', '64', '1920', '976', 'aej123456', '엠제이소프트[안은준]', '852815921316' ) ========================2018-06-22 15:29:39======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 50E549A51A022C3899D2 sCDKey = 448060168454 sName = USER ========================2018-06-22 15:29: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 = '448060168454' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 15:29:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyb0043' ========================2018-06-22 15:29:39======================== SELECT idx FROM macs WHERE mac_addr = '50E549A51A022C3899D2' AND app_code = '039' ========================2018-06-22 15:29:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252646' ========================2018-06-22 15:29:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252646' ========================2018-06-22 15:29:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252646', '50E549A51A022C3899D2', '039', 'USER', '90', '1600', '900', 'kyb0043', '태진산업[길용보]', '448060168454' ) ========================2018-06-22 16:27:55======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = F44D30B9B79B345CC662 sCDKey = 389572720374 sName = 111 ========================2018-06-22 16:27: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 = '389572720374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-22 16:27:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vizz' ========================2018-06-22 16:27:55======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B79B345CC662' AND app_code = '039' ========================2018-06-22 16:27:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '222106' ========================2018-06-22 16:27:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '222106' ========================2018-06-22 16:27:55======================== UPDATE mac_detail SET pc_name = '111', os_type = '110', user_id = 'vizz', user_name = '이승환[이승환]', screen_w = '1280', screen_h = '1024', cdkey = '389572720374' WHERE mac_idx = '222106'