========================2019-08-08 11:27:59======================== 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 = 50AF732F270FEE2B1141 sCDKey = 980975512827 sName = DESKTOP-IR4BE71 ========================2019-08-08 11:27: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 = '980975512827' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-08 11:27:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'asd4517' ========================2019-08-08 11:27:59======================== SELECT idx FROM macs WHERE mac_addr = '50AF732F270FEE2B1141' AND app_code = '047' ========================2019-08-08 11:27:59======================== 값이 없을 경우 ========================2019-08-08 11:32:38======================== 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 = 50AF732F6B2BEE2B1141 sCDKey = 980975512827 sName = 농가 프린터출력용 ========================2019-08-08 11:32: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 = '980975512827' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-08 11:32:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'asd4517' ========================2019-08-08 11:32:38======================== SELECT idx FROM macs WHERE mac_addr = '50AF732F6B2BEE2B1141' AND app_code = '047' ========================2019-08-08 11:32:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292717' ========================2019-08-08 11:32:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292717' ========================2019-08-08 11:32:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292717', '50AF732F6B2BEE2B1141', '047', '농가 프린터출력용', '�쐢�룄�슦 10', '0', '0', 'asd4517', '제천로컬푸드협동조합[이성일]', '980975512827' ) ========================2019-08-08 13:19:22======================== 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 = D850E6525947BCE6EC43 sCDKey = 714803774810 sName = USER1-PC ========================2019-08-08 13:19:22======================== 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 = '714803774810' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-08 13:19:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kshousing' ========================2019-08-08 13:19:22======================== SELECT idx FROM macs WHERE mac_addr = 'D850E6525947BCE6EC43' AND app_code = '039' ========================2019-08-08 13:19:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292729' ========================2019-08-08 13:19:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292729' ========================2019-08-08 13:19:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292729', 'D850E6525947BCE6EC43', '039', 'USER1-PC', '90', '1920', '1080', 'kshousing', '주식회사거성하우징[이재식]', '714803774810' ) ========================2019-08-08 13:37:33======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-NC90F1J parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 56831C0C0950665CCC46 sCDKey = 452858987096 sName = DESKTOP-NC90F1J ========================2019-08-08 13:37: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 = '452858987096' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-08 13:37:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumhwain88' ========================2019-08-08 13:37:33======================== SELECT idx FROM macs WHERE mac_addr = '56831C0C0950665CCC46' AND app_code = '050' ========================2019-08-08 13:37:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292731' ========================2019-08-08 13:37:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292731' ========================2019-08-08 13:37:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292731', '56831C0C0950665CCC46', '050', 'DESKTOP-NC90F1J', '109', '1920', '1080', 'kumhwain88', '한국예술종합학교[미술원]', '452858987096' ) ========================2019-08-08 13:37:42======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-NC90F1J parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 56831C0C0950665CCC46 sCDKey = 452858987096 sName = DESKTOP-NC90F1J ========================2019-08-08 13:37: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 = '452858987096' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-08 13:38:08======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-NC90F1J parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 56831C0C0950665CCC46 sCDKey = 452858987096 sName = DESKTOP-NC90F1J ========================2019-08-08 13:38:08======================== 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 = '452858987096' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-08 13:38:37======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-NC90F1J parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 56831C0C0950665CCC46 sCDKey = 452858987096 sName = DESKTOP-NC90F1J ========================2019-08-08 13:38: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 = '452858987096' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-08 15:21:29======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-2-190806 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E06F294936301A567F sCDKey = 975677425073 sName = POS-2-190806 ========================2019-08-08 15:21: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 15:21:57======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-2-190806 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E06F294936301A567F sCDKey = 975677425073 sName = POS-2-190806 ========================2019-08-08 15:21: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 15:21:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-08-08 15:21:57======================== SELECT idx FROM macs WHERE mac_addr = '00E06F294936301A567F' AND app_code = '046' ========================2019-08-08 15:21:57======================== 값이 없을 경우 ========================2019-08-08 15:22:25======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-2-190806 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E06F294936301A567F sCDKey = 975677425073 sName = POS-2-190806 ========================2019-08-08 15:22: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 15:22:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-08-08 15:22:25======================== SELECT idx FROM macs WHERE mac_addr = '00E06F294936301A567F' AND app_code = '046' ========================2019-08-08 15:22:25======================== 값이 없을 경우 ========================2019-08-08 15:24:12======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-1 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS-1 ========================2019-08-08 15:24: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 15:24:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-08-08 15:24:12======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-08-08 15:24:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276396' ========================2019-08-08 15:24:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276396' ========================2019-08-08 15:24:12======================== UPDATE mac_detail SET pc_name = 'POS-1', os_type = '64', user_id = 'ami2881', user_name = '아미상사[이재훈]', screen_w = '1024', screen_h = '768', cdkey = '975677425073' WHERE mac_idx = '276396' ========================2019-08-08 15:26:34======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-2-190806 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E06F294936301A567F sCDKey = 975677425073 sName = POS-2-190806 ========================2019-08-08 15:26: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 15:26:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-08-08 15:26:34======================== SELECT idx FROM macs WHERE mac_addr = '00E06F294936301A567F' AND app_code = '046' ========================2019-08-08 15:26:34======================== 값이 없을 경우 ========================2019-08-08 15:27:35======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-2-190806 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E06F294936301A567F sCDKey = 975677425073 sName = POS-2-190806 ========================2019-08-08 15:27: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 15:27:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-08-08 15:27:35======================== SELECT idx FROM macs WHERE mac_addr = '00E06F294936301A567F' AND app_code = '046' ========================2019-08-08 15:27:35======================== 값이 없을 경우 ========================2019-08-08 18:44:16======================== noteurl_start parm_app_code = 046 parm_pc_name = 아침-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A3EDC482D9E91C sCDKey = 291546858846 sName = 아침-PC ========================2019-08-08 18:44: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 = '291546858846' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 18:44:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'leesuk5424' ========================2019-08-08 18:44:16======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A3EDC482D9E91C' AND app_code = '046' ========================2019-08-08 18:44:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292771' ========================2019-08-08 18:44:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292771' ========================2019-08-08 18:44: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 ( '292771', '50B7C3A3EDC482D9E91C', '046', '아침-PC', '90', '1920', '1080', 'leesuk5424', '자연햇살주식회사[이홍숙]', '291546858846' ) ========================2019-08-08 18:53:36======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-2-190808 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E06F294936301A567F sCDKey = 975677425073 sName = POS-2-190808 ========================2019-08-08 18: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 18:53:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-08-08 18:53:36======================== SELECT idx FROM macs WHERE mac_addr = '00E06F294936301A567F' AND app_code = '046' ========================2019-08-08 18:53:36======================== 값이 없을 경우 ========================2019-08-08 19:16:49======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-2-190808 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A04C01301A567F sCDKey = 975677425073 sName = POS-2-190808 ========================2019-08-08 19:16:49======================== 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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-08 19:16:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-08-08 19:16:49======================== SELECT idx FROM macs WHERE mac_addr = '241C04A04C01301A567F' AND app_code = '046' ========================2019-08-08 19:16:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276492' ========================2019-08-08 19:16:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276492' ========================2019-08-08 19:16:49======================== UPDATE mac_detail SET pc_name = 'POS-2-190808', os_type = '64', user_id = 'ami2881', user_name = '아미상사[이재훈]', screen_w = '1024', screen_h = '768', cdkey = '975677425073' WHERE mac_idx = '276492'