========================2018-04-27 10:03:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7I0P53C parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 0CD29251720596BB3561 sCDKey = 375793982983 sName = DESKTOP-7I0P53C ========================2018-04-27 10:03: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 = '375793982983' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-27 10:03:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goldman' ========================2018-04-27 10:03:32======================== SELECT idx FROM macs WHERE mac_addr = '0CD29251720596BB3561' AND app_code = '039' ========================2018-04-27 10:03:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248394' ========================2018-04-27 10:03:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248394' ========================2018-04-27 10:03: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 ( '248394', '0CD29251720596BB3561', '039', 'DESKTOP-7I0P53C', '110', '1600', '900', 'goldman', '동양금박분공업사[구종서]', '375793982983' ) ========================2018-04-27 10:03:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7I0P53C parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 0CD29251720596BB3561 sCDKey = 375793982983 sName = DESKTOP-7I0P53C ========================2018-04-27 10:03:40======================== 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 = '375793982983' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-27 10:25:44======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E81132399CD1E42E1FC3 sCDKey = 097696787204 sName = SEC-PC ========================2018-04-27 10:25:44======================== 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 = '097696787204' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-27 10:25:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'st0366' ========================2018-04-27 10:25:44======================== SELECT idx FROM macs WHERE mac_addr = 'E81132399CD1E42E1FC3' AND app_code = '039' ========================2018-04-27 10:25:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248400' ========================2018-04-27 10:25:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248400' ========================2018-04-27 10:25:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248400', 'E81132399CD1E42E1FC3', '039', 'SEC-PC', '90', '1680', '1050', 'st0366', '성태산업[권성태]', '097696787204' ) ========================2018-04-27 13:27:14======================== noteurl_start parm_app_code = 046 parm_pc_name = HHY-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9B7922E87FB70 sCDKey = 871488702905 sName = HHY-PC ========================2018-04-27 13:27: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 = '871488702905' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-27 13:27:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hhy111' ========================2018-04-27 13:27:14======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7922E87FB70' AND app_code = '046' ========================2018-04-27 13:27:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248431' ========================2018-04-27 13:27:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248431' ========================2018-04-27 13:27:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248431', 'F44D30B9B7922E87FB70', '046', 'HHY-PC', '110', '1920', '1080', 'hhy111', '[황희영]', '871488702905' ) ========================2018-04-27 15:00:48======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C26D73FCB320E4 sCDKey = 773768322592 sName = WIN7-PC ========================2018-04-27 15:00: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 = '773768322592' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-27 15:00:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'andi1102' ========================2018-04-27 15:00:48======================== SELECT idx FROM macs WHERE mac_addr = '7085C26D73FCB320E4' AND app_code = '039' ========================2018-04-27 15:00:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248442' ========================2018-04-27 15:00:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248442' ========================2018-04-27 15:00: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 ( '248442', '7085C26D73FCB320E4', '039', 'WIN7-PC', '90', '1920', '1080', 'andi1102', '(주)탑메디칼컴퍼니[정성욱]', '773768322592' )