========================2018-04-17 09:12:57======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-UC5GCVJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 0030676B307CAC253935 sCDKey = 568955314109 sName = DESKTOP-UC5GCVJ ========================2018-04-17 09:12: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 = '568955314109' AND r.app_code = '047' AND r.app_block = 0 ========================2018-04-17 09:12:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ria8210' ========================2018-04-17 09:12:57======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307CAC253935' AND app_code = '047' ========================2018-04-17 09:12:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247432' ========================2018-04-17 09:12:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247432' ========================2018-04-17 09:12: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 ( '247432', '0030676B307CAC253935', '047', 'DESKTOP-UC5GCVJ', '�쐢�룄�슦 10', '0', '0', 'ria8210', '미진소프트[김민정]', '568955314109' ) ========================2018-04-17 14:48:41======================== noteurl_start parm_app_code = 046 parm_pc_name = U200-경태 parm_os_type = 90 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 002454903BBEE21CA926 sCDKey = 343408108095 sName = U200-경태 ========================2018-04-17 14:48:41======================== 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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-17 14:49:34======================== noteurl_start parm_app_code = 046 parm_pc_name = U200-경태 parm_os_type = 90 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 002454903BBEE21CA926 sCDKey = 343408108095 sName = U200-경태 ========================2018-04-17 14:49:34======================== 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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-17 14:49:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rain1479' ========================2018-04-17 14:49:34======================== SELECT idx FROM macs WHERE mac_addr = '002454903BBEE21CA926' AND app_code = '046' ========================2018-04-17 14:49:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '217568' ========================2018-04-17 14:49:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '217568' ========================2018-04-17 14:49:34======================== UPDATE mac_detail SET pc_name = 'U200-경태', os_type = '90', user_id = 'rain1479', user_name = '한영사[고경태]', screen_w = '2560', screen_h = '1080', cdkey = '343408108095' WHERE mac_idx = '217568' ========================2018-04-17 14:51:50======================== noteurl_start parm_app_code = 046 parm_pc_name = DM700 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039AF3480424659202 sCDKey = 343408108095 sName = DM700 ========================2018-04-17 14:51:50======================== 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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-17 14:51:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rain1479' ========================2018-04-17 14:51:50======================== SELECT idx FROM macs WHERE mac_addr = 'E8039AF3480424659202' AND app_code = '046' ========================2018-04-17 14:51:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '217579' ========================2018-04-17 14:51:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '217579' ========================2018-04-17 14:51:50======================== UPDATE mac_detail SET pc_name = 'DM700', os_type = '90', user_id = 'rain1479', user_name = '한영사[고경태]', screen_w = '1920', screen_h = '1080', cdkey = '343408108095' WHERE mac_idx = '217579' ========================2018-04-17 16:27:38======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = BC5FF470F03E2C3899D2 sCDKey = 699676022619 sName = USER ========================2018-04-17 16:27: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 = '699676022619' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-17 16:27:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ko613200' ========================2018-04-17 16:27:38======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF470F03E2C3899D2' AND app_code = '039' ========================2018-04-17 16:27:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247499' ========================2018-04-17 16:27:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247499' ========================2018-04-17 16:27:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247499', 'BC5FF470F03E2C3899D2', '039', 'USER', '90', '1680', '1050', 'ko613200', '대경산업[이숙자]', '699676022619' ) ========================2018-04-17 19:37: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 = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-17 19:37: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 ========================2018-04-17 19:37:11======================== 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 = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-17 19:37:11======================== 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-04-17 19:37:53======================== 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 = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-17 19:37:53======================== 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-04-17 19:42: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 = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-17 19:42: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