========================2019-10-21 13:04:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FTFIKGD parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 960 parm_user_mac = 24F5AAEA2E33A9DDD46 sCDKey = 697886965681 sName = DESKTOP-FTFIKGD ========================2019-10-21 13:04: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 = '697886965681' AND r.app_code = '039' AND r.app_block = 0 ========================2019-10-21 13:04:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rlqhr0915' ========================2019-10-21 13:04:52======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEA2E33A9DDD46' AND app_code = '039' ========================2019-10-21 13:04:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '300670' ========================2019-10-21 13:04:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '300670' ========================2019-10-21 13:04: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 ( '300670', '24F5AAEA2E33A9DDD46', '039', 'DESKTOP-FTFIKGD', '110', '1280', '960', 'rlqhr0915', '대동육가공[최기복]', '697886965681' ) ========================2019-10-21 14:04:36======================== noteurl_start parm_app_code = 050 parm_pc_name = LAPTOP-B58OI09N parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 380025E4449AB257DB88 sCDKey = 383859230002 sName = LAPTOP-B58OI09N ========================2019-10-21 14:04: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 = '383859230002' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-21 14:04:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kordas01' ========================2019-10-21 14:04:36======================== SELECT idx FROM macs WHERE mac_addr = '380025E4449AB257DB88' AND app_code = '050' ========================2019-10-21 14:04:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '300774' ========================2019-10-21 14:04:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '300774' ========================2019-10-21 14:04:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '300774', '380025E4449AB257DB88', '050', 'LAPTOP-B58OI09N', '109', '1536', '864', 'kordas01', '온누리테크[김옥희]', '383859230002' ) ========================2019-10-21 16:12:04======================== noteurl_start parm_app_code = 039 parm_pc_name = NOTE parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 9883899F748162AA2D3E sCDKey = 884734283497 sName = NOTE ========================2019-10-21 16:12: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 = '884734283497' AND r.app_code = '039' AND r.app_block = 0 ========================2019-10-21 16:12:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimjd25' ========================2019-10-21 16:12:04======================== SELECT idx FROM macs WHERE mac_addr = '9883899F748162AA2D3E' AND app_code = '039' ========================2019-10-21 16:12:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '300798' ========================2019-10-21 16:12:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '300798' ========================2019-10-21 16:12: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 ( '300798', '9883899F748162AA2D3E', '039', 'NOTE', '110', '1536', '864', 'kimjd25', '정무하이테크[김진덕]', '884734283497' ) ========================2019-10-21 17:49:43======================== noteurl_start parm_app_code = 046 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 00245434D7FAE4F8655C sCDKey = 850892131999 sName = SAMSUNG-PC ========================2019-10-21 17:49:43======================== 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 = '850892131999' AND r.app_code = '046' AND r.app_block = 0 ========================2019-10-21 17:50:01======================== noteurl_start parm_app_code = 046 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 00245434D7FAE4F8655C sCDKey = 850892131999 sName = SAMSUNG-PC ========================2019-10-21 17:50: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 = '850892131999' AND r.app_code = '046' AND r.app_block = 0 ========================2019-10-21 17:50:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wlseheor1210' ========================2019-10-21 17:50:01======================== SELECT idx FROM macs WHERE mac_addr = '00245434D7FAE4F8655C' AND app_code = '046' ========================2019-10-21 17:50:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '300805' ========================2019-10-21 17:50:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '300805' ========================2019-10-21 17:50:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '300805', '00245434D7FAE4F8655C', '046', 'SAMSUNG-PC', '90', '1440', '900', 'wlseheor1210', '청해진유통[하영이]', '850892131999' )