========================2018-03-21 09:39:09======================== noteurl_start parm_app_code = 039 parm_pc_name = CHLRHKDGKR-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 90FBA664F30046ECF7F sCDKey = 992106377409 sName = CHLRHKDGKR-PC ========================2018-03-21 09:39: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 = '992106377409' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-21 09:39:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chlrhkd6310' ========================2018-03-21 09:39:09======================== SELECT idx FROM macs WHERE mac_addr = '90FBA664F30046ECF7F' AND app_code = '039' ========================2018-03-21 09:39:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239586' ========================2018-03-21 09:39:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239586' ========================2018-03-21 09:39:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239586', '90FBA664F30046ECF7F', '039', 'CHLRHKDGKR-PC', '90', '1440', '900', 'chlrhkd6310', '[최광학]', '992106377409' ) ========================2018-03-21 10:58:16======================== noteurl_start parm_app_code = 046 parm_pc_name = SERVER parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 408D5CFDC77A128878B5 sCDKey = 270965864323 sName = SERVER ========================2018-03-21 10:58:16======================== 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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-21 10:58:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2018-03-21 10:58:16======================== SELECT idx FROM macs WHERE mac_addr = '408D5CFDC77A128878B5' AND app_code = '046' ========================2018-03-21 10:58:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243381' ========================2018-03-21 10:58:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243381' ========================2018-03-21 10:58:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243381', '408D5CFDC77A128878B5', '046', 'SERVER', '90', '1680', '1050', 'kyr0909', '동양종합식품[김영록]', '270965864323' ) ========================2018-03-21 11:30:37======================== noteurl_start parm_app_code = 039 parm_pc_name = JNB-MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C263260CBC524518 sCDKey = 917355058631 sName = JNB-MAIN ========================2018-03-21 11:30:37======================== 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 = '917355058631' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-21 11:30:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbelectro' ========================2018-03-21 11:30:37======================== SELECT idx FROM macs WHERE mac_addr = '7085C263260CBC524518' AND app_code = '039' ========================2018-03-21 11:30:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245017' ========================2018-03-21 11:30:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245017' ========================2018-03-21 11:30:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245017', '7085C263260CBC524518', '039', 'JNB-MAIN', '110', '1920', '1080', 'jbelectro', '제이앤비[김선택]', '917355058631' ) ========================2018-03-21 13:12:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB6FBBE84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-03-21 13:12: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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-21 14:42:59======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G1NLH5J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509977338D9254FD60 sCDKey = 130237735661 sName = DESKTOP-G1NLH5J ========================2018-03-21 14:42: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 = '130237735661' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-21 14:42:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ppo7677' ========================2018-03-21 14:42:59======================== SELECT idx FROM macs WHERE mac_addr = 'D0509977338D9254FD60' AND app_code = '039' ========================2018-03-21 14:42:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244436' ========================2018-03-21 14:42:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244436' ========================2018-03-21 14:42:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244436', 'D0509977338D9254FD60', '039', 'DESKTOP-G1NLH5J', '110', '1920', '1080', 'ppo7677', '(주)태안건업[김은실]', '130237735661' )