========================2019-12-17 09:03:39======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-G5M8OUR parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00D861BB5D7A3C61FED4 sCDKey = 375489053204 sName = DESKTOP-G5M8OUR ========================2019-12-17 09:03:39======================== 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 = '375489053204' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-17 09:03:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'myungsin2841' ========================2019-12-17 09:03:39======================== SELECT idx FROM macs WHERE mac_addr = '00D861BB5D7A3C61FED4' AND app_code = '046' ========================2019-12-17 09:03:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305608' ========================2019-12-17 09:03:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '305608' ========================2019-12-17 09:03:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '305608', '00D861BB5D7A3C61FED4', '046', 'DESKTOP-G5M8OUR', '110', '1280', '1024', 'myungsin2841', '명신종합상사[한순옥]', '375489053204' ) ========================2019-12-17 09:07:32======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-TMLALES parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00D861BF842868520423 sCDKey = 375489053204 sName = DESKTOP-TMLALES ========================2019-12-17 09:07: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 = '375489053204' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-17 09:07:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'myungsin2841' ========================2019-12-17 09:07:32======================== SELECT idx FROM macs WHERE mac_addr = '00D861BF842868520423' AND app_code = '046' ========================2019-12-17 09:07:32======================== 값이 없을 경우 ========================2019-12-17 09:09:02======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-TMLALES parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00D861BF842868520423 sCDKey = 375489053204 sName = DESKTOP-TMLALES ========================2019-12-17 09:09:02======================== 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 = '375489053204' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-17 09:09:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'myungsin2841' ========================2019-12-17 09:09:02======================== SELECT idx FROM macs WHERE mac_addr = '00D861BF842868520423' AND app_code = '046' ========================2019-12-17 09:09:02======================== 값이 없을 경우 ========================2019-12-17 09:09:19======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-TMLALES parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00D861BF842868520423 sCDKey = 375489053204 sName = DESKTOP-TMLALES ========================2019-12-17 09:09: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 = '375489053204' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-17 09:09:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'myungsin2841' ========================2019-12-17 09:09:19======================== SELECT idx FROM macs WHERE mac_addr = '00D861BF842868520423' AND app_code = '046' ========================2019-12-17 09:09:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305609' ========================2019-12-17 09:09:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '305609' ========================2019-12-17 09:09: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 ( '305609', '00D861BF842868520423', '046', 'DESKTOP-TMLALES', '110', '1280', '1024', 'myungsin2841', '명신종합상사[한순옥]', '375489053204' ) ========================2019-12-17 14:25:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESK7 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E998C8135767FBED7 sCDKey = 985128471700 sName = DESK7 ========================2019-12-17 14:25:23======================== 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 = '985128471700' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-17 14:25:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'misyleejy' ========================2019-12-17 14:25:23======================== SELECT idx FROM macs WHERE mac_addr = 'B42E998C8135767FBED7' AND app_code = '039' ========================2019-12-17 14:25:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305658' ========================2019-12-17 14:25:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '305658' ========================2019-12-17 14:25:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '305658', 'B42E998C8135767FBED7', '039', 'DESK7', '90', '1920', '1080', 'misyleejy', '삼보티에스[이지연]', '985128471700' ) ========================2019-12-17 15:36:03======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732DEE2AEE2B1141 sCDKey = 230362309828 sName = 이동용 ========================2019-12-17 15:36:03======================== 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 = '230362309828' AND r.app_code = '047' AND r.app_block = 0 ========================2019-12-17 15:36:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jclocal' ========================2019-12-17 15:36:03======================== SELECT idx FROM macs WHERE mac_addr = '50AF732DEE2AEE2B1141' AND app_code = '047' ========================2019-12-17 15:36:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293125' ========================2019-12-17 15:36:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293125' ========================2019-12-17 15:36:03======================== UPDATE mac_detail SET pc_name = '이동용', os_type = '�쐢�룄�슦 10', user_id = 'jclocal', user_name = '제천로컬푸드협동조합[김현주]', screen_w = '0', screen_h = '0', cdkey = '230362309828' WHERE mac_idx = '293125'