========================2022-01-24 08:21:34======================== noteurl_start parm_app_code = 039 parm_pc_name = 사모님 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0862669EA6316AE39184 sCDKey = 210742859361 sName = 사모님 ========================2022-01-24 08:21:34======================== 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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-24 08:21:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2022-01-24 08:21:34======================== SELECT idx FROM macs WHERE mac_addr = '0862669EA6316AE39184' AND app_code = '039' ========================2022-01-24 08:21:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312799' ========================2022-01-24 08:21:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312799' ========================2022-01-24 08:21:34======================== UPDATE mac_detail SET pc_name = '사모님', os_type = '110', user_id = 'julee37', user_name = '개성자바라, 스텐나라[이순녀]', screen_w = '1680', screen_h = '1050', cdkey = '210742859361' WHERE mac_idx = '312799' ========================2022-01-24 08:58:25======================== noteurl_start parm_app_code = 039 parm_pc_name = 서남OA-1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D85ED36F702A1A0A5C91 sCDKey = 475472069663 sName = 서남OA-1 ========================2022-01-24 08:58: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 = '475472069663' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-24 08:58:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'azit0380' ========================2022-01-24 08:58:25======================== SELECT idx FROM macs WHERE mac_addr = 'D85ED36F702A1A0A5C91' AND app_code = '039' ========================2022-01-24 08:58:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359829' ========================2022-01-24 08:58:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359829' ========================2022-01-24 08:58:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359829', 'D85ED36F702A1A0A5C91', '039', '서남OA-1', '110', '1920', '1080', 'azit0380', '서남OA[한성동]', '475472069663' ) ========================2022-01-24 08:58:30======================== noteurl_start parm_app_code = 039 parm_pc_name = 서남OA-1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D85ED36F702A1A0A5C91 sCDKey = 475472069663 sName = 서남OA-1 ========================2022-01-24 08:58: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 = '475472069663' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-24 09:47:41======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF7328C8C25A0E160A sCDKey = 034322302191 sName = POS ========================2022-01-24 09:47:41======================== 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 = '034322302191' AND r.app_code = '046' AND r.app_block = 0 ========================2022-01-24 09:47:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yujung6852' ========================2022-01-24 09:47:41======================== SELECT idx FROM macs WHERE mac_addr = '50AF7328C8C25A0E160A' AND app_code = '046' ========================2022-01-24 09:47:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320036' ========================2022-01-24 09:47:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320036' ========================2022-01-24 09:47:41======================== UPDATE mac_detail SET pc_name = 'POS', os_type = '90', user_id = 'yujung6852', user_name = '(주)유정배관[윤경환]', screen_w = '1024', screen_h = '768', cdkey = '034322302191' WHERE mac_idx = '320036' ========================2022-01-24 09:48:16======================== noteurl_start parm_app_code = 039 parm_pc_name = AL220122 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D85ED373D66630EC7AE2 sCDKey = 720357298336 sName = AL220122 ========================2022-01-24 09:48: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 = '720357298336' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-24 09:48:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'almoco7844' ========================2022-01-24 09:48:16======================== SELECT idx FROM macs WHERE mac_addr = 'D85ED373D66630EC7AE2' AND app_code = '039' ========================2022-01-24 09:48:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359929' ========================2022-01-24 09:48:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359929' ========================2022-01-24 09:48:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359929', 'D85ED373D66630EC7AE2', '039', 'AL220122', '110', '1920', '1080', 'almoco7844', '(주)알모코[배한숙]', '720357298336' ) ========================2022-01-24 11:54:35======================== noteurl_start parm_app_code = 047 parm_pc_name = 한동진 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 64E599FB3E060A5DC0D8 sCDKey = 811321944734 sName = 머진머진 ========================2022-01-24 11:54: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 = '811321944734' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-24 11:54:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bestseller12' ========================2022-01-24 11:54:35======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E060A5DC0D8' AND app_code = '047' ========================2022-01-24 11:54:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223850' ========================2022-01-24 11:54:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223850' ========================2022-01-24 11:54:35======================== UPDATE mac_detail SET pc_name = '머진머진', os_type = '�쐢�룄�슦 10', user_id = 'bestseller12', user_name = 'AZ입맛[한동진]', screen_w = '0', screen_h = '0', cdkey = '811321944734' WHERE mac_idx = '223850' ========================2022-01-24 13:32:56======================== noteurl_start parm_app_code = 050 parm_pc_name = 77T01630-PC parm_os_type = 109 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 98838984CA79E8A07A9C sCDKey = 774093020602 sName = blc2012 ========================2022-01-24 13:32: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 = '774093020602' AND r.app_code = '050' AND r.app_block = 0 ========================2022-01-24 13:32:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2012' ========================2022-01-24 13:32:56======================== SELECT idx FROM macs WHERE mac_addr = '98838984CA79E8A07A9C' AND app_code = '050' ========================2022-01-24 13:32:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359959' ========================2022-01-24 13:32:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359959' ========================2022-01-24 13:32:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359959', '98838984CA79E8A07A9C', '050', 'blc2012', '109', '2560', '1080', 'blc2012', '주식회사웅진[최성우]', '774093020602' ) ========================2022-01-24 14:07:57======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-6A23N28 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8BBC192E3E16AA9DCE1 sCDKey = 185317015328 sName = DESKTOP-6A23N28 ========================2022-01-24 14:07: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 = '185317015328' AND r.app_code = '046' AND r.app_block = 0 ========================2022-01-24 14:07:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lkj608' ========================2022-01-24 14:07:57======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC192E3E16AA9DCE1' AND app_code = '046' ========================2022-01-24 14:07:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359971' ========================2022-01-24 14:07:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359971' ========================2022-01-24 14:07:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359971', 'D8BBC192E3E16AA9DCE1', '046', 'DESKTOP-6A23N28', '110', '1920', '1080', 'lkj608', '레버스인터네셔널[이건재]', '185317015328' ) ========================2022-01-24 14:23:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0VF1DTN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 982CBCC5BC5520EE8F2A sCDKey = 151317336230 sName = DESKTOP-0VF1DTN ========================2022-01-24 14:23:06======================== 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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-24 14:23:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yessal' ========================2022-01-24 14:23:06======================== SELECT idx FROM macs WHERE mac_addr = '982CBCC5BC5520EE8F2A' AND app_code = '039' ========================2022-01-24 14:23:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359856' ========================2022-01-24 14:23:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359856' ========================2022-01-24 14:23:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359856', '982CBCC5BC5520EE8F2A', '039', 'DESKTOP-0VF1DTN', '110', '1920', '1080', 'yessal', '제이에스테크[심재섭]', '151317336230' ) ========================2022-01-24 15:00:20======================== noteurl_start parm_app_code = 039 parm_pc_name = PC-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E5931ADACE01D42 sCDKey = 623958680805 sName = PC-PC ========================2022-01-24 15:00:20======================== 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 = '623958680805' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-24 15:00:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hysu905' ========================2022-01-24 15:00:20======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E5931ADACE01D42' AND app_code = '039' ========================2022-01-24 15:00:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359975' ========================2022-01-24 15:00:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359975' ========================2022-01-24 15:00:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359975', 'E0D55E5931ADACE01D42', '039', 'PC-PC', '90', '1920', '1080', 'hysu905', '혜성산업[서성원]', '623958680805' ) ========================2022-01-24 16:24:27======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KQ46FUE parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 548CA047CB893A27F93A sCDKey = 148732382971 sName = DESKTOP-KQ46FUE ========================2022-01-24 16:24: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 = '148732382971' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-24 16:24:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjss2867' ========================2022-01-24 16:24:28======================== SELECT idx FROM macs WHERE mac_addr = '548CA047CB893A27F93A' AND app_code = '039' ========================2022-01-24 16:24:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359812' ========================2022-01-24 16:24:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359812' ========================2022-01-24 16:24:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359812', '548CA047CB893A27F93A', '039', 'DESKTOP-KQ46FUE', '110', '1536', '864', 'kjss2867', '정원푸드[공성호]', '148732382971' ) ========================2022-01-24 17:33:41======================== noteurl_start parm_app_code = 039 parm_pc_name = KIMHY parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 7085C20132047CC149B9 sCDKey = 271406049638 sName = KIMHY ========================2022-01-24 17:33:41======================== 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 = '271406049638' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-24 17:33:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qnc1426' ========================2022-01-24 17:33:41======================== SELECT idx FROM macs WHERE mac_addr = '7085C20132047CC149B9' AND app_code = '039' ========================2022-01-24 17:33:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '360000' ========================2022-01-24 17:33:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '360000' ========================2022-01-24 17:33:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '360000', '7085C20132047CC149B9', '039', 'KIMHY', '90', '1600', '900', 'qnc1426', '주식회사큐엔씨유통[남숙자]', '271406049638' )