========================2021-04-12 09:10:05======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-9E2QA1K parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 38FC98FE6ADCB0DBD7EA sCDKey = 384717355941 sName = DESKTOP-9E2QA1K ========================2021-04-12 09:10: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 = '384717355941' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-12 09:10:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dlaksrb486' ========================2021-04-12 09:10:05======================== SELECT idx FROM macs WHERE mac_addr = '38FC98FE6ADCB0DBD7EA' AND app_code = '047' ========================2021-04-12 09:10:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340901' ========================2021-04-12 09:10:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340901' ========================2021-04-12 09:10: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 ( '340901', '38FC98FE6ADCB0DBD7EA', '047', 'DESKTOP-9E2QA1K', '�쐢�룄�슦 10', '0', '0', 'dlaksrb486', '[이만규]', '384717355941' ) ========================2021-04-12 09:10:11======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-9E2QA1K parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 38FC98FE6ADCB0DBD7EA sCDKey = 384717355941 sName = DESKTOP-9E2QA1K ========================2021-04-12 09:10:11======================== 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 = '384717355941' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-12 09:14:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-250QKJF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C221B1714076B6F2 sCDKey = 926256977603 sName = DESKTOP-250QKJF ========================2021-04-12 09:14: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 = '926256977603' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-12 09:14:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pigcorp' ========================2021-04-12 09:14:20======================== SELECT idx FROM macs WHERE mac_addr = '7085C221B1714076B6F2' AND app_code = '039' ========================2021-04-12 09:14:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340831' ========================2021-04-12 09:14:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340831' ========================2021-04-12 09:14: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 ( '340831', '7085C221B1714076B6F2', '039', 'DESKTOP-250QKJF', '110', '1920', '1080', 'pigcorp', '승화전기상사[김종헌]', '926256977603' ) ========================2021-04-12 13:18:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-277066I parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F02F7434BBA58C3C5A27 sCDKey = 130547338144 sName = DESKTOP-277066I ========================2021-04-12 13:18: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 = '130547338144' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-12 13:18:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kormanse1' ========================2021-04-12 13:18:44======================== SELECT idx FROM macs WHERE mac_addr = 'F02F7434BBA58C3C5A27' AND app_code = '039' ========================2021-04-12 13:18:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340934' ========================2021-04-12 13:18:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340934' ========================2021-04-12 13:18:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '340934', 'F02F7434BBA58C3C5A27', '039', 'DESKTOP-277066I', '110', '1920', '1080', 'kormanse1', '피앤피테크[박광무]', '130547338144' ) ========================2021-04-12 14:22:21======================== noteurl_start parm_app_code = 048 parm_pc_name = JY-20191127URKD parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 0C9D92CBC33F5E0797ED sCDKey = 037433637550 sName = JY-20191127URKD ========================2021-04-12 14:22: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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-04-12 14:22:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hpf1937' ========================2021-04-12 14:22:22======================== SELECT idx FROM macs WHERE mac_addr = '0C9D92CBC33F5E0797ED' AND app_code = '048' ========================2021-04-12 14:22:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340947' ========================2021-04-12 14:22:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340947' ========================2021-04-12 14:22: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 ( '340947', '0C9D92CBC33F5E0797ED', '048', 'JY-20191127URKD', '�쐢�룄�슦 10', '0', '0', 'hpf1937', '주식회사 햇품유통[이남훈]', '037433637550' ) ========================2021-04-12 14:30:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0S07F2I parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 408D5C369D315C65BCA2 sCDKey = 335985110134 sName = DESKTOP-0S07F2I ========================2021-04-12 14:30: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 = '335985110134' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-12 14:30:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ojp8226' ========================2021-04-12 14:30:03======================== SELECT idx FROM macs WHERE mac_addr = '408D5C369D315C65BCA2' AND app_code = '039' ========================2021-04-12 14:30:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340950' ========================2021-04-12 14:30:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340950' ========================2021-04-12 14:30: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 ( '340950', '408D5C369D315C65BCA2', '039', 'DESKTOP-0S07F2I', '110', '1680', '1050', 'ojp8226', '동광중기[박용주]', '335985110134' ) ========================2021-04-12 14:39:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VN4MTKI parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = E82A447CBA194474A5E1 sCDKey = 713396259053 sName = DESKTOP-VN4MTKI ========================2021-04-12 14:39: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 = '713396259053' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-12 14:39:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'garcia7' ========================2021-04-12 14:39:06======================== SELECT idx FROM macs WHERE mac_addr = 'E82A447CBA194474A5E1' AND app_code = '039' ========================2021-04-12 14:39:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340951' ========================2021-04-12 14:39:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340951' ========================2021-04-12 14:39: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 ( '340951', 'E82A447CBA194474A5E1', '039', 'DESKTOP-VN4MTKI', '110', '1280', '720', 'garcia7', '개화물류[박준호]', '713396259053' ) ========================2021-04-12 15:21:14======================== noteurl_start parm_app_code = 039 parm_pc_name = IIU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C369D31F6817914 sCDKey = 335985110134 sName = IIU-PC ========================2021-04-12 15:21: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 = '335985110134' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-12 15:21:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ojp8226' ========================2021-04-12 15:21:14======================== SELECT idx FROM macs WHERE mac_addr = '408D5C369D31F6817914' AND app_code = '039' ========================2021-04-12 15:21:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '162234' ========================2021-04-12 15:21:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '162234' ========================2021-04-12 15:21:14======================== UPDATE mac_detail SET pc_name = 'IIU-PC', os_type = '90', user_id = 'ojp8226', user_name = '동광중기[박용주]', screen_w = '1920', screen_h = '1080', cdkey = '335985110134' WHERE mac_idx = '162234' ========================2021-04-12 19:19:05======================== noteurl_start parm_app_code = 047 parm_pc_name = MSDN-SPECIAL parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BC5FF4E36F98F62F1260 sCDKey = 398304808923 sName = MSDN-SPECIAL ========================2021-04-12 19:19: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 = '398304808923' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-12 19:19:09======================== noteurl_start parm_app_code = 047 parm_pc_name = MSDN-SPECIAL parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BC5FF4E36F98F62F1260 sCDKey = 398304808923 sName = MSDN-SPECIAL ========================2021-04-12 19:19: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 = '398304808923' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-12 19:19:17======================== noteurl_start parm_app_code = 048 parm_pc_name = MSDN-SPECIAL parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BC5FF4E36F98F62F1260 sCDKey = 398304808923 sName = MSDN-SPECIAL ========================2021-04-12 19:19:17======================== 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 = '398304808923' AND r.app_code = '048' AND r.app_block = 0 ========================2021-04-12 20:35:33======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-5I5P7DD parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C20B3D09FFFFFFFF sCDKey = 398304808923 sName = DESKTOP-5I5P7DD ========================2021-04-12 20:35: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 = '398304808923' AND r.app_code = '048' AND r.app_block = 0 ========================2021-04-12 20:35:53======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-5I5P7DD parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C20B3D09FFFFFFFF sCDKey = 398304808923 sName = DESKTOP-5I5P7DD ========================2021-04-12 20: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 = '398304808923' AND r.app_code = '048' AND r.app_block = 0