========================2018-04-10 09:04:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NBLD07R parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = C8600069299AE0B4B572 sCDKey = 550549105676 sName = DESKTOP-NBLD07R ========================2018-04-10 09:04: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 = '550549105676' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-10 09:04:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhdmf214' ========================2018-04-10 09:04:54======================== SELECT idx FROM macs WHERE mac_addr = 'C8600069299AE0B4B572' AND app_code = '039' ========================2018-04-10 09:04:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '246845' ========================2018-04-10 09:04:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '246845' ========================2018-04-10 09:04:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '246845', 'C8600069299AE0B4B572', '039', 'DESKTOP-NBLD07R', '110', '1366', '768', 'rhdmf214', '주)주은실업[김상호]', '550549105676' ) ========================2018-04-10 09:31:36======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C4F4E1E426B096F sCDKey = 718527753355 sName = USER-PC ========================2018-04-10 09:31: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 = '718527753355' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-10 09:34:14======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C4F4E1E426B096F sCDKey = 718527753356 sName = USER-PC ========================2018-04-10 09:34: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 = '718527753356' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-10 09:34:20======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C4F4E1E426B096F sCDKey = 718527753355 sName = USER-PC ========================2018-04-10 09:34: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 = '718527753355' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-10 11:06:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-H4F6V6L parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883891CA7A926E53153 sCDKey = 979755277718 sName = DESKTOP-H4F6V6L ========================2018-04-10 11:06: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 = '979755277718' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-10 11:06:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dongmuh1' ========================2018-04-10 11:06:03======================== SELECT idx FROM macs WHERE mac_addr = '9883891CA7A926E53153' AND app_code = '039' ========================2018-04-10 11:06:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '246869' ========================2018-04-10 11:06:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '246869' ========================2018-04-10 11:06:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '246869', '9883891CA7A926E53153', '039', 'DESKTOP-H4F6V6L', '110', '1920', '1080', 'dongmuh1', '(주)아이유[박동무]', '979755277718' ) ========================2018-04-10 14:04:26======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 6C626D5D391AAE81FA52 sCDKey = 952587152795 sName = ========================2018-04-10 14:04: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 = '952587152795' AND r.app_code = '050' AND r.app_block = 0 ========================2018-04-10 14:04:30======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 6C626D5D391AAE81FA52 sCDKey = 952587152795 sName = 한지수 ========================2018-04-10 14:04: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 = '952587152795' AND r.app_code = '050' AND r.app_block = 0 ========================2018-04-10 14:04:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjs1' ========================2018-04-10 14:04:30======================== SELECT idx FROM macs WHERE mac_addr = '6C626D5D391AAE81FA52' AND app_code = '050' ========================2018-04-10 14:04:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243671' ========================2018-04-10 14:04:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243671' ========================2018-04-10 14:04:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243671', '6C626D5D391AAE81FA52', '050', '한지수', '109', '1680', '1050', 'hjs1', '엠제이소프트[한지수]', '952587152795' ) ========================2018-04-10 14:12:30======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CAD2H8R parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCEE7B8BF6BAB426B21A sCDKey = 449570970624 sName = DESKTOP-CAD2H8R ========================2018-04-10 14:12: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 = '449570970624' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-10 14:14:42======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CAD2H8R parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCEE7B8BF6BAB426B21A sCDKey = 449570970624 sName = DESKTOP-CAD2H8R ========================2018-04-10 14:14: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 = '449570970624' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-10 14:14:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinsin00' ========================2018-04-10 14:14:42======================== SELECT idx FROM macs WHERE mac_addr = 'BCEE7B8BF6BAB426B21A' AND app_code = '046' ========================2018-04-10 14:14:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '232439' ========================2018-04-10 14:14:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '232439' ========================2018-04-10 14:14:42======================== UPDATE mac_detail SET pc_name = 'DESKTOP-CAD2H8R', os_type = '110', user_id = 'sinsin00', user_name = '신신낚시유성점[민홍기]', screen_w = '1920', screen_h = '1080', cdkey = '449570970624' WHERE mac_idx = '232439' ========================2018-04-10 14:57:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-DEVIV9S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23A24FF49AB5A53A sCDKey = 735832194513 sName = DESKTOP-DEVIV9S ========================2018-04-10 14:57:56======================== 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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-10 15:11:58======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-T1UCVLC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B346C9F87DA168E5F sCDKey = 449570970624 sName = DESKTOP-T1UCVLC ========================2018-04-10 15:11: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 = '449570970624' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-10 15:11:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinsin00' ========================2018-04-10 15:11:58======================== SELECT idx FROM macs WHERE mac_addr = '902B346C9F87DA168E5F' AND app_code = '046' ========================2018-04-10 15:11:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235461' ========================2018-04-10 15:11:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235461' ========================2018-04-10 15:11:58======================== UPDATE mac_detail SET pc_name = 'DESKTOP-T1UCVLC', os_type = '110', user_id = 'sinsin00', user_name = '신신낚시유성점[민홍기]', screen_w = '1920', screen_h = '1080', cdkey = '449570970624' WHERE mac_idx = '235461'