========================2019-07-09 09:31:50======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC20359800B9B0F sCDKey = 001403641291 sName = OKPOS ========================2019-07-09 09:31: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 = '001403641291' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-09 09:32:11======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC20359800B9B0F sCDKey = 001409641291 sName = OKPOS ========================2019-07-09 09:32: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 = '001409641291' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-09 09:32:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aplus9696' ========================2019-07-09 09:32:11======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AC20359800B9B0F' AND app_code = '046' ========================2019-07-09 09:32:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290353' ========================2019-07-09 09:32:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290353' ========================2019-07-09 09:32:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290353', 'B8975AC20359800B9B0F', '046', 'OKPOS', '64', '1024', '768', 'aplus9696', '(주)에이플러스 푸드시스템[박병삼]', '001409641291' ) ========================2019-07-09 09:56:07======================== noteurl_start parm_app_code = 051 parm_pc_name = HEA010319 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 5076AF19B248B6653E36 sCDKey = 937740825227 sName = HEA010319 ========================2019-07-09 09:56:07======================== 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 = '937740825227' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-09 09:56:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'irisinfotech' ========================2019-07-09 09:56:07======================== SELECT idx FROM macs WHERE mac_addr = '5076AF19B248B6653E36' AND app_code = '051' ========================2019-07-09 09:56:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290030' ========================2019-07-09 09:56:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290030' ========================2019-07-09 09:56:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290030', '5076AF19B248B6653E36', '051', 'HEA010319', '109', '1920', '1080', 'irisinfotech', 'IRIS INFOTECH[조광희]', '937740825227' ) ========================2019-07-09 10:37:55======================== noteurl_start parm_app_code = 051 parm_pc_name = HEA010319 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 5076AF19B248B6653E36 sCDKey = 937740825227 sName = HEA010319 ========================2019-07-09 10:37: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 = '937740825227' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-09 10:37:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'irisinfotech' ========================2019-07-09 10:37:55======================== SELECT idx FROM macs WHERE mac_addr = '5076AF19B248B6653E36' AND app_code = '051' ========================2019-07-09 10:37:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290030' ========================2019-07-09 10:37:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290030' ========================2019-07-09 10:37:55======================== UPDATE mac_detail SET pc_name = 'HEA010319', os_type = '109', user_id = 'irisinfotech', user_name = 'IRIS INFOTECH[조광희]', screen_w = '1920', screen_h = '1080', cdkey = '937740825227' WHERE mac_idx = '290030' ========================2019-07-09 12:00:23======================== noteurl_start parm_app_code = 039 parm_pc_name = COM-20190709LMI parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50465D7132EE58A5BEAF sCDKey = 957015247299 sName = COM-20190709LMI ========================2019-07-09 12:00:23======================== 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 = '957015247299' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 12:00:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjdtks5588' ========================2019-07-09 12:00:23======================== SELECT idx FROM macs WHERE mac_addr = '50465D7132EE58A5BEAF' AND app_code = '039' ========================2019-07-09 12:00:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '144202' ========================2019-07-09 12:00:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '144202' ========================2019-07-09 12:00:23======================== UPDATE mac_detail SET pc_name = 'COM-20190709LMI', os_type = '90', user_id = 'cjdtks5588', user_name = '청산중기[원유진]', screen_w = '1920', screen_h = '1080', cdkey = '957015247299' WHERE mac_idx = '144202' ========================2019-07-09 15:10:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RLD7UGO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2C902B4E4966AC0 sCDKey = 078736982678 sName = DESKTOP-RLD7UGO ========================2019-07-09 15:10: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 = '078736982678' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 15:10:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RLD7UGO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2C902B4E4966AC0 sCDKey = 078736982678 sName = DESKTOP-RLD7UGO ========================2019-07-09 15:10: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 = '078736982678' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 15:11:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RLD7UGO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2C902B4E4966AC0 sCDKey = 078736982678 sName = DESKTOP-RLD7UGO ========================2019-07-09 15:11: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 = '078736982678' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 15:11:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoo4249' ========================2019-07-09 15:11:49======================== SELECT idx FROM macs WHERE mac_addr = '7085C2C902B4E4966AC0' AND app_code = '039' ========================2019-07-09 15:11:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290393' ========================2019-07-09 15:11:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290393' ========================2019-07-09 15:11: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 ( '290393', '7085C2C902B4E4966AC0', '039', 'DESKTOP-RLD7UGO', '110', '1920', '1080', 'yoo4249', '(주)창성농산[김숙진]', '078736982678' ) ========================2019-07-09 15:11:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RLD7UGO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2C902B4E4966AC0 sCDKey = 078736982678 sName = DESKTOP-RLD7UGO ========================2019-07-09 15:11: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 = '078736982678' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 15:42:53======================== noteurl_start parm_app_code = 051 parm_pc_name = SKIN-0501378NB1 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = ACFDCEDE5A5DF8470154 sCDKey = 003401679376 sName = SKIN-0501378NB1 ========================2019-07-09 15:42: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-09 15:42:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2019-07-09 15:42:53======================== SELECT idx FROM macs WHERE mac_addr = 'ACFDCEDE5A5DF8470154' AND app_code = '051' ========================2019-07-09 15:42:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290403' ========================2019-07-09 15:42:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290403' ========================2019-07-09 15:42:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290403', 'ACFDCEDE5A5DF8470154', '051', 'SKIN-0501378NB1', '90', '1366', '768', 'skinfosec', '인포섹[이대윤]', '003401679376' ) ========================2019-07-09 16:02:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GT2D0BI parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 7085C2C902ACC2889990 sCDKey = 264493762382 sName = DESKTOP-GT2D0BI ========================2019-07-09 16:02: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 = '264493762382' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 16:02:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoo1294' ========================2019-07-09 16:02:14======================== SELECT idx FROM macs WHERE mac_addr = '7085C2C902ACC2889990' AND app_code = '039' ========================2019-07-09 16:02:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290406' ========================2019-07-09 16:02:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290406' ========================2019-07-09 16:02: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 ( '290406', '7085C2C902ACC2889990', '039', 'DESKTOP-GT2D0BI', '110', '1600', '900', 'yoo1294', '마을로[노현동]', '264493762382' ) ========================2019-07-09 16:25:54======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B8975A1528A82E3C70F5 sCDKey = 995043238263 sName = USER-PC ========================2019-07-09 16:25: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 = '995043238263' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-09 16:25:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hizoner' ========================2019-07-09 16:25:54======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A1528A82E3C70F5' AND app_code = '046' ========================2019-07-09 16:25:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290417' ========================2019-07-09 16:25:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290417' ========================2019-07-09 16:25: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 ( '290417', 'B8975A1528A82E3C70F5', '046', 'USER-PC', '90', '1680', '1050', 'hizoner', '다판다원주점[최영수]', '995043238263' ) ========================2019-07-09 17:59:03======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00A1B08B353BE8611E19 sCDKey = 363622329041 sName = 더샵디자인광고 ========================2019-07-09 17:59: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 17:59:17======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00A1B08B353BE8611E19 sCDKey = 363622329041 sName = ========================2019-07-09 17:59: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 17:59:48======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00A1B08B353BE8611E19 sCDKey = 363622329041 sName = card1021@248 ========================2019-07-09 17:59: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 18:12:09======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00A1B08B353BE8611E19 sCDKey = 363622329041 sName = ========================2019-07-09 18:12:09======================== 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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 18:12:23======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00A1B08B353BE8611E19 sCDKey = 363622329041 sName = 박태하 ========================2019-07-09 18:12:23======================== 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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 18:12:49======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00A1B08B353BE8611E19 sCDKey = 363622329041 sName = 현수막백화점 ========================2019-07-09 18:12: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-09 18:13:10======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00A1B08B353BE8611E19 sCDKey = 363622329041 sName = 현수막백화점 ========================2019-07-09 18:13: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0