========================2020-11-30 09:11:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G3IKR0B parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E81132399CD1433EE5FD sCDKey = 097696787204 sName = DESKTOP-G3IKR0B ========================2020-11-30 09:11:55======================== 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 = '097696787204' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-30 09:11:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'st0366' ========================2020-11-30 09:11:56======================== SELECT idx FROM macs WHERE mac_addr = 'E81132399CD1433EE5FD' AND app_code = '039' ========================2020-11-30 09:11:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331164' ========================2020-11-30 09:11:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331164' ========================2020-11-30 09:11:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331164', 'E81132399CD1433EE5FD', '039', 'DESKTOP-G3IKR0B', '110', '1680', '1050', 'st0366', '성태산업[권성태]', '097696787204' ) ========================2020-11-30 10:01:19======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-ISNNBLQ parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 18C04D22E7775614344E sCDKey = 382658505643 sName = DESKTOP-ISNNBLQ ========================2020-11-30 10:01:19======================== 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 = '382658505643' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-30 10:01:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kec1211' ========================2020-11-30 10:01:19======================== SELECT idx FROM macs WHERE mac_addr = '18C04D22E7775614344E' AND app_code = '046' ========================2020-11-30 10:01:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '328751' ========================2020-11-30 10:01:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '328751' ========================2020-11-30 10:01:19======================== UPDATE mac_detail SET pc_name = 'DESKTOP-ISNNBLQ', os_type = '110', user_id = 'kec1211', user_name = '천지유통(김기호)[김기호]', screen_w = '1600', screen_h = '900', cdkey = '382658505643' WHERE mac_idx = '328751' ========================2020-11-30 13:36:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-AV82A8G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6C626D3D983DC9061C20 sCDKey = 892592379421 sName = DESKTOP-AV82A8G ========================2020-11-30 13:36:53======================== 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 = '892592379421' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-30 13:36:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gosen2012' ========================2020-11-30 13:36:53======================== SELECT idx FROM macs WHERE mac_addr = '6C626D3D983DC9061C20' AND app_code = '039' ========================2020-11-30 13:36:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331199' ========================2020-11-30 13:36:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331199' ========================2020-11-30 13:36:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331199', '6C626D3D983DC9061C20', '039', 'DESKTOP-AV82A8G', '110', '1920', '1080', 'gosen2012', '고센산업개발(주)[김은자]', '892592379421' ) ========================2020-11-30 15:14:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FSNSORQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = DC41A9EA3BA72A178231 sCDKey = 057096428680 sName = DESKTOP-FSNSORQ ========================2020-11-30 15:14:14======================== 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 = '057096428680' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-30 15:14:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youngji1226' ========================2020-11-30 15:14:14======================== SELECT idx FROM macs WHERE mac_addr = 'DC41A9EA3BA72A178231' AND app_code = '039' ========================2020-11-30 15:14:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331218' ========================2020-11-30 15:14:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331218' ========================2020-11-30 15:14:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331218', 'DC41A9EA3BA72A178231', '039', 'DESKTOP-FSNSORQ', '110', '1920', '1080', 'youngji1226', '(주)영지테크[(주)영지테크]', '057096428680' ) ========================2020-11-30 16:10:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KLMDT37 parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 18C04D75108852349CED sCDKey = 067129850891 sName = DESKTOP-KLMDT37 ========================2020-11-30 16:10: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 = '067129850891' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-30 16:10:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kou8822' ========================2020-11-30 16:10:12======================== SELECT idx FROM macs WHERE mac_addr = '18C04D75108852349CED' AND app_code = '039' ========================2020-11-30 16:10:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331226' ========================2020-11-30 16:10:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331226' ========================2020-11-30 16:10:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331226', '18C04D75108852349CED', '039', 'DESKTOP-KLMDT37', '110', '1360', '768', 'kou8822', '나산상사[구자복]', '067129850891' )