========================2019-03-29 12:35:03======================== noteurl_start parm_app_code = 047 parm_pc_name = HANA-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C284B4635EEBBCBF sCDKey = 887965645263 sName = 관리pc ========================2019-03-29 12:35:03======================== 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 = '887965645263' AND r.app_code = '047' AND r.app_block = 0 ========================2019-03-29 12:35:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hsh8902' ========================2019-03-29 12:35:03======================== SELECT idx FROM macs WHERE mac_addr = '7085C284B4635EEBBCBF' AND app_code = '047' ========================2019-03-29 12:35:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281829' ========================2019-03-29 12:35:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281829' ========================2019-03-29 12:35:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '281829', '7085C284B4635EEBBCBF', '047', '관리pc', '�쐢�룄�슦 7', '0', '0', 'hsh8902', '하나상사[황승해]', '887965645263' ) ========================2019-03-29 14:24:45======================== noteurl_start parm_app_code = 047 parm_pc_name = HANA-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C284B4635EEBBCBF sCDKey = 887965645263 sName = 관리pc ========================2019-03-29 14:24:45======================== 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 = '887965645263' AND r.app_code = '047' AND r.app_block = 0 ========================2019-03-29 14:24:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hsh8902' ========================2019-03-29 14:24:45======================== SELECT idx FROM macs WHERE mac_addr = '7085C284B4635EEBBCBF' AND app_code = '047' ========================2019-03-29 14:24:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281829' ========================2019-03-29 14:24:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281829' ========================2019-03-29 14:24:45======================== UPDATE mac_detail SET pc_name = '관리pc', os_type = '�쐢�룄�슦 7', user_id = 'hsh8902', user_name = '하나상사[황승해]', screen_w = '0', screen_h = '0', cdkey = '887965645263' WHERE mac_idx = '281829' ========================2019-03-29 14:42:34======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-4H2FP5I parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DC6D4E0E960714 sCDKey = 434133617514 sName = 20190329강정미 ========================2019-03-29 14:42: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-29 14:42:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-03-29 14:42:34======================== SELECT idx FROM macs WHERE mac_addr = '988389DC6D4E0E960714' AND app_code = '048' ========================2019-03-29 14:42:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281844' ========================2019-03-29 14:42:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281844' ========================2019-03-29 14:42:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '281844', '988389DC6D4E0E960714', '048', '20190329강정미', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2019-03-29 14:54:20======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QAMHG71 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F43909493326025FB850 sCDKey = 003258461544 sName = DESKTOP-QAMHG71 ========================2019-03-29 14:54: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 = '003258461544' AND r.app_code = '050' AND r.app_block = 0 ========================2019-03-29 14:54:29======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QAMHG71 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F43909493326025FB850 sCDKey = 003258461544 sName = DESKTOP-QAMHG71 ========================2019-03-29 14:54: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 = '003258461544' AND r.app_code = '050' AND r.app_block = 0 ========================2019-03-29 14:56:29======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QAMHG71 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F43909493326025FB850 sCDKey = 003258461544 sName = DESKTOP-QAMHG71 ========================2019-03-29 14:56: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 = '003258461544' AND r.app_code = '050' AND r.app_block = 0 ========================2019-03-29 15:40:21======================== noteurl_start parm_app_code = 048 parm_pc_name = KIMHANDO-NB parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CD05A0748CCAA34B831 sCDKey = 838267735728 sName = KIMHANDO ========================2019-03-29 15:40:21======================== 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 = '838267735728' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-29 15:40:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimhando' ========================2019-03-29 15:40:21======================== SELECT idx FROM macs WHERE mac_addr = '2CD05A0748CCAA34B831' AND app_code = '048' ========================2019-03-29 15:40:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278956' ========================2019-03-29 15:40:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278956' ========================2019-03-29 15:40:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '278956', '2CD05A0748CCAA34B831', '048', 'KIMHANDO', '�쐢�룄�슦 7', '0', '0', 'kimhando', '주식회사 종합유통[김한도]', '838267735728' ) ========================2019-03-29 15:42:01======================== noteurl_start parm_app_code = 048 parm_pc_name = SYMOON-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 94DE80AF74F3642E6899 sCDKey = 838267735728 sName = SYMOON-PC ========================2019-03-29 15:42: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 = '838267735728' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-29 15:42:14======================== noteurl_start parm_app_code = 048 parm_pc_name = SYMOON-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 94DE80AF74F3642E6899 sCDKey = 838267735728 sName = kimhando ========================2019-03-29 15:42:14======================== 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 = '838267735728' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-29 15:42:39======================== noteurl_start parm_app_code = 048 parm_pc_name = SYMOON-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 94DE80AF74F3642E6899 sCDKey = 838267735728 sName = kimhando ========================2019-03-29 15:42:39======================== 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 = '838267735728' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-29 15:44:57======================== noteurl_start parm_app_code = 048 parm_pc_name = SYMOON-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 94DE80AF74F3642E6899 sCDKey = 838267735728 sName = kimhando ========================2019-03-29 15:44: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 = '838267735728' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-29 15:47:56======================== noteurl_start parm_app_code = 048 parm_pc_name = SYMOON-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 94DE80AF74F3642E6899 sCDKey = 838267735728 sName = SYMOON-PC ========================2019-03-29 15:47: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 = '838267735728' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-29 15:47:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimhando' ========================2019-03-29 15:47:56======================== SELECT idx FROM macs WHERE mac_addr = '94DE80AF74F3642E6899' AND app_code = '048' ========================2019-03-29 15:47:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281854' ========================2019-03-29 15:47:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281854' ========================2019-03-29 15:47: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 ( '281854', '94DE80AF74F3642E6899', '048', 'SYMOON-PC', '�쐢�룄�슦 7', '0', '0', 'kimhando', '주식회사 종합유통[김한도]', '838267735728' ) ========================2019-03-29 15:48:53======================== 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 = 50AF732F0DF7EE2B1141 sCDKey = 887965645263 sName = DESKTOP-IR4BE71 ========================2019-03-29 15:48: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 = '887965645263' AND r.app_code = '047' AND r.app_block = 0 ========================2019-03-29 15:48:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hsh8902' ========================2019-03-29 15:48:53======================== SELECT idx FROM macs WHERE mac_addr = '50AF732F0DF7EE2B1141' AND app_code = '047' ========================2019-03-29 15:48:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281855' ========================2019-03-29 15:48:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281855' ========================2019-03-29 15:48: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 ( '281855', '50AF732F0DF7EE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'hsh8902', '하나상사[황승해]', '887965645263' ) ========================2019-03-29 15:53:15======================== 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 = 50AF732F0DF7EE2B1141 sCDKey = 887965645263 sName = DESKTOP-IR4BE71 ========================2019-03-29 15:53: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 = '887965645263' AND r.app_code = '047' AND r.app_block = 0 ========================2019-03-29 15:53:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hsh8902' ========================2019-03-29 15:53:15======================== SELECT idx FROM macs WHERE mac_addr = '50AF732F0DF7EE2B1141' AND app_code = '047' ========================2019-03-29 15:53:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281855' ========================2019-03-29 15:53:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281855' ========================2019-03-29 15:53:15======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IR4BE71', os_type = '�쐢�룄�슦 10', user_id = 'hsh8902', user_name = '하나상사[황승해]', screen_w = '0', screen_h = '0', cdkey = '887965645263' WHERE mac_idx = '281855' ========================2019-03-29 16:25:09======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QAMHG71 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F43909493326025FB850 sCDKey = 003258461544 sName = DESKTOP-QAMHG71 ========================2019-03-29 16:25: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 = '003258461544' AND r.app_code = '050' AND r.app_block = 0 ========================2019-03-29 16:25:14======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QAMHG71 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F43909493326025FB850 sCDKey = 003258461544 sName = DESKTOP-QAMHG71 ========================2019-03-29 16:25:14======================== 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 = '003258461544' AND r.app_code = '050' AND r.app_block = 0 ========================2019-03-29 16:27:25======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QAMHG71 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F43909493326025FB850 sCDKey = 003258461544 sName = DESKTOP-QAMHG71 ========================2019-03-29 16:27: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 = '003258461544' AND r.app_code = '050' AND r.app_block = 0 ========================2019-03-29 17:01:14======================== noteurl_start parm_app_code = 047 parm_pc_name = HANA-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1C1B0D87C6F65EEBBCBF sCDKey = 887965645263 sName = HANA-PC ========================2019-03-29 17:01:14======================== 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 = '887965645263' AND r.app_code = '047' AND r.app_block = 0 ========================2019-03-29 17:01:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hsh8902' ========================2019-03-29 17:01:14======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D87C6F65EEBBCBF' AND app_code = '047' ========================2019-03-29 17:01:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281879' ========================2019-03-29 17:01:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281879' ========================2019-03-29 17:01:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '281879', '1C1B0D87C6F65EEBBCBF', '047', 'HANA-PC', '�쐢�룄�슦 7', '0', '0', 'hsh8902', '하나상사[황승해]', '887965645263' ) ========================2019-03-29 17:01:24======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QAMHG71 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F43909493326025FB850 sCDKey = 003258461544 sName = DESKTOP-QAMHG71 ========================2019-03-29 17:01: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 = '003258461544' AND r.app_code = '050' AND r.app_block = 0