========================2018-01-25 10:08:43======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-UC5GCVJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 0030676B307CAC253935 sCDKey = 578270000299 sName = DESKTOP-UC5GCVJ ========================2018-01-25 10:08: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 = '578270000299' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-25 10:08:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ria8210' ========================2018-01-25 10:08:43======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307CAC253935' AND app_code = '048' ========================2018-01-25 10:08:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240354' ========================2018-01-25 10:08:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240354' ========================2018-01-25 10:08:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240354', '0030676B307CAC253935', '048', 'DESKTOP-UC5GCVJ', '�쐢�룄�슦 10', '0', '0', 'ria8210', '미진소프트[김민정]', '578270000299' ) ========================2018-01-25 13:21:52======================== noteurl_start parm_app_code = 046 parm_pc_name = KHH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 049453292108 sName = KHH-PC ========================2018-01-25 13:21:52======================== 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 = '049453292108' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-25 13:21:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'donkey0318' ========================2018-01-25 13:21:52======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE5C6AB0D604' AND app_code = '046' ========================2018-01-25 13:21:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240372' ========================2018-01-25 13:21:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240372' ========================2018-01-25 13:21:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240372', 'F44D30B9AE5C6AB0D604', '046', 'KHH-PC', '110', '1920', '1080', 'donkey0318', '엠제이소프트[김현호]', '049453292108' ) ========================2018-01-25 13:22:12======================== noteurl_start parm_app_code = 046 parm_pc_name = KHH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 049453292108 sName = KHH-PC ========================2018-01-25 13:22:12======================== 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 = '049453292108' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-25 13:37:39======================== 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 = E4029B3703D9627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-01-25 13:37: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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-25 13:37:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'y1776073' ========================2018-01-25 13:37:39======================== SELECT idx FROM macs WHERE mac_addr = 'E4029B3703D9627461D4' AND app_code = '039' ========================2018-01-25 13:37:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '195365' ========================2018-01-25 13:37:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '195365' ========================2018-01-25 13:37:39======================== 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 = '195365' ========================2018-01-25 15:09:22======================== noteurl_start parm_app_code = 039 parm_pc_name = COM1 parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 4CCC6A479E252AA45ED4 sCDKey = 432379454355 sName = COM1 ========================2018-01-25 15:09:22======================== 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 = '432379454355' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-25 15:09:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'copy62' ========================2018-01-25 15:09:22======================== SELECT idx FROM macs WHERE mac_addr = '4CCC6A479E252AA45ED4' AND app_code = '039' ========================2018-01-25 15:09:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240385' ========================2018-01-25 15:09:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240385' ========================2018-01-25 15:09:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240385', '4CCC6A479E252AA45ED4', '039', 'COM1', '90', '1280', '1024', 'copy62', '제일복사[심상보]', '432379454355' )