========================2020-11-10 11:12:02======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 24F5AAAD55704463B463 sCDKey = 324153203620 sName = USER ========================2020-11-10 11:12:02======================== 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 = '324153203620' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-10 11:12:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjm6020' ========================2020-11-10 11:12:02======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAAD55704463B463' AND app_code = '039' ========================2020-11-10 11:12:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251054' ========================2020-11-10 11:12:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251054' ========================2020-11-10 11:12:02======================== UPDATE mac_detail SET pc_name = 'USER', os_type = '110', user_id = 'sjm6020', user_name = '남춘천크레인[박재균]', screen_w = '1440', screen_h = '900', cdkey = '324153203620' WHERE mac_idx = '251054' ========================2020-11-10 11:38:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-C5Q1JJ7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691342288776BA901 sCDKey = 683187009788 sName = DESKTOP-C5Q1JJ7 ========================2020-11-10 11:38: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 = '683187009788' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-10 11:38:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs0458' ========================2020-11-10 11:38:52======================== SELECT idx FROM macs WHERE mac_addr = '94C691342288776BA901' AND app_code = '039' ========================2020-11-10 11:38:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329790' ========================2020-11-10 11:38:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329790' ========================2020-11-10 11:38: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 ( '329790', '94C691342288776BA901', '039', 'DESKTOP-C5Q1JJ7', '110', '1920', '1080', 'cs0458', '천수관광[박천수]', '683187009788' ) ========================2020-11-10 13:38:46======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN2010 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04D65EB1A875AE3A sCDKey = 044601532073 sName = WIN2010 ========================2020-11-10 13:38: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 = '044601532073' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-10 13:38:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ss620813' ========================2020-11-10 13:38:46======================== SELECT idx FROM macs WHERE mac_addr = '18C04D65EB1A875AE3A' AND app_code = '039' ========================2020-11-10 13:38:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329800' ========================2020-11-10 13:38:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329800' ========================2020-11-10 13:38:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329800', '18C04D65EB1A875AE3A', '039', 'WIN2010', '110', '1920', '1080', 'ss620813', '신영정밀[신동구]', '044601532073' ) ========================2020-11-10 13:55:10======================== noteurl_start parm_app_code = 039 parm_pc_name = JWCOM-201110 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80AB2752D2D2DA51 sCDKey = 167075700003 sName = JWCOM-201110 ========================2020-11-10 13:55:10======================== 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 = '167075700003' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-10 13:55:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jwtech02' ========================2020-11-10 13:55:10======================== SELECT idx FROM macs WHERE mac_addr = '94DE80AB2752D2D2DA51' AND app_code = '039' ========================2020-11-10 13:55:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329804' ========================2020-11-10 13:55:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329804' ========================2020-11-10 13:55:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329804', '94DE80AB2752D2D2DA51', '039', 'JWCOM-201110', '110', '1920', '1080', 'jwtech02', '정원테크[박영이]', '167075700003' ) ========================2020-11-10 13:57:17======================== noteurl_start parm_app_code = 039 parm_pc_name = ATIV930X parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 28B2BDE54895D6101730 sCDKey = 114905341456 sName = ATIV930X ========================2020-11-10 13:57: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 = '114905341456' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-10 13:57:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gosok1201' ========================2020-11-10 13:57:17======================== SELECT idx FROM macs WHERE mac_addr = '28B2BDE54895D6101730' AND app_code = '039' ========================2020-11-10 13:57:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329802' ========================2020-11-10 13:57:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329802' ========================2020-11-10 13:57:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329802', '28B2BDE54895D6101730', '039', 'ATIV930X', '110', '1280', '720', 'gosok1201', '고속무선통신[이영임]', '114905341456' ) ========================2020-11-10 15:18:40======================== noteurl_start parm_app_code = 046 parm_pc_name = 강성호노트북 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = B4749F522765DCAC14C3 sCDKey = 938129979397 sName = 화명동핫독 ========================2020-11-10 15:18:40======================== 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 = '938129979397' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-10 15:18:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mdpet' ========================2020-11-10 15:18:40======================== SELECT idx FROM macs WHERE mac_addr = 'B4749F522765DCAC14C3' AND app_code = '046' ========================2020-11-10 15:18:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329817' ========================2020-11-10 15:18:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329817' ========================2020-11-10 15:18:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329817', 'B4749F522765DCAC14C3', '046', '화명동핫독', '90', '1366', '768', 'mdpet', '엠디펫[이종원]', '938129979397' ) ========================2020-11-10 15:59:07======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN10-01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00012E503728CEF826FA sCDKey = 781265661893 sName = WIN10-01 ========================2020-11-10 15:59:07======================== 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 = '781265661893' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-10 15:59:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'announg11' ========================2020-11-10 15:59:07======================== SELECT idx FROM macs WHERE mac_addr = '00012E503728CEF826FA' AND app_code = '039' ========================2020-11-10 15:59:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329821' ========================2020-11-10 15:59:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329821' ========================2020-11-10 15:59:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329821', '00012E503728CEF826FA', '039', 'WIN10-01', '110', '1920', '1080', 'announg11', '(주)각시피앤씨[안교영]', '781265661893' ) ========================2020-11-10 17:37:52======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8GCIFAR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8030497DF087E2B1598B sCDKey = 588524411493 sName = 노트북 ========================2020-11-10 17:37: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 = '588524411493' AND r.app_code = '047' AND r.app_block = 0 ========================2020-11-10 17:37:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onemart2019' ========================2020-11-10 17:37:52======================== SELECT idx FROM macs WHERE mac_addr = '8030497DF087E2B1598B' AND app_code = '047' ========================2020-11-10 17:37:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329834' ========================2020-11-10 17:37:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329834' ========================2020-11-10 17:37: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 ( '329834', '8030497DF087E2B1598B', '047', '노트북', '�쐢�룄�슦 10', '0', '0', 'onemart2019', 'ONEmart[송웅]', '588524411493' )