========================2018-08-31 09:16:09======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00242150B54124CA1BE3 sCDKey = 812834265902 sName = MSDN-SPECIAL ========================2018-08-31 09:16: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 = '812834265902' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-31 09:16:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vnfmsshdtks' ========================2018-08-31 09:16:09======================== SELECT idx FROM macs WHERE mac_addr = '00242150B54124CA1BE3' AND app_code = '039' ========================2018-08-31 09:16:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258720' ========================2018-08-31 09:16:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258720' ========================2018-08-31 09:16: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 ( '258720', '00242150B54124CA1BE3', '039', 'MSDN-SPECIAL', '90', '1280', '1024', 'vnfmsshdtks', '푸른농산[이재훈]', '812834265902' ) ========================2018-08-31 09:22:05======================== noteurl_start parm_app_code = 039 parm_pc_name = BMI1124-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDF6F9382CF09A38 sCDKey = 708322585128 sName = BMI1124-PC ========================2018-08-31 09:22: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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-31 09:22:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2018-08-31 09:22:05======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDF6F9382CF09A38' AND app_code = '039' ========================2018-08-31 09:22:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '201525' ========================2018-08-31 09:22:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '201525' ========================2018-08-31 09:22:05======================== UPDATE mac_detail SET pc_name = 'BMI1124-PC', os_type = '90', user_id = 'ramades77', user_name = '(주)비엠아이[이동훈]', screen_w = '1920', screen_h = '1080', cdkey = '708322585128' WHERE mac_idx = '201525' ========================2018-08-31 11:00:32======================== noteurl_start parm_app_code = 039 parm_pc_name = D-COM parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = FCAA14F220BE86492D1F sCDKey = 562636376036 sName = D-COM ========================2018-08-31 11:00: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 = '562636376036' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-31 11:00:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kkh9822' ========================2018-08-31 11:00:32======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14F220BE86492D1F' AND app_code = '039' ========================2018-08-31 11:00:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '161921' ========================2018-08-31 11:00:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '161921' ========================2018-08-31 11:00:32======================== UPDATE mac_detail SET pc_name = 'D-COM', os_type = '90', user_id = 'kkh9822', user_name = '신한전기조명[김경환]', screen_w = '1280', screen_h = '1024', cdkey = '562636376036' WHERE mac_idx = '161921' ========================2018-08-31 11:22:51======================== noteurl_start parm_app_code = 039 parm_pc_name = KGB-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 88D7F643359564203B56 sCDKey = 793826742661 sName = KGB-PC ========================2018-08-31 11:22:51======================== 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 = '793826742661' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-31 11:22:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljh820526' ========================2018-08-31 11:22:51======================== SELECT idx FROM macs WHERE mac_addr = '88D7F643359564203B56' AND app_code = '039' ========================2018-08-31 11:22:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258769' ========================2018-08-31 11:22:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258769' ========================2018-08-31 11:22:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '258769', '88D7F643359564203B56', '039', 'KGB-PC', '90', '1600', '900', 'ljh820526', 'kgb상주지점[이재혁]', '793826742661' ) ========================2018-08-31 17:52:25======================== noteurl_start parm_app_code = 050 parm_pc_name = 강병현 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFB61AC854AAC3DE5 sCDKey = 278195835472 sName = 강병현 ========================2018-08-31 17:52:25======================== 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 = '278195835472' AND r.app_code = '050' AND r.app_block = 0 ========================2018-08-31 17:52:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cidica' ========================2018-08-31 17:52:25======================== SELECT idx FROM macs WHERE mac_addr = '4CEDFB61AC854AAC3DE5' AND app_code = '050' ========================2018-08-31 17:52:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258824' ========================2018-08-31 17:52:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258824' ========================2018-08-31 17:52:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '258824', '4CEDFB61AC854AAC3DE5', '050', '강병현', '90', '1920', '1080', 'cidica', '대전정보문화산업진흥원[강병헌]', '278195835472' )