========================2019-08-09 10:04:33======================== noteurl_start parm_app_code = 047 parm_pc_name = POS1 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 382C4A6425DB3226DAE4 sCDKey = 204297080946 sName = POS1 ========================2019-08-09 10:04:33======================== 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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-09 10:04:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2019-08-09 10:04:33======================== SELECT idx FROM macs WHERE mac_addr = '382C4A6425DB3226DAE4' AND app_code = '047' ========================2019-08-09 10:04:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292805' ========================2019-08-09 10:04:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292805' ========================2019-08-09 10:04:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292805', '382C4A6425DB3226DAE4', '047', 'POS1', '�쐢�룄�슦 7', '0', '0', 'ulsanwood', '연암철물공구종합상사[박동진]', '204297080946' ) ========================2019-08-09 10:09:45======================== noteurl_start parm_app_code = 047 parm_pc_name = WOODPROMAIN-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 107B449105A084CE2360 sCDKey = 204297080946 sName = WOODPROMAIN-PC ========================2019-08-09 10:09: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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-09 10:09:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2019-08-09 10:09:45======================== SELECT idx FROM macs WHERE mac_addr = '107B449105A084CE2360' AND app_code = '047' ========================2019-08-09 10:09:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292806' ========================2019-08-09 10:09:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292806' ========================2019-08-09 10:09: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 ( '292806', '107B449105A084CE2360', '047', 'WOODPROMAIN-PC', '�쐢�룄�슦 7', '0', '0', 'ulsanwood', '연암철물공구종합상사[박동진]', '204297080946' ) ========================2019-08-09 10:10:48======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7SAAJOA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 70C94E7935FF6A3EDE06 sCDKey = 204297080946 sName = DESKTOP-7SAAJOA ========================2019-08-09 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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-09 10:40:51======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-01 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 54BEF7036885DC527AAD sCDKey = 539797548865 sName = WIN7-01 ========================2019-08-09 10:40:51======================== 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 = '539797548865' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 10:40:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'doowonhub' ========================2019-08-09 10:40:51======================== SELECT idx FROM macs WHERE mac_addr = '54BEF7036885DC527AAD' AND app_code = '039' ========================2019-08-09 10:40:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292810' ========================2019-08-09 10:40:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292810' ========================2019-08-09 10:40:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292810', '54BEF7036885DC527AAD', '039', 'WIN7-01', '90', '1680', '1050', 'doowonhub', '두원정공[황운병]', '539797548865' ) ========================2019-08-09 10:54:26======================== noteurl_start parm_app_code = 047 parm_pc_name = POS2 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 382C4A64255C0CDE1A67 sCDKey = 204297080946 sName = POS2 ========================2019-08-09 10:54:26======================== 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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-09 10:54:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2019-08-09 10:54:26======================== SELECT idx FROM macs WHERE mac_addr = '382C4A64255C0CDE1A67' AND app_code = '047' ========================2019-08-09 10:54:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292811' ========================2019-08-09 10:54:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292811' ========================2019-08-09 10:54:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292811', '382C4A64255C0CDE1A67', '047', 'POS2', '�쐢�룄�슦 7', '0', '0', 'ulsanwood', '연암철물공구종합상사[박동진]', '204297080946' ) ========================2019-08-09 11:11:29======================== 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 = 50AF732F0866EE2B1141 sCDKey = 259919258729 sName = DESKTOP-IR4BE71 ========================2019-08-09 11:11: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 = '259919258729' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-09 11:11:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pes9399' ========================2019-08-09 11:11:29======================== SELECT idx FROM macs WHERE mac_addr = '50AF732F0866EE2B1141' AND app_code = '046' ========================2019-08-09 11:11:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292814' ========================2019-08-09 11:11:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292814' ========================2019-08-09 11:11:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292814', '50AF732F0866EE2B1141', '046', 'DESKTOP-IR4BE71', '110', '1024', '768', 'pes9399', '해마수산[오재순]', '259919258729' ) ========================2019-08-09 13:35:30======================== noteurl_start parm_app_code = 047 parm_pc_name = POS1 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 88366CF4426D3226DAE4 sCDKey = 204297080946 sName = POS1 ========================2019-08-09 13:35:30======================== 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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-09 13:35:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2019-08-09 13:35:30======================== SELECT idx FROM macs WHERE mac_addr = '88366CF4426D3226DAE4' AND app_code = '047' ========================2019-08-09 13:35:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292822' ========================2019-08-09 13:35:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292822' ========================2019-08-09 13:35:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292822', '88366CF4426D3226DAE4', '047', 'POS1', '�쐢�룄�슦 7', '0', '0', 'ulsanwood', '연암철물공구종합상사[박동진]', '204297080946' ) ========================2019-08-09 15:43:29======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = ACE0108CAAAA4C790851 sCDKey = 756579625871 sName = USER-PC ========================2019-08-09 15:43: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 = '756579625871' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 15:43:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youn7296' ========================2019-08-09 15:43:29======================== SELECT idx FROM macs WHERE mac_addr = 'ACE0108CAAAA4C790851' AND app_code = '039' ========================2019-08-09 15:43:29======================== 값이 없을 경우 ========================2019-08-09 15:43:40======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = ACE0108CAAAA4C790851 sCDKey = 756579625871 sName = USER-PC ========================2019-08-09 15:43: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 = '756579625871' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 15:43:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youn7296' ========================2019-08-09 15:43:40======================== SELECT idx FROM macs WHERE mac_addr = 'ACE0108CAAAA4C790851' AND app_code = '039' ========================2019-08-09 15:43:40======================== 값이 없을 경우 ========================2019-08-09 16:53:18======================== noteurl_start parm_app_code = 045 parm_pc_name = WIN-0PGEI61G95T parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002354A3B206705DE530 sCDKey = 244076831899 sName = WIN-0PGEI61G95T ========================2019-08-09 16:53:18======================== 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 = '244076831899' AND r.app_code = '045' AND r.app_block = 0 ========================2019-08-09 16:53:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hohoinja' ========================2019-08-09 16:53:18======================== SELECT idx FROM macs WHERE mac_addr = '002354A3B206705DE530' AND app_code = '045' ========================2019-08-09 16:53:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292850' ========================2019-08-09 16:53:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292850' ========================2019-08-09 16:53:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292850', '002354A3B206705DE530', '045', 'WIN-0PGEI61G95T', '90', '1920', '1080', 'hohoinja', '세명컴퓨터[김동현]', '244076831899' ) ========================2019-08-09 17:42:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:42:35======================== 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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:42:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:42:35======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:42:35======================== 값이 없을 경우 ========================2019-08-09 17:43:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:43:09======================== 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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:43:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:43:09======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:43:09======================== 값이 없을 경우 ========================2019-08-09 17:44:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:44: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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:44:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:44:54======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:44:54======================== 값이 없을 경우 ========================2019-08-09 17:46:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:46:28======================== 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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:46:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:46:28======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:46:28======================== 값이 없을 경우 ========================2019-08-09 17:54:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:54:42======================== 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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:54:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:54:42======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:54:42======================== 값이 없을 경우 ========================2019-08-09 17:54:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:54: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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:54:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:54:46======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:54:46======================== 값이 없을 경우 ========================2019-08-09 17:55:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:55: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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:55:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:55:38======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:55:38======================== 값이 없을 경우 ========================2019-08-09 17:55:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:55: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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:55:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:55:44======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:55:44======================== 값이 없을 경우 ========================2019-08-09 17:57:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:57:33======================== 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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:57:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:57:33======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:57:33======================== 값이 없을 경우 ========================2019-08-09 17:57:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:57:35======================== 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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:57:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:57:35======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:57:35======================== 값이 없을 경우 ========================2019-08-09 17:58:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SDM59S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4AC205241534AD24B24 sCDKey = 657978898709 sName = DESKTOP-5SDM59S ========================2019-08-09 17:58: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 = '657978898709' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-09 17:58:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hoon1004' ========================2019-08-09 17:58:47======================== SELECT idx FROM macs WHERE mac_addr = 'F4AC205241534AD24B24' AND app_code = '039' ========================2019-08-09 17:58:47======================== 값이 없을 경우 ========================2019-08-09 18:29:00======================== noteurl_start parm_app_code = 051 parm_pc_name = USER parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389DD87B4621CE287 sCDKey = 058323762427 sName = server ========================2019-08-09 18:29: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 = '058323762427' AND r.app_code = '051' AND r.app_block = 0 ========================2019-08-09 18:29:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'multicampus' ========================2019-08-09 18:29:00======================== SELECT idx FROM macs WHERE mac_addr = '988389DD87B4621CE287' AND app_code = '051' ========================2019-08-09 18:29:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292871' ========================2019-08-09 18:29:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292871' ========================2019-08-09 18:29: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 ( '292871', '988389DD87B4621CE287', '051', 'server', '109', '1920', '1080', 'multicampus', '멀티캠퍼스 역삼[권영석]', '058323762427' ) ========================2019-08-09 18:33:57======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389DD461DEA42F54E sCDKey = 058323762427 sName = DESKTOP ========================2019-08-09 18:33: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 = '058323762427' AND r.app_code = '051' AND r.app_block = 0 ========================2019-08-09 18:33:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'multicampus' ========================2019-08-09 18:33:57======================== SELECT idx FROM macs WHERE mac_addr = '988389DD461DEA42F54E' AND app_code = '051' ========================2019-08-09 18:33:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291148' ========================2019-08-09 18:33:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291148' ========================2019-08-09 18:33:57======================== UPDATE mac_detail SET pc_name = 'DESKTOP', os_type = '109', user_id = 'multicampus', user_name = '멀티캠퍼스 역삼[권영석]', screen_w = '1920', screen_h = '1080', cdkey = '058323762427' WHERE mac_idx = '291148'