========================2018-10-01 09:10:55======================== noteurl_start parm_app_code = 047 parm_pc_name = G41MXE parm_os_type = �쐢�룄�슦 XP parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D0278855601100007DE5 sCDKey = 400148721874 sName = G41MXE ========================2018-10-01 09:10: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 = '400148721874' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-01 09:10:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee5327487' ========================2018-10-01 09:10:56======================== SELECT idx FROM macs WHERE mac_addr = 'D0278855601100007DE5' AND app_code = '047' ========================2018-10-01 09:10:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261166' ========================2018-10-01 09:10:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261166' ========================2018-10-01 09:10: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 ( '261166', 'D0278855601100007DE5', '047', 'G41MXE', '�쐢�룄�슦 XP', '0', '0', 'lee5327487', '한국철물공구[이선]', '400148721874' ) ========================2018-10-01 09:27:45======================== noteurl_start parm_app_code = 039 parm_pc_name = HPCOM-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 78ACC0B4B3591CF59C70 sCDKey = 504321129832 sName = HPCOM-PC ========================2018-10-01 09:27: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 = '504321129832' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 09:27:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jesus6018' ========================2018-10-01 09:27:45======================== SELECT idx FROM macs WHERE mac_addr = '78ACC0B4B3591CF59C70' AND app_code = '039' ========================2018-10-01 09:27:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261162' ========================2018-10-01 09:27:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261162' ========================2018-10-01 09:27:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261162', '78ACC0B4B3591CF59C70', '039', 'HPCOM-PC', '90', '1440', '900', 'jesus6018', '현대윤활유상사[박노철]', '504321129832' ) ========================2018-10-01 09:43:39======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0013D359B048E8611E19 sCDKey = 363622329041 sName = ========================2018-10-01 09:43: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 09:43:44======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0013D359B048E8611E19 sCDKey = 363622329041 sName = ========================2018-10-01 09:43: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 09:43:48======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0013D359B048E8611E19 sCDKey = 363622329041 sName = ========================2018-10-01 09:43: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 09:44:15======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0013D359B048E8611E19 sCDKey = 363622329041 sName = 박태하 ========================2018-10-01 09:44: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 09:44:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'card700' ========================2018-10-01 09:44:15======================== SELECT idx FROM macs WHERE mac_addr = '0013D359B048E8611E19' AND app_code = '039' ========================2018-10-01 09:44:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '197031' ========================2018-10-01 09:44:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '197031' ========================2018-10-01 09:44:15======================== UPDATE mac_detail SET pc_name = '박태하', os_type = '90', user_id = 'card700', user_name = '현수막백화점[박태하]', screen_w = '1680', screen_h = '1050', cdkey = '363622329041' WHERE mac_idx = '197031' ========================2018-10-01 09:44:21======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0013D359B048E8611E19 sCDKey = 363622329041 sName = 박태하 ========================2018-10-01 09:44: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 = '363622329041' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 09:44:56======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMAGVC-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = C417FE5A1BDFF87191B6 sCDKey = 300997963610 sName = SAMAGVC-PC ========================2018-10-01 09: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 = '300997963610' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 09:44:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'leekg6318' ========================2018-10-01 09:44:56======================== SELECT idx FROM macs WHERE mac_addr = 'C417FE5A1BDFF87191B6' AND app_code = '039' ========================2018-10-01 09:44:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '211425' ========================2018-10-01 09:44:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '211425' ========================2018-10-01 09:44:56======================== UPDATE mac_detail SET pc_name = 'SAMAGVC-PC', os_type = '90', user_id = 'leekg6318', user_name = '금강카센타[이종운]', screen_w = '1440', screen_h = '900', cdkey = '300997963610' WHERE mac_idx = '211425' ========================2018-10-01 10:54:59======================== noteurl_start parm_app_code = 039 parm_pc_name = 삼성COPY1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050994AD2894228D0EA sCDKey = 293768519265 sName = 삼성COPY1 ========================2018-10-01 10: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 = '293768519265' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 10:54:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samcoppy' ========================2018-10-01 10:54:59======================== SELECT idx FROM macs WHERE mac_addr = 'D050994AD2894228D0EA' AND app_code = '039' ========================2018-10-01 10:54:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258980' ========================2018-10-01 10:54:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258980' ========================2018-10-01 10:54:59======================== UPDATE mac_detail SET pc_name = '삼성COPY1', os_type = '90', user_id = 'samcoppy', user_name = '삼성인쇄사[이은숙]', screen_w = '1920', screen_h = '1080', cdkey = '293768519265' WHERE mac_idx = '258980' ========================2018-10-01 11:21:13======================== noteurl_start parm_app_code = 039 parm_pc_name = User-1808181645 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003018A26668B850A79B sCDKey = 664000149570 sName = User-1808181645 ========================2018-10-01 11:21: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 = '664000149570' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 11:21:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljc_1089' ========================2018-10-01 11:21:13======================== SELECT idx FROM macs WHERE mac_addr = '003018A26668B850A79B' AND app_code = '039' ========================2018-10-01 11:21:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260521' ========================2018-10-01 11:21:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260521' ========================2018-10-01 11:21:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260521', '003018A26668B850A79B', '039', 'User-1808181645', '90', '1920', '1080', 'ljc_1089', '대형연일카[이장천]', '664000149570' ) ========================2018-10-01 13:05:46======================== noteurl_start parm_app_code = 047 parm_pc_name = G41MXE parm_os_type = �쐢�룄�슦 XP parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D0278855601100007DE5 sCDKey = 400148721874 sName = G41MXE ========================2018-10-01 13:05: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 = '400148721874' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-01 13:08:46======================== noteurl_start parm_app_code = 047 parm_pc_name = G41MXE parm_os_type = �쐢�룄�슦 XP parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D0278855601100007DE5 sCDKey = 400148721874 sName = G41MXE ========================2018-10-01 13:08: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 = '400148721874' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-01 13:08:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee5327487' ========================2018-10-01 13:08:46======================== SELECT idx FROM macs WHERE mac_addr = 'D0278855601100007DE5' AND app_code = '047' ========================2018-10-01 13:08:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261166' ========================2018-10-01 13:08:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261166' ========================2018-10-01 13:08:46======================== UPDATE mac_detail SET pc_name = 'G41MXE', os_type = '�쐢�룄�슦 XP', user_id = 'lee5327487', user_name = '한국철물공구[이선]', screen_w = '0', screen_h = '0', cdkey = '400148721874' WHERE mac_idx = '261166' ========================2018-10-01 13:49:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FDMSCHG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 0C54A501A76D4A4148B2 sCDKey = 373586568321 sName = DESKTOP-FDMSCHG ========================2018-10-01 13:49:52======================== 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 = '373586568321' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 13:49:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'best2580' ========================2018-10-01 13:49:52======================== SELECT idx FROM macs WHERE mac_addr = '0C54A501A76D4A4148B2' AND app_code = '039' ========================2018-10-01 13:49:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261189' ========================2018-10-01 13:49:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261189' ========================2018-10-01 13:49:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261189', '0C54A501A76D4A4148B2', '039', 'DESKTOP-FDMSCHG', '110', '1920', '1200', 'best2580', '베스트테크[박완규]', '373586568321' ) ========================2018-10-01 13:54:54======================== noteurl_start parm_app_code = 047 parm_pc_name = G41MXE parm_os_type = �쐢�룄�슦 XP parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D0278855601100007DE5 sCDKey = 400148721874 sName = G41MXE ========================2018-10-01 13:54:54======================== 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 = '400148721874' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-01 13:54:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee5327487' ========================2018-10-01 13:54:54======================== SELECT idx FROM macs WHERE mac_addr = 'D0278855601100007DE5' AND app_code = '047' ========================2018-10-01 13:54:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261166' ========================2018-10-01 13:54:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261166' ========================2018-10-01 13:54:54======================== UPDATE mac_detail SET pc_name = 'G41MXE', os_type = '�쐢�룄�슦 XP', user_id = 'lee5327487', user_name = '한국철물공구[이선]', screen_w = '0', screen_h = '0', cdkey = '400148721874' WHERE mac_idx = '261166' ========================2018-10-01 14:34:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGWON-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C27530B6B8F19E8F sCDKey = 251007618539 sName = DONGWON-PC ========================2018-10-01 14:34: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 = '251007618539' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 14:35:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGWON-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C27530B6B8F19E8F sCDKey = 251007618539 sName = DONGWON-PC ========================2018-10-01 14:35: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 = '251007618539' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 14:35:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dksehd2571' ========================2018-10-01 14:35:53======================== SELECT idx FROM macs WHERE mac_addr = '7085C27530B6B8F19E8F' AND app_code = '039' ========================2018-10-01 14:35:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258719' ========================2018-10-01 14:35:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258719' ========================2018-10-01 14:35: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 ( '258719', '7085C27530B6B8F19E8F', '039', 'DONGWON-PC', '90', '1920', '1080', 'dksehd2571', '대명수산[안동원]', '251007618539' ) ========================2018-10-01 15:58:15======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ILT423A parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F8633F848A00762A8F6B sCDKey = 959922622472 sName = DESKTOP-ILT423A ========================2018-10-01 15:58: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 = '959922622472' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-01 15:58:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunk16' ========================2018-10-01 15:58:15======================== SELECT idx FROM macs WHERE mac_addr = 'F8633F848A00762A8F6B' AND app_code = '047' ========================2018-10-01 15:58:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257514' ========================2018-10-01 15:58:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257514' ========================2018-10-01 15:58:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '257514', 'F8633F848A00762A8F6B', '047', 'DESKTOP-ILT423A', '�쐢�룄�슦 10', '0', '0', 'sunk16', '보일러백화점[허주현]', '959922622472' ) ========================2018-10-01 17:31:55======================== noteurl_start parm_app_code = 039 parm_pc_name = USER10011-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB2A7180D2312 sCDKey = 972712985266 sName = USER10011-PC ========================2018-10-01 17:31: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 = '972712985266' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 17:32:04======================== noteurl_start parm_app_code = 039 parm_pc_name = USER10011-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB2A7180D2312 sCDKey = 972712985266 sName = USER10011-PC ========================2018-10-01 17:32:04======================== 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 = '972712985266' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-01 17:32:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'icb7858' ========================2018-10-01 17:32:04======================== SELECT idx FROM macs WHERE mac_addr = 'E89A8FDB2A7180D2312' AND app_code = '039' ========================2018-10-01 17:32:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261228' ========================2018-10-01 17:32:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261228' ========================2018-10-01 17:32:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261228', 'E89A8FDB2A7180D2312', '039', 'USER10011-PC', '90', '1920', '1080', 'icb7858', '동보이엔지[임천복]', '972712985266' )