========================2018-05-09 08:37:52======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 803F5D09ABC7B6B24F19 sCDKey = ymedacalec12 sName = 하동열 ========================2018-05-09 08: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 = 'YMEDACALEC12' AND r.app_code = '050' AND r.app_block = 0 ========================2018-05-09 11:03:22======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-03 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00266608E0EE24641C48 sCDKey = 683156263623 sName = HBDS-03 ========================2018-05-09 11:03:22======================== 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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-09 11:03:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2018-05-09 11:03:22======================== SELECT idx FROM macs WHERE mac_addr = '00266608E0EE24641C48' AND app_code = '039' ========================2018-05-09 11:03:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249132' ========================2018-05-09 11:03:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249132' ========================2018-05-09 11:03: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 ( '249132', '00266608E0EE24641C48', '039', 'HBDS-03', '110', '1920', '1080', 'bangchun', '한반도[이진석]', '683156263623' ) ========================2018-05-09 11:20:06======================== noteurl_start parm_app_code = 039 parm_pc_name = MAIN parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA141E113A6836BA52 sCDKey = 662111538586 sName = MAIN ========================2018-05-09 11:20:06======================== 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 = '662111538586' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-09 11:20:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a6222809' ========================2018-05-09 11:20:06======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA141E113A6836BA52' AND app_code = '039' ========================2018-05-09 11:20:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249320' ========================2018-05-09 11:20:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249320' ========================2018-05-09 11:20: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 ( '249320', 'FCAA141E113A6836BA52', '039', 'MAIN', '90', '1920', '1080', 'a6222809', '동양정밀(유)[이춘남]', '662111538586' ) ========================2018-05-09 14:07:34======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-BUF51MAI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838945715C8AA3A847 sCDKey = 398000966018 sName = LAPTOP-BUF51MAI ========================2018-05-09 14:07:34======================== 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 = '398000966018' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-09 14:07:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'acelc050' ========================2018-05-09 14:07:34======================== SELECT idx FROM macs WHERE mac_addr = '98838945715C8AA3A847' AND app_code = '039' ========================2018-05-09 14:07:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249336' ========================2018-05-09 14:07:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249336' ========================2018-05-09 14:07:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249336', '98838945715C8AA3A847', '039', 'LAPTOP-BUF51MAI', '110', '1920', '1080', 'acelc050', '신양건설기계[이만희]', '398000966018' ) ========================2018-05-09 15:04:25======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-08 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 68ECC5280B9AD851F447 sCDKey = 683156263623 sName = HBDS-08 ========================2018-05-09 15:04:25======================== 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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-09 17:42:41======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-KS4HEG3SOFR parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00266644843F442D7D3C sCDKey = 663768523140 sName = WIN-KS4HEG3SOFR ========================2018-05-09 17:42:41======================== 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 = '663768523140' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-09 17:42:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ii09ii' ========================2018-05-09 17:42:41======================== SELECT idx FROM macs WHERE mac_addr = '00266644843F442D7D3C' AND app_code = '046' ========================2018-05-09 17:42:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249359' ========================2018-05-09 17:42:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249359' ========================2018-05-09 17:42:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249359', '00266644843F442D7D3C', '046', 'WIN-KS4HEG3SOFR', '90', '1280', '1024', 'ii09ii', '마포식자재[양관석]', '663768523140' ) ========================2018-05-09 17:42:48======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-KS4HEG3SOFR parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00266644843F442D7D3C sCDKey = 663768523140 sName = WIN-KS4HEG3SOFR ========================2018-05-09 17:42: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 = '663768523140' AND r.app_code = '046' AND r.app_block = 0