========================2019-05-03 08:50:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VO5UABL parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 98838917548CEA99FC33 sCDKey = 827754547202 sName = DESKTOP-VO5UABL ========================2019-05-03 08:50:12======================== 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 = '827754547202' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-03 08:50:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VO5UABL parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 98838917548CEA99FC33 sCDKey = 827754547202 sName = DESKTOP-VO5UABL ========================2019-05-03 08:50:37======================== 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 = '827754547202' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-03 09:10:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VO5UABL parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 98838917548CEA99FC33 sCDKey = 827754547202 sName = DESKTOP-VO5UABL ========================2019-05-03 09:10:35======================== 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 = '827754547202' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-03 09:10:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhw600' ========================2019-05-03 09:10:35======================== SELECT idx FROM macs WHERE mac_addr = '98838917548CEA99FC33' AND app_code = '039' ========================2019-05-03 09:10:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '227081' ========================2019-05-03 09:10:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '227081' ========================2019-05-03 09:10:38======================== UPDATE mac_detail SET pc_name = 'DESKTOP-VO5UABL', os_type = '110', user_id = 'jhw600', user_name = '서진안전[장호원]', screen_w = '1366', screen_h = '768', cdkey = '827754547202' WHERE mac_idx = '227081' ========================2019-05-03 10:22:42======================== noteurl_start parm_app_code = 045 parm_pc_name = YES5 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C6F65DFD45C8EFD1871 sCDKey = 455867584679 sName = YES5 ========================2019-05-03 10:22: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 = '455867584679' AND r.app_code = '045' AND r.app_block = 0 ========================2019-05-03 10:22:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yesmedia11' ========================2019-05-03 10:22:42======================== SELECT idx FROM macs WHERE mac_addr = '1C6F65DFD45C8EFD1871' AND app_code = '045' ========================2019-05-03 10:22:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285050' ========================2019-05-03 10:22:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285050' ========================2019-05-03 10:22: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 ( '285050', '1C6F65DFD45C8EFD1871', '045', 'YES5', '90', '1920', '1080', 'yesmedia11', '예스미디어[황인학]', '455867584679' ) ========================2019-05-03 10:37:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JAPUF8O parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 505BC2768F79720A662D sCDKey = 729173377413 sName = DESKTOP-JAPUF8O ========================2019-05-03 10:37: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 = '729173377413' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-03 10:37:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoojeongok' ========================2019-05-03 10:37:04======================== SELECT idx FROM macs WHERE mac_addr = '505BC2768F79720A662D' AND app_code = '039' ========================2019-05-03 10:37:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285051' ========================2019-05-03 10:37:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285051' ========================2019-05-03 10:37: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 ( '285051', '505BC2768F79720A662D', '039', 'DESKTOP-JAPUF8O', '110', '1920', '1080', 'yoojeongok', '유생금형[유정옥]', '729173377413' ) ========================2019-05-03 14:52:11======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 28E3472B188436EE7DEB sCDKey = 946760356606 sName = MSDN-SPECIAL ========================2019-05-03 14:52: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 = '946760356606' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-03 14:52:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'zaya708812' ========================2019-05-03 14:52:11======================== SELECT idx FROM macs WHERE mac_addr = '28E3472B188436EE7DEB' AND app_code = '039' ========================2019-05-03 14:52:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '146141' ========================2019-05-03 14:52:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '146141' ========================2019-05-03 14:52:11======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'zaya708812', user_name = '보람환경[이차수]', screen_w = '1366', screen_h = '768', cdkey = '946760356606' WHERE mac_idx = '146141'