========================2019-01-28 07:52:48======================== noteurl_start parm_app_code = 039 parm_pc_name = MYCOM-C1EDA5B19 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 002522894C84A431E904 sCDKey = 811349502382 sName = MYCOM-C1EDA5B19 ========================2019-01-28 07:52: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 = '811349502382' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 09:03:29======================== noteurl_start parm_app_code = 039 parm_pc_name = MYCOM-C1EDA5B19 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 002522894C84A431E904 sCDKey = 811349502382 sName = MYCOM-C1EDA5B19 ========================2019-01-28 09:03: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 = '811349502382' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 09:09:15======================== noteurl_start parm_app_code = 039 parm_pc_name = MYCOM-C1EDA5B19 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 002522894C84A431E904 sCDKey = 811349502382 sName = MYCOM-C1EDA5B19 ========================2019-01-28 09:09: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 = '811349502382' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 09:09:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'seob9306' ========================2019-01-28 09:09:15======================== SELECT idx FROM macs WHERE mac_addr = '002522894C84A431E904' AND app_code = '039' ========================2019-01-28 09:09:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '118441' ========================2019-01-28 09:09:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '118441' ========================2019-01-28 09:09:15======================== UPDATE mac_detail SET pc_name = 'MYCOM-C1EDA5B19', os_type = '64', user_id = 'seob9306', user_name = '우성화학[현장섭]', screen_w = '1024', screen_h = '768', cdkey = '811349502382' WHERE mac_idx = '118441' ========================2019-01-28 09:27:00======================== noteurl_start parm_app_code = 039 parm_pc_name = LEE-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF4A105E8A8B3D6B5 sCDKey = 734341461677 sName = LEE-PC ========================2019-01-28 09:27:00======================== 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 = '734341461677' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 09:27:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori1641' ========================2019-01-28 09:27:00======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4A105E8A8B3D6B5' AND app_code = '039' ========================2019-01-28 09:27:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272901' ========================2019-01-28 09:27:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272901' ========================2019-01-28 09:27:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272901', 'BC5FF4A105E8A8B3D6B5', '039', 'LEE-PC', '90', '1920', '1080', 'woori1641', '[이태룡]', '734341461677' ) ========================2019-01-28 09:36:26======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 74D4358572F9D868FDA4 sCDKey = 811349502382 sName = MSDN-SPECIAL ========================2019-01-28 09:36:26======================== 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 = '811349502382' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 09:37:30======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 74D4358572F9D868FDA4 sCDKey = 811349502382 sName = MSDN-SPECIAL ========================2019-01-28 09:37:30======================== 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 = '811349502382' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 09:37:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'seob9306' ========================2019-01-28 09:37:30======================== SELECT idx FROM macs WHERE mac_addr = '74D4358572F9D868FDA4' AND app_code = '039' ========================2019-01-28 09:37:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275224' ========================2019-01-28 09:37:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275224' ========================2019-01-28 09:37:30======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'seob9306', user_name = '우성화학[현장섭]', screen_w = '1600', screen_h = '900', cdkey = '811349502382' WHERE mac_idx = '275224' ========================2019-01-28 09:37:49======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 74D4358572F9D868FDA4 sCDKey = 811349502382 sName = MSDN-SPECIAL ========================2019-01-28 09:37:49======================== 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 = '811349502382' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 09:37:52======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 74D4358572F9D868FDA4 sCDKey = 811349502382 sName = MSDN-SPECIAL ========================2019-01-28 09: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 = '811349502382' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 09:43:10======================== noteurl_start parm_app_code = 047 parm_pc_name = LSH2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 145510812979 sName = 홍길동 ========================2019-01-28 09:43: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 = '145510812979' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-28 09:43:28======================== noteurl_start parm_app_code = 047 parm_pc_name = LSH2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 145510812979 sName = 홍길동 ========================2019-01-28 09:43:28======================== 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 = '145510812979' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-28 09:43:42======================== noteurl_start parm_app_code = 047 parm_pc_name = LSH2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 145510812979 sName = 홍길동 ========================2019-01-28 09:43:42======================== 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 = '145510812979' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-28 09:43:46======================== noteurl_start parm_app_code = 047 parm_pc_name = LSH2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 145510812979 sName = 홍길동 ========================2019-01-28 09:43: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 = '145510812979' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-28 09:45:11======================== noteurl_start parm_app_code = 047 parm_pc_name = LSH2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 145510812979 sName = lshgooes ========================2019-01-28 09:45: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 = '145510812979' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-28 13:25:07======================== noteurl_start parm_app_code = 050 parm_pc_name = 고대원-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC7EA90EBE208E sCDKey = 380552522708 sName = 고대원-PC ========================2019-01-28 13:25: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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-28 13:25:11======================== noteurl_start parm_app_code = 050 parm_pc_name = 고대원-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC7EA90EBE208E sCDKey = 380552522708 sName = 고대원-PC ========================2019-01-28 13:25: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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-28 13:25:18======================== noteurl_start parm_app_code = 050 parm_pc_name = 고대원-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC7EA90EBE208E sCDKey = 380552522708 sName = 고대원-PC ========================2019-01-28 13:25:18======================== 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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-28 13:25:23======================== noteurl_start parm_app_code = 050 parm_pc_name = 고대원-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC7EA90EBE208E sCDKey = 380552522708 sName = 고대원-PC ========================2019-01-28 13:25:23======================== 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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-28 13:25:54======================== noteurl_start parm_app_code = 050 parm_pc_name = 고대원-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC7EA90EBE208E sCDKey = 380552522708 sName = 고대원-PC ========================2019-01-28 13:25: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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-28 13:25:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'snip' ========================2019-01-28 13:25:54======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AC7EA90EBE208E' AND app_code = '050' ========================2019-01-28 13:25:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274962' ========================2019-01-28 13:25:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274962' ========================2019-01-28 13:25:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274962', '50B7C3AC7EA90EBE208E', '050', '고대원-PC', '90', '1920', '1080', 'snip', '성남산업진흥재단[김선규]', '380552522708' ) ========================2019-01-28 14:33:42======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-MACM5LGDO3J parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00090FAA000142139329 sCDKey = 375508873226 sName = WIN-MACM5LGDO3J ========================2019-01-28 14:33:42======================== 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 = '375508873226' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-28 14:33:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wdjs86101' ========================2019-01-28 14:33:42======================== SELECT idx FROM macs WHERE mac_addr = '00090FAA000142139329' AND app_code = '039' ========================2019-01-28 14:33:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275637' ========================2019-01-28 14:33:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275637' ========================2019-01-28 14:33:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275637', '00090FAA000142139329', '039', 'WIN-MACM5LGDO3J', '90', '1920', '1080', 'wdjs86101', '월드장식[탁경숙]', '375508873226' )