========================2018-12-10 07:23:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-03N78P2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C28AEEF2C2ACFF7C sCDKey = 970129728474 sName = DESKTOP-03N78P2 ========================2018-12-10 07: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 = '970129728474' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 09:05:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-03N78P2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C28AEEF2C2ACFF7C sCDKey = 970129728474 sName = DESKTOP-03N78P2 ========================2018-12-10 09:05: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 = '970129728474' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 09:07:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-03N78P2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C28AEEF2C2ACFF7C sCDKey = 970129728474 sName = DESKTOP-03N78P2 ========================2018-12-10 09:07: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 = '970129728474' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 09:07:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ju2620' ========================2018-12-10 09:07:17======================== SELECT idx FROM macs WHERE mac_addr = '7085C28AEEF2C2ACFF7C' AND app_code = '039' ========================2018-12-10 09:07:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270369' ========================2018-12-10 09:07:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270369' ========================2018-12-10 09:07:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '270369', '7085C28AEEF2C2ACFF7C', '039', 'DESKTOP-03N78P2', '110', '1920', '1080', 'ju2620', '정일철망[문춘구]', '970129728474' ) ========================2018-12-10 10:18:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F615627461D4 sCDKey = 826605916014 sName = DESKTOP-7CR0VE9 ========================2018-12-10 10:18: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 = '826605916014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 10:18:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F615627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-12-10 10:18: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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 10:18:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'y1776073' ========================2018-12-10 10:18:43======================== SELECT idx FROM macs WHERE mac_addr = '14C91311F615627461D4' AND app_code = '039' ========================2018-12-10 10:18:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '224427' ========================2018-12-10 10:18:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '224427' ========================2018-12-10 10:18:43======================== UPDATE mac_detail SET pc_name = 'DESKTOP-7CR0VE9', os_type = '110', user_id = 'y1776073', user_name = '광자동화[황순영]', screen_w = '1920', screen_h = '1080', cdkey = '826605316014' WHERE mac_idx = '224427' ========================2018-12-10 10:19:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F615627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-12-10 10: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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 11:03:57======================== noteurl_start parm_app_code = 039 parm_pc_name = N181025-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D02788A156C78E667732 sCDKey = 491247338384 sName = N181025-PC ========================2018-12-10 11:03: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 = '491247338384' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 11:03:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wschoe1' ========================2018-12-10 11:03:57======================== SELECT idx FROM macs WHERE mac_addr = 'D02788A156C78E667732' AND app_code = '039' ========================2018-12-10 11:03:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '265411' ========================2018-12-10 11:03:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '265411' ========================2018-12-10 11:03:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '265411', 'D02788A156C78E667732', '039', 'N181025-PC', '90', '1920', '1080', 'wschoe1', '맘푸드시스템[최원상]', '491247338384' ) ========================2018-12-10 13:12:57======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D435816FDB7ADF259F sCDKey = 893945333825 sName = USER-PC ========================2018-12-10 13:12: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 = '893945333825' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 13:13:14======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D435816FDB7ADF259F sCDKey = 893945333825 sName = USER-PC ========================2018-12-10 13:13: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 = '893945333825' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 13:13:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kukje7400' ========================2018-12-10 13:13:14======================== SELECT idx FROM macs WHERE mac_addr = '74D435816FDB7ADF259F' AND app_code = '039' ========================2018-12-10 13:13:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270470' ========================2018-12-10 13:13:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270470' ========================2018-12-10 13:13: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 ( '270470', '74D435816FDB7ADF259F', '039', 'USER-PC', '90', '1920', '1080', 'kukje7400', '국제멜라민[이용배]', '893945333825' ) ========================2018-12-10 13:14:49======================== noteurl_start parm_app_code = 039 parm_pc_name = SUMIN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5C210AF4A297FCB7 sCDKey = 893945333825 sName = SUMIN-PC ========================2018-12-10 13:14: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 = '893945333825' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 13:14:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kukje7400' ========================2018-12-10 13:14:49======================== SELECT idx FROM macs WHERE mac_addr = '408D5C210AF4A297FCB7' AND app_code = '039' ========================2018-12-10 13:14:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '157924' ========================2018-12-10 13:14:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '157924' ========================2018-12-10 13:14:49======================== UPDATE mac_detail SET pc_name = 'SUMIN-PC', os_type = '90', user_id = 'kukje7400', user_name = '국제멜라민[이용배]', screen_w = '1600', screen_h = '900', cdkey = '893945333825' WHERE mac_idx = '157924' ========================2018-12-10 14:46:55======================== noteurl_start parm_app_code = 047 parm_pc_name = MONKEYSUNCLE parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAB89E959CE1216E sCDKey = 708074012918 sName = MONKEYSUNCLE ========================2018-12-10 14:46: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 = '708074012918' AND r.app_code = '047' AND r.app_block = 0 ========================2018-12-10 14:46:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'idealinkkr' ========================2018-12-10 14:46:55======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAB89E959CE1216E' AND app_code = '047' ========================2018-12-10 14:46:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267502' ========================2018-12-10 14:46:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267502' ========================2018-12-10 14:46:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '267502', '24F5AAB89E959CE1216E', '047', 'MONKEYSUNCLE', '�쐢�룄�슦 10', '0', '0', 'idealinkkr', '아이디어링크코리아[ 진일기]', '708074012918' ) ========================2018-12-10 15:15:31======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 4C72B97BC007E09C8485 sCDKey = 625904807748 sName = USER-PC ========================2018-12-10 15:15: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 = '625904807748' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-10 15:15:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gkswls1212' ========================2018-12-10 15:15:31======================== SELECT idx FROM macs WHERE mac_addr = '4C72B97BC007E09C8485' AND app_code = '039' ========================2018-12-10 15:15:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270489' ========================2018-12-10 15:15:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270489' ========================2018-12-10 15:15:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '270489', '4C72B97BC007E09C8485', '039', 'USER-PC', '90', '1600', '900', 'gkswls1212', '(주)에스제이로지스틱스[이재민]', '625904807748' )