========================2021-12-01 10:39:10======================== noteurl_start parm_app_code = 039 parm_pc_name = WYCOM-211130 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04DF9DEDCAAC129BC sCDKey = 735543546982 sName = WYCOM-211130 ========================2021-12-01 10:39: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 = '735543546982' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-01 10:39:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'oj1926' ========================2021-12-01 10:39:10======================== SELECT idx FROM macs WHERE mac_addr = '18C04DF9DEDCAAC129BC' AND app_code = '039' ========================2021-12-01 10:39:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355527' ========================2021-12-01 10:39:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355527' ========================2021-12-01 10:39: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 ( '355527', '18C04DF9DEDCAAC129BC', '039', 'WYCOM-211130', '110', '1920', '1080', 'oj1926', '우영기계[정윤자]', '735543546982' ) ========================2021-12-01 11:09:29======================== noteurl_start parm_app_code = 047 parm_pc_name = WIN10-01 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CFDA1E3422660505FE1 sCDKey = 107685888354 sName = WIN10-01 ========================2021-12-01 11:09: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 = '107685888354' AND r.app_code = '047' AND r.app_block = 0 ========================2021-12-01 11:09:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bear8700' ========================2021-12-01 11:09:29======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA1E3422660505FE1' AND app_code = '047' ========================2021-12-01 11:09:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355566' ========================2021-12-01 11:09:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355566' ========================2021-12-01 11:09:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355566', '2CFDA1E3422660505FE1', '047', 'WIN10-01', '�쐢�룄�슦 10', '0', '0', 'bear8700', '소잉룸(by SEWING ROOM)[김애희]', '107685888354' ) ========================2021-12-01 11:14:51======================== noteurl_start parm_app_code = 047 parm_pc_name = MASTER-2010FD parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74D4355AD4923E795EDF sCDKey = 069701217494 sName = MASTER-2010FD ========================2021-12-01 11:14:51======================== 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 = '069701217494' AND r.app_code = '047' AND r.app_block = 0 ========================2021-12-01 11:14:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'se141120' ========================2021-12-01 11:14:51======================== SELECT idx FROM macs WHERE mac_addr = '74D4355AD4923E795EDF' AND app_code = '047' ========================2021-12-01 11:14:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355567' ========================2021-12-01 11:14:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355567' ========================2021-12-01 11:14:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355567', '74D4355AD4923E795EDF', '047', 'MASTER-2010FD', '�쐢�룄�슦 10', '0', '0', 'se141120', '성은공구상사[김혜성]', '069701217494' ) ========================2021-12-01 14:52:46======================== noteurl_start parm_app_code = 050 parm_pc_name = DONGGEUN3N1128 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CDB07B0FB8A60E87628 sCDKey = 571544737699 sName = DONGGEUN3N1128 ========================2021-12-01 14:52: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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2021-12-01 14:55:06======================== noteurl_start ========================2021-12-01 14:55: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 = '' AND r.app_code = '' AND r.app_block = 0 ========================2021-12-01 14:56:15======================== noteurl_start parm_app_code = 050 parm_pc_name = DONGGEUN3N1128 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CDB07B0FB8A60E87628 sCDKey = 571544737699 sName = DONGGEUN3N1128 ========================2021-12-01 14:56: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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2021-12-01 14:56:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hancomm' ========================2021-12-01 14:56:16======================== SELECT idx FROM macs WHERE mac_addr = '2CDB07B0FB8A60E87628' AND app_code = '050' ========================2021-12-01 14:56:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355593' ========================2021-12-01 14:56:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355593' ========================2021-12-01 14:56:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355593', '2CDB07B0FB8A60E87628', '050', 'DONGGEUN3N1128', '109', '1920', '1080', 'hancomm', '한컴[이수진]', '571544737699' )