========================2019-08-21 08:34:19======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41D791768C7CAFB sCDKey = 852599218062 sName = OKPOS ========================2019-08-21 08:34: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 = '852599218062' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-21 08:34:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sd3022' ========================2019-08-21 08:34:19======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41D791768C7CAFB' AND app_code = '046' ========================2019-08-21 08:34:19======================== 값이 없을 경우 ========================2019-08-21 09:18:59======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41D791768C7CAFB sCDKey = 852599218062 sName = OKPOS ========================2019-08-21 09:18: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 = '852599218062' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-21 09:18:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sd3022' ========================2019-08-21 09:18:59======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41D791768C7CAFB' AND app_code = '046' ========================2019-08-21 09:18:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293631' ========================2019-08-21 09:18:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293631' ========================2019-08-21 09:18:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293631', '68EDA41D791768C7CAFB', '046', 'OKPOS', '110', '1024', '768', 'sd3022', '성도물산[곽효신]', '852599218062' ) ========================2019-08-21 11:04:01======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-90KLRF4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7470FDF2061106346F3F sCDKey = 853979398456 sName = DESKTOP-90KLRF4 ========================2019-08-21 11:04:01======================== 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 = '853979398456' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-21 11:04:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdy3445' ========================2019-08-21 11:04:01======================== SELECT idx FROM macs WHERE mac_addr = '7470FDF2061106346F3F' AND app_code = '047' ========================2019-08-21 11:04:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293641' ========================2019-08-21 11:04:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293641' ========================2019-08-21 11:04:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293641', '7470FDF2061106346F3F', '047', 'DESKTOP-90KLRF4', '�쐢�룄�슦 10', '0', '0', 'kdy3445', '[대원]', '853979398456' ) ========================2019-08-21 11:37:05======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6ADDDCE9CFC726 sCDKey = 622573243408 sName = USER-PC ========================2019-08-21 11:37:05======================== 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 = '622573243408' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-21 11:37:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hadang' ========================2019-08-21 11:37:05======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6ADDDCE9CFC726' AND app_code = '046' ========================2019-08-21 11:37:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293657' ========================2019-08-21 11:37:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293657' ========================2019-08-21 11:37:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293657', 'E8039A6ADDDCE9CFC726', '046', 'USER-PC', '90', '1920', '1080', 'hadang', '하당그릇주방백화점[강미숙]', '622573243408' ) ========================2019-08-21 11:44:27======================== noteurl_start parm_app_code = 046 parm_pc_name = ULT-20170711HYQ parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30ED98826690F468 sCDKey = 622573243408 sName = ULT-20170711HYQ ========================2019-08-21 11:44:27======================== 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 = '622573243408' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-21 11:44:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hadang' ========================2019-08-21 11:44:27======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30ED98826690F468' AND app_code = '046' ========================2019-08-21 11:44:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293660' ========================2019-08-21 11:44:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293660' ========================2019-08-21 11:44:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293660', 'F44D30ED98826690F468', '046', 'ULT-20170711HYQ', '90', '1920', '1080', 'hadang', '하당그릇주방백화점[강미숙]', '622573243408' ) ========================2019-08-21 11:44:31======================== noteurl_start parm_app_code = 046 parm_pc_name = ULT-20170711HYQ parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30ED98826690F468 sCDKey = 622573243408 sName = ULT-20170711HYQ ========================2019-08-21 11:44: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 = '622573243408' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-21 13:44:02======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 629E205241538680B135 sCDKey = 094557491133 sName = SAMSUNG ========================2019-08-21 13:44: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 = '094557491133' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-21 13:44:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'techyh' ========================2019-08-21 13:44:02======================== SELECT idx FROM macs WHERE mac_addr = '629E205241538680B135' AND app_code = '039' ========================2019-08-21 13:44:02======================== 값이 없을 경우 ========================2019-08-21 13:44:29======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 629E205241538680B135 sCDKey = 094557491133 sName = SAMSUNG ========================2019-08-21 13:44: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 = '094557491133' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-21 13:44:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'techyh' ========================2019-08-21 13:44:29======================== SELECT idx FROM macs WHERE mac_addr = '629E205241538680B135' AND app_code = '039' ========================2019-08-21 13:44:29======================== 값이 없을 경우 ========================2019-08-21 13:44:56======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 629E205241538680B135 sCDKey = 094557491133 sName = SAMSUNG ========================2019-08-21 13:44:56======================== 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 = '094557491133' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-21 13:44:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'techyh' ========================2019-08-21 13:44:56======================== SELECT idx FROM macs WHERE mac_addr = '629E205241538680B135' AND app_code = '039' ========================2019-08-21 13:44:56======================== 값이 없을 경우 ========================2019-08-21 13:53:36======================== noteurl_start parm_app_code = 039 parm_pc_name = USER1-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E988C9AD025C110 sCDKey = 203810624338 sName = USER1-PC ========================2019-08-21 13:53:36======================== 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 = '203810624338' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-21 13:53:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yey1755' ========================2019-08-21 13:53:36======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E988C9AD025C110' AND app_code = '039' ========================2019-08-21 13:53:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293674' ========================2019-08-21 13:53:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293674' ========================2019-08-21 13:53:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293674', 'E0D55E988C9AD025C110', '039', 'USER1-PC', '90', '1920', '1080', 'yey1755', '무주콘크리트[이은영]', '203810624338' ) ========================2019-08-21 15:02:44======================== noteurl_start parm_app_code = 039 parm_pc_name = USER001 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = FCAA14674665EE941D95 sCDKey = 203810624338 sName = USER001 ========================2019-08-21 15:02: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 = '203810624338' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-21 15:02:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yey1755' ========================2019-08-21 15:02:44======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14674665EE941D95' AND app_code = '039' ========================2019-08-21 15:02:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '195622' ========================2019-08-21 15:02:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '195622' ========================2019-08-21 15:02:44======================== UPDATE mac_detail SET pc_name = 'USER001', os_type = '90', user_id = 'yey1755', user_name = '무주콘크리트[이은영]', screen_w = '1680', screen_h = '1050', cdkey = '203810624338' WHERE mac_idx = '195622' ========================2019-08-21 15:02:48======================== noteurl_start parm_app_code = 039 parm_pc_name = USER001 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = FCAA14674665EE941D95 sCDKey = 203810624338 sName = USER001 ========================2019-08-21 15:02: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 = '203810624338' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-21 15:29:55======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-2H6F2GCCFL4 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001377CDDDD9B891E380 sCDKey = 888849377565 sName = WIN-2H6F2GCCFL4 ========================2019-08-21 15:29:55======================== 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 = '888849377565' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-21 15:29:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jn23672' ========================2019-08-21 15:29:55======================== SELECT idx FROM macs WHERE mac_addr = '001377CDDDD9B891E380' AND app_code = '039' ========================2019-08-21 15:29:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293686' ========================2019-08-21 15:29:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293686' ========================2019-08-21 15:29:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293686', '001377CDDDD9B891E380', '039', 'WIN-2H6F2GCCFL4', '90', '1920', '1080', 'jn23672', '전남사무기[박성일]', '888849377565' ) ========================2019-08-21 15:30:10======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-2H6F2GCCFL4 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001377CDDDD9B891E380 sCDKey = 888849377565 sName = WIN-2H6F2GCCFL4 ========================2019-08-21 15:30: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 = '888849377565' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-21 17:12:37======================== noteurl_start parm_app_code = 046 parm_pc_name = DANJI_POS_MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F48E389BBF47E86BE1B5 sCDKey = 916970945314 sName = DANJI_POS_MAIN ========================2019-08-21 17:12: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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-21 17:12:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2019-08-21 17:12:37======================== SELECT idx FROM macs WHERE mac_addr = 'F48E389BBF47E86BE1B5' AND app_code = '046' ========================2019-08-21 17:12:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290169' ========================2019-08-21 17:12:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290169' ========================2019-08-21 17:12:37======================== UPDATE mac_detail SET pc_name = 'DANJI_POS_MAIN', os_type = '110', user_id = 'danjinail', user_name = '단지네네일가게[임재완]', screen_w = '1920', screen_h = '1080', cdkey = '916970945314' WHERE mac_idx = '290169'