========================2018-09-18 12:59:42======================== noteurl_start parm_app_code = 039 parm_pc_name = CHAN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A68ABD28A379DC6 sCDKey = msbd8a379dc6 sName = CHAN-PC ========================2018-09-18 12:59: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 = 'MSBD8A379DC6' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-18 13:07:26======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF7325BEC2A41C65F sCDKey = 429971320873 sName = USER-PC ========================2018-09-18 13:07: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 = '429971320873' AND r.app_code = '046' AND r.app_block = 0 ========================2018-09-18 13:07:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eunsook2700' ========================2018-09-18 13:07:26======================== SELECT idx FROM macs WHERE mac_addr = '50AF7325BEC2A41C65F' AND app_code = '046' ========================2018-09-18 13:07:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '202709' ========================2018-09-18 13:07:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '202709' ========================2018-09-18 13:07:26======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'eunsook2700', user_name = '쉐르홈즈[황은숙]', screen_w = '1024', screen_h = '768', cdkey = '429971320873' WHERE mac_idx = '202709' ========================2018-09-18 15:16:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FE7R8VG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4485005AE312DA9B2A92 sCDKey = 378087224489 sName = DESKTOP-FE7R8VG ========================2018-09-18 15:16: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 = '378087224489' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-18 15:16:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jyounger72' ========================2018-09-18 15:16:46======================== SELECT idx FROM macs WHERE mac_addr = '4485005AE312DA9B2A92' AND app_code = '039' ========================2018-09-18 15:16:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260339' ========================2018-09-18 15:16:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260339' ========================2018-09-18 15:16:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260339', '4485005AE312DA9B2A92', '039', 'DESKTOP-FE7R8VG', '110', '1920', '1080', 'jyounger72', 'Easy-M[이제영]', '378087224489' ) ========================2018-09-18 16:05:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2F27KD1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838982FEB4F60ADEE8 sCDKey = 831663810950 sName = DESKTOP-2F27KD1 ========================2018-09-18 16:05:13======================== 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 = '831663810950' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-18 16:05:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2F27KD1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838982FEB4F60ADEE8 sCDKey = 831663810950 sName = DESKTOP-2F27KD1 ========================2018-09-18 16:05: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 = '831663810950' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-18 16:05:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2F27KD1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838982FEB4F60ADEE8 sCDKey = 831663810950 sName = DESKTOP-2F27KD1 ========================2018-09-18 16:05: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 = '831663810950' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-18 16:09:30======================== noteurl_start parm_app_code = 046 parm_pc_name = STJ-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067BAEBDFB2760122 sCDKey = 298504286643 sName = STJ-PC ========================2018-09-18 16:09: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 = '298504286643' AND r.app_code = '046' AND r.app_block = 0 ========================2018-09-18 16:09:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdod123' ========================2018-09-18 16:09:30======================== SELECT idx FROM macs WHERE mac_addr = '003067BAEBDFB2760122' AND app_code = '046' ========================2018-09-18 16:09:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248418' ========================2018-09-18 16:09:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248418' ========================2018-09-18 16:09:30======================== UPDATE mac_detail SET pc_name = 'STJ-PC', os_type = '110', user_id = 'kdod123', user_name = '엠제이소프트[송태진]', screen_w = '1920', screen_h = '1080', cdkey = '298504286643' WHERE mac_idx = '248418' ========================2018-09-18 17:50:59======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC1-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BF4F7AE4FCC4D116 sCDKey = 467133605337 sName = POS-PC1-PC ========================2018-09-18 17:50:59======================== 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 = '467133605337' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:51:11======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC1-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BF4F7AE4FCC4D116 sCDKey = 467133605337 sName = POS-PC1-PC ========================2018-09-18 17:51: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 = '467133605337' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:51:24======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC1-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BF4F7AE4FCC4D116 sCDKey = 467133605337 sName = POS-PC1-PC ========================2018-09-18 17:51:24======================== 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 = '467133605337' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:51:57======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC1-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BF4F7AE4FCC4D116 sCDKey = 467133605337 sName = POS-PC1-PC ========================2018-09-18 17:51: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 = '467133605337' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:53:32======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC1-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BF4F7AE4FCC4D116 sCDKey = 467133605337 sName = POS-PC1-PC ========================2018-09-18 17:53: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 = '467133605337' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:53:58======================== noteurl_start parm_app_code = 047 parm_pc_name = USERPC-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E926E0A3E804110 sCDKey = 467133605337 sName = USERPC-PC ========================2018-09-18 17:53:58======================== 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 = '467133605337' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:54:59======================== noteurl_start parm_app_code = 047 parm_pc_name = USERPC-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E926E0A3E804110 sCDKey = 467133605337 sName = USERPC-PC ========================2018-09-18 17:54:59======================== 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 = '467133605337' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:56:31======================== noteurl_start parm_app_code = 047 parm_pc_name = USERPC-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E926E0A3E804110 sCDKey = 699644918905 sName = USERPC-PC ========================2018-09-18 17:56:31======================== 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 = '699644918905' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:56:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodnom35' ========================2018-09-18 17:56:31======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E926E0A3E804110' AND app_code = '047' ========================2018-09-18 17:56:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260369' ========================2018-09-18 17:56:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260369' ========================2018-09-18 17:56:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260369', 'E0D55E926E0A3E804110', '047', 'USERPC-PC', '�쐢�룄�슦 7', '0', '0', 'goodnom35', '일등식품[소인환]', '699644918905' ) ========================2018-09-18 17:58:48======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC1-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BF4F7AE4FCC4D116 sCDKey = 699644918905 sName = POS-PC1-PC ========================2018-09-18 17:58: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 = '699644918905' AND r.app_code = '047' AND r.app_block = 0 ========================2018-09-18 17:58:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodnom35' ========================2018-09-18 17:58:48======================== SELECT idx FROM macs WHERE mac_addr = '1831BF4F7AE4FCC4D116' AND app_code = '047' ========================2018-09-18 17:58:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260368' ========================2018-09-18 17:58:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260368' ========================2018-09-18 17:58: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 ( '260368', '1831BF4F7AE4FCC4D116', '047', 'POS-PC1-PC', '�쐢�룄�슦 7', '0', '0', 'goodnom35', '일등식품[소인환]', '699644918905' ) ========================2018-09-18 23:51:11======================== noteurl_start parm_app_code = 036 parm_pc_name = SHIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080\\0 parm_user_mac = D0509907215580410586 sCDKey = 880902040536 sName = SHIN-PC ========================2018-09-18 23:51: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 = '880902040536' AND r.app_code = '036' AND r.app_block = 0 ========================2018-09-18 23:51:17======================== noteurl_start parm_app_code = 036 parm_pc_name = SHIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080\\0 parm_user_mac = D0509907215580410586 sCDKey = 353156156106 sName = SHIN-PC ========================2018-09-18 23:51:17======================== 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 = '353156156106' AND r.app_code = '036' AND r.app_block = 0 ========================2018-09-18 23:51:25======================== noteurl_start parm_app_code = 036 parm_pc_name = SHIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080\\0 parm_user_mac = D0509907215580410586 sCDKey = 786742787828 sName = SHIN-PC ========================2018-09-18 23:51:25======================== 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 = '786742787828' AND r.app_code = '036' AND r.app_block = 0 ========================2018-09-18 23:51:28======================== noteurl_start parm_app_code = 036 parm_pc_name = SHIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080\\0 parm_user_mac = D0509907215580410586 sCDKey = 786747837376 sName = SHIN-PC ========================2018-09-18 23:51: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 = '786747837376' AND r.app_code = '036' AND r.app_block = 0 ========================2018-09-18 23:51:33======================== noteurl_start parm_app_code = 036 parm_pc_name = SHIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080\\0 parm_user_mac = D0509907215580410586 sCDKey = 546549643945 sName = SHIN-PC ========================2018-09-18 23:51: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 = '546549643945' AND r.app_code = '036' AND r.app_block = 0 ========================2018-09-18 23:51:38======================== noteurl_start parm_app_code = 036 parm_pc_name = SHIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080\\0 parm_user_mac = D0509907215580410586 sCDKey = 516551656565 sName = SHIN-PC ========================2018-09-18 23:51: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 = '516551656565' AND r.app_code = '036' AND r.app_block = 0