========================2018-02-02 10:44:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GSSCCGF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509994C2E8220DAAB2 sCDKey = 191074301870 sName = DESKTOP-GSSCCGF ========================2018-02-02 10:44:45======================== 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 = '191074301870' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-02 10:44:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'powertech201' ========================2018-02-02 10:44:45======================== SELECT idx FROM macs WHERE mac_addr = 'D0509994C2E8220DAAB2' AND app_code = '039' ========================2018-02-02 10:44:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241112' ========================2018-02-02 10:44:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241112' ========================2018-02-02 10:44:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241112', 'D0509994C2E8220DAAB2', '039', 'DESKTOP-GSSCCGF', '110', '1920', '1080', 'powertech201', '주식회사파워테크놀러지[황병진]', '191074301870' ) ========================2018-02-02 10:53:25======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 005056C000013E59CBD3 sCDKey = 076018663977 sName = USER ========================2018-02-02 10:53: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 = '076018663977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-02 10:53:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyoworl' ========================2018-02-02 10:53:25======================== SELECT idx FROM macs WHERE mac_addr = '005056C000013E59CBD3' AND app_code = '039' ========================2018-02-02 10:53:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '162014' ========================2018-02-02 10:53:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '162014' ========================2018-02-02 10:53:25======================== UPDATE mac_detail SET pc_name = 'USER', os_type = '110', user_id = 'hyoworl', user_name = '효월영농조합법인[이기영]', screen_w = '1600', screen_h = '900', cdkey = '076018663977' WHERE mac_idx = '162014' ========================2018-02-02 10:53:54======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 005056C000013E59CBD3 sCDKey = 076018663977 sName = USER ========================2018-02-02 10:53: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 = '076018663977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-02 10:56:00======================== noteurl_start parm_app_code = 039 parm_pc_name = SKY-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 960 parm_user_mac = BCAEC5994FAE86D1B3C4 sCDKey = 195650683239 sName = SKY-PC ========================2018-02-02 10:56:00======================== 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 = '195650683239' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-02 10:56:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssmm1017' ========================2018-02-02 10:56:00======================== SELECT idx FROM macs WHERE mac_addr = 'BCAEC5994FAE86D1B3C4' AND app_code = '039' ========================2018-02-02 10:56:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239358' ========================2018-02-02 10:56:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239358' ========================2018-02-02 10:56:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239358', 'BCAEC5994FAE86D1B3C4', '039', 'SKY-PC', '90', '1280', '960', 'ssmm1017', '프라임메디칼[조재영]', '195650683239' ) ========================2018-02-02 11:34:13======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-04 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0028F8812E23268E2177 sCDKey = 683156263623 sName = HBDS-04 ========================2018-02-02 11:34: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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-02 11:34:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2018-02-02 11:34:13======================== SELECT idx FROM macs WHERE mac_addr = '0028F8812E23268E2177' AND app_code = '039' ========================2018-02-02 11:34:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241119' ========================2018-02-02 11:34:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241119' ========================2018-02-02 11:34: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 ( '241119', '0028F8812E23268E2177', '039', 'HBDS-04', '110', '1920', '1080', 'bangchun', '한반도[이진석]', '683156263623' ) ========================2018-02-02 11:38:49======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-1P5GJ43 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897DDA4A1AFFFFFF sCDKey = 971203565041 sName = DESKTOP-1P5GJ43 ========================2018-02-02 11:38: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 = '971203565041' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-02 11:38:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2004' ========================2018-02-02 11:38:49======================== SELECT idx FROM macs WHERE mac_addr = '9883897DDA4A1AFFFFFF' AND app_code = '050' ========================2018-02-02 11:38:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241122' ========================2018-02-02 11:38:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241122' ========================2018-02-02 11:38: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 ( '241122', '9883897DDA4A1AFFFFFF', '050', 'DESKTOP-1P5GJ43', '109', '1920', '1080', 'blc2004', '알루원[남영우]', '971203565041' ) ========================2018-02-02 12:45:13======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ATUMISP parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEC87D9F6BAF49E sCDKey = 134315523299 sName = DESKTOP-ATUMISP ========================2018-02-02 12:45: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 = '134315523299' AND r.app_code = '047' AND r.app_block = 0 ========================2018-02-02 12:45:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'namsun2844' ========================2018-02-02 12:45:13======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEC87D9F6BAF49E' AND app_code = '047' ========================2018-02-02 12:45:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241130' ========================2018-02-02 12:45:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241130' ========================2018-02-02 12:45: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 ( '241130', '24F5AAEC87D9F6BAF49E', '047', 'DESKTOP-ATUMISP', '�쐢�룄�슦 10', '0', '0', 'namsun2844', '남선종합유통(주)[정주연]', '134315523299' ) ========================2018-02-02 17:27:32======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732A6123EE2B1141 sCDKey = 187009624545 sName = DESKTOP-IR4BE71 ========================2018-02-02 17:27: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 = '187009624545' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-02 17:27:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'luckype53' ========================2018-02-02 17:27:32======================== SELECT idx FROM macs WHERE mac_addr = '50AF732A6123EE2B1141' AND app_code = '046' ========================2018-02-02 17:27:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241182' ========================2018-02-02 17:27:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241182' ========================2018-02-02 17:27:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241182', '50AF732A6123EE2B1141', '046', 'DESKTOP-IR4BE71', '110', '1024', '768', 'luckype53', '(주)럭키펫유통[박영원]', '187009624545' )