========================2018-03-28 09:49:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5MS7GGS parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = D050990CA1C19652F26D sCDKey = 270133813168 sName = DESKTOP-5MS7GGS ========================2018-03-28 09:49: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 = '270133813168' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-28 09:49:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jungrocgi' ========================2018-03-28 09:49:16======================== SELECT idx FROM macs WHERE mac_addr = 'D050990CA1C19652F26D' AND app_code = '039' ========================2018-03-28 09:49:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245649' ========================2018-03-28 09:49:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245649' ========================2018-03-28 09:49: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 ( '245649', 'D050990CA1C19652F26D', '039', 'DESKTOP-5MS7GGS', '110', '1280', '1024', 'jungrocgi', '대광상회[정건택]', '270133813168' ) ========================2018-03-28 15:22:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-AF7NB12 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 14C913125E1B409AE880 sCDKey = 871493774946 sName = DESKTOP-AF7NB12 ========================2018-03-28 15:22:57======================== 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 = '871493774946' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-28 15:22:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rmstj57' ========================2018-03-28 15:22:57======================== SELECT idx FROM macs WHERE mac_addr = '14C913125E1B409AE880' AND app_code = '039' ========================2018-03-28 15:22:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245682' ========================2018-03-28 15:22:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245682' ========================2018-03-28 15:22:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245682', '14C913125E1B409AE880', '039', 'DESKTOP-AF7NB12', '110', '1536', '864', 'rmstj57', '현대어망[황미화]', '871493774946' ) ========================2018-03-28 17:12:13======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TB7MGPE parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 94C691321B220AAD474F sCDKey = 231851322592 sName = DESKTOP-TB7MGPE ========================2018-03-28 17:12:13======================== 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 = '231851322592' AND r.app_code = '047' AND r.app_block = 0 ========================2018-03-28 17:12:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hak79' ========================2018-03-28 17:12:13======================== SELECT idx FROM macs WHERE mac_addr = '94C691321B220AAD474F' AND app_code = '047' ========================2018-03-28 17:12:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245714' ========================2018-03-28 17:12:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245714' ========================2018-03-28 17:12:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245714', '94C691321B220AAD474F', '047', 'DESKTOP-TB7MGPE', '�쐢�룄�슦 10', '0', '0', 'hak79', '[이봉학1]', '231851322592' ) ========================2018-03-28 17:20:19======================== noteurl_start parm_app_code = 039 parm_pc_name = HOME-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0CB4EB8C946441C2505 sCDKey = 549176813222 sName = HOME-PC ========================2018-03-28 17: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 = '549176813222' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-28 17:20:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'js1212' ========================2018-03-28 17:20:19======================== SELECT idx FROM macs WHERE mac_addr = 'E0CB4EB8C946441C2505' AND app_code = '039' ========================2018-03-28 17:20:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245716' ========================2018-03-28 17:20:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245716' ========================2018-03-28 17: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 ( '245716', 'E0CB4EB8C946441C2505', '039', 'HOME-PC', '90', '1680', '1050', 'js1212', '정성테크[김길례]', '549176813222' ) ========================2018-03-28 17:24:49======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 50B7C3A104916AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-03-28 17:24: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-28 17:29:31======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 50B7C3A104916AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-03-28 17:29:31======================== 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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-28 17:29:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdsjys' ========================2018-03-28 17:29:31======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A104916AE4A07A' AND app_code = '039' ========================2018-03-28 17:29:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '159891' ========================2018-03-28 17:29:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '159891' ========================2018-03-28 17:29:31======================== UPDATE mac_detail SET pc_name = 'JINA', os_type = '110', user_id = 'kdsjys', user_name = '현대상사[지윤순]', screen_w = '1280', screen_h = '1024', cdkey = '049554512864' WHERE mac_idx = '159891' ========================2018-03-28 17:29:38======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 50B7C3A104916AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-03-28 17:29: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-28 17:30:08======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 50B7C3A104916AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-03-28 17:30:08======================== 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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0