========================2019-02-14 10:10:48======================== noteurl_start parm_app_code = 039 parm_pc_name = CEO parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE806E32F2A00F5524 sCDKey = 329357009795 sName = CEO ========================2019-02-14 10:10: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 = '329357009795' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-14 10:10:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjlaser' ========================2019-02-14 10:10:48======================== SELECT idx FROM macs WHERE mac_addr = '94DE806E32F2A00F5524' AND app_code = '039' ========================2019-02-14 10:10:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '277103' ========================2019-02-14 10:10:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '277103' ========================2019-02-14 10:10:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '277103', '94DE806E32F2A00F5524', '039', 'CEO', '90', '1920', '1080', 'cjlaser', '창조레이저[김찬호]', '329357009795' ) ========================2019-02-14 10:13:46======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00270E0F62D342263ED7 sCDKey = 300172870098 sName = PC ========================2019-02-14 10:13:46======================== 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 = '300172870098' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-14 10:13:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modern4211' ========================2019-02-14 10:13:46======================== SELECT idx FROM macs WHERE mac_addr = '00270E0F62D342263ED7' AND app_code = '039' ========================2019-02-14 10:13:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '197018' ========================2019-02-14 10:13:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '197018' ========================2019-02-14 10:13:46======================== UPDATE mac_detail SET pc_name = 'PC', os_type = '90', user_id = 'modern4211', user_name = '모던에스티[박선정]', screen_w = '1280', screen_h = '1024', cdkey = '300172870098' WHERE mac_idx = '197018' ========================2019-02-14 13:59:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NKMQ6J6 parm_os_type = 110 parm_screen_w = 1152 parm_screen_h = 864 parm_user_mac = E0D55E1AC1EEC878DD16 sCDKey = 106496445630 sName = DESKTOP-NKMQ6J6 ========================2019-02-14 13:59: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 = '106496445630' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-14 13:59:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wnel8290' ========================2019-02-14 13:59:14======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E1AC1EEC878DD16' AND app_code = '039' ========================2019-02-14 13:59:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236439' ========================2019-02-14 13:59:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236439' ========================2019-02-14 13:59:14======================== UPDATE mac_detail SET pc_name = 'DESKTOP-NKMQ6J6', os_type = '110', user_id = 'wnel8290', user_name = '영신산업모터[오영국]', screen_w = '1152', screen_h = '864', cdkey = '106496445630' WHERE mac_idx = '236439' ========================2019-02-14 14:20:19======================== noteurl_start parm_app_code = 039 parm_pc_name = 거성하우징-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CA2C676DC9BEDD8 sCDKey = 714803774810 sName = 거성하우징-PC ========================2019-02-14 14:20:19======================== 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 = '714803774810' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-14 14:20:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kshousing' ========================2019-02-14 14:20:19======================== SELECT idx FROM macs WHERE mac_addr = '408D5CA2C676DC9BEDD8' AND app_code = '039' ========================2019-02-14 14:20:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '277128' ========================2019-02-14 14:20:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '277128' ========================2019-02-14 14:20:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '277128', '408D5CA2C676DC9BEDD8', '039', '거성하우징-PC', '90', '1920', '1080', 'kshousing', '주식회사거성하우징[이재식]', '714803774810' ) ========================2019-02-14 14:22:47======================== noteurl_start parm_app_code = 039 parm_pc_name = 국경하-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA146022223A89162A sCDKey = 714803774810 sName = 국경하-PC ========================2019-02-14 14:22:47======================== 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 = '714803774810' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-14 14:22:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kshousing' ========================2019-02-14 14:22:47======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146022223A89162A' AND app_code = '039' ========================2019-02-14 14:22:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '277132' ========================2019-02-14 14:22:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '277132' ========================2019-02-14 14:22:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '277132', 'FCAA146022223A89162A', '039', '국경하-PC', '90', '1920', '1080', 'kshousing', '주식회사거성하우징[이재식]', '714803774810' ) ========================2019-02-14 17:02:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DAERIM-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8113239F27832A69AEA sCDKey = 204945315397 sName = DAERIM-PC ========================2019-02-14 17:02:01======================== 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 = '204945315397' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-14 17:25:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DAERIM-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8113239F27832A69AEA sCDKey = 204945315397 sName = DAERIM-PC ========================2019-02-14 17:25:29======================== 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 = '204945315397' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-14 17:25:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daerim1921' ========================2019-02-14 17:25:29======================== SELECT idx FROM macs WHERE mac_addr = 'E8113239F27832A69AEA' AND app_code = '039' ========================2019-02-14 17:25:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '153127' ========================2019-02-14 17:25:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '153127' ========================2019-02-14 17:25:29======================== UPDATE mac_detail SET pc_name = 'DAERIM-PC', os_type = '90', user_id = 'daerim1921', user_name = '대림[공이택]', screen_w = '1600', screen_h = '900', cdkey = '204945315397' WHERE mac_idx = '153127'