========================2018-12-03 10:26:00======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-1I5ES62 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 794338922709 sName = DESKTOP-1I5ES62 ========================2018-12-03 10:26: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 = '794338922709' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-03 10:26:15======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-1I5ES62 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 794338922709 sName = DESKTOP-1I5ES62 ========================2018-12-03 10:26:15======================== 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 = '794338922709' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-03 10:26:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-03 10:26:15======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '046' ========================2018-12-03 10:26:15======================== 값이 없을 경우 ========================2018-12-03 10:27:04======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-1I5ES62 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 0030676B307C92E57388 sCDKey = 428708250736 sName = DESKTOP-1I5ES62 ========================2018-12-03 10:27:04======================== 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 = '428708250736' AND r.app_code = '047' AND r.app_block = 0 ========================2018-12-03 10:27:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-03 10:27:04======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '047' ========================2018-12-03 10:27:04======================== 값이 없을 경우 ========================2018-12-03 13:15:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1I5ES62 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 513185320426 sName = DESKTOP-1I5ES62 ========================2018-12-03 13:15: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 = '513185320426' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 13:15:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-03 13:15:30======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '039' ========================2018-12-03 13:15:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269693' ========================2018-12-03 13:15:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269693' ========================2018-12-03 13:15: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 ( '269693', '0030676B307C92E57388', '039', 'DESKTOP-1I5ES62', '110', '1920', '1080', 'lys0121', '[이윤솔]', '513185320426' ) ========================2018-12-03 13:31:37======================== noteurl_start parm_app_code = 046 parm_pc_name = H-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = D050999ADE7CBA388392 sCDKey = 262318519570 sName = H-PC ========================2018-12-03 13:31:37======================== 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 = '262318519570' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-03 13:31:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssjj0099' ========================2018-12-03 13:31:37======================== SELECT idx FROM macs WHERE mac_addr = 'D050999ADE7CBA388392' AND app_code = '046' ========================2018-12-03 13:31:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269716' ========================2018-12-03 13:31:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269716' ========================2018-12-03 13:31:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '269716', 'D050999ADE7CBA388392', '046', 'H-PC', '90', '1366', '768', 'ssjj0099', '승진펫유통[이승진]', '262318519570' ) ========================2018-12-03 14:56:10======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E8039A1F33D62C3899D2 sCDKey = 552641487169 sName = USER ========================2018-12-03 14:56:10======================== 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 = '552641487169' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 14:56:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chosw65' ========================2018-12-03 14:56:10======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A1F33D62C3899D2' AND app_code = '039' ========================2018-12-03 14:56:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '233919' ========================2018-12-03 14:56:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '233919' ========================2018-12-03 14:56:10======================== UPDATE mac_detail SET pc_name = 'USER', os_type = '90', user_id = 'chosw65', user_name = '주신푸드[조성원]', screen_w = '1366', screen_h = '768', cdkey = '552641487169' WHERE mac_idx = '233919' ========================2018-12-03 15:13:53======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CLD8LI4 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 819 parm_user_mac = 1831BFB509F16DB5B1D sCDKey = 946982711543 sName = DESKTOP-CLD8LI4 ========================2018-12-03 15:13: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 = '946982711543' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-03 15:13:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ptrade' ========================2018-12-03 15:13:53======================== SELECT idx FROM macs WHERE mac_addr = '1831BFB509F16DB5B1D' AND app_code = '046' ========================2018-12-03 15:13:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269730' ========================2018-12-03 15:13:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269730' ========================2018-12-03 15:13:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '269730', '1831BFB509F16DB5B1D', '046', 'DESKTOP-CLD8LI4', '110', '1024', '819', 'ptrade', '유승상회[유영석]', '946982711543' ) ========================2018-12-03 15:32:52======================== noteurl_start parm_app_code = 039 parm_pc_name = 박영원-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 88366CF5AABF2805249A sCDKey = 455125924650 sName = 박영원-PC ========================2018-12-03 15:32:52======================== 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 = '455125924650' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 15:32:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'smsin2315' ========================2018-12-03 15:32:52======================== SELECT idx FROM macs WHERE mac_addr = '88366CF5AABF2805249A' AND app_code = '039' ========================2018-12-03 15:32:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269555' ========================2018-12-03 15:32:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269555' ========================2018-12-03 15:32:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '269555', '88366CF5AABF2805249A', '039', '박영원-PC', '90', '1600', '900', 'smsin2315', '소하리어탕국수[신수문]', '455125924650' ) ========================2018-12-03 15:33:11======================== noteurl_start parm_app_code = 039 parm_pc_name = 박영원-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 88366CF5AABF2805249A sCDKey = 455125924650 sName = 박영원-PC ========================2018-12-03 15:33: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 = '455125924650' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:52:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = BC5FF41F1896 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:52: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 = 'BC5FF41F1896' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:52:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = BC5FF41F1896 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:52: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 = 'BC5FF41F1896' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:53:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:53:04======================== 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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:53:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:53: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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:53:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:53: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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:54:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:54: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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:55:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:55:12======================== 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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:55:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:55: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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 19:56:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 19:56: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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 20:02:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 20:02: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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 20:04:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 20:04: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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 20:05:10======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 20:05:10======================== 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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-03 20:06:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-03 20:06:16======================== 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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0