========================2020-09-07 10:43:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RHVL1L8 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838940143BF8332091 sCDKey = 880547373888 sName = DESKTOP-RHVL1L8 ========================2020-09-07 10:43: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 = '880547373888' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-07 10:43:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onelife3' ========================2020-09-07 10:43:41======================== SELECT idx FROM macs WHERE mac_addr = '98838940143BF8332091' AND app_code = '039' ========================2020-09-07 10:43:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236760' ========================2020-09-07 10:43:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236760' ========================2020-09-07 10:43:41======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RHVL1L8', os_type = '110', user_id = 'onelife3', user_name = '[이영숙]', screen_w = '1920', screen_h = '1080', cdkey = '880547373888' WHERE mac_idx = '236760' ========================2020-09-07 12:30:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L68QQ5D parm_os_type = 110 parm_screen_w = 1707 parm_screen_h = 1067 parm_user_mac = 9C29767E07CAC6C49875 sCDKey = 682850602194 sName = DESKTOP-L68QQ5D ========================2020-09-07 12:30:45======================== 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 = '682850602194' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-07 12:32:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L68QQ5D parm_os_type = 110 parm_screen_w = 1707 parm_screen_h = 1067 parm_user_mac = 9C29767E07CAC6C49875 sCDKey = 682850602194 sName = DESKTOP-L68QQ5D ========================2020-09-07 12:32:40======================== 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 = '682850602194' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-07 12:32:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klosed' ========================2020-09-07 12:32:40======================== SELECT idx FROM macs WHERE mac_addr = '9C29767E07CAC6C49875' AND app_code = '039' ========================2020-09-07 12:32:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '325683' ========================2020-09-07 12:32:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '325683' ========================2020-09-07 12:32:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '325683', '9C29767E07CAC6C49875', '039', 'DESKTOP-L68QQ5D', '110', '1707', '1067', 'klosed', '아성유리문[양세훈]', '682850602194' ) ========================2020-09-07 14:14:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DDNOFRU parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 1063C8C1387B9C739166 sCDKey = 246014889207 sName = DESKTOP-DDNOFRU ========================2020-09-07 14:14: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 = '246014889207' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-07 14:14:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sum907' ========================2020-09-07 14:14:29======================== SELECT idx FROM macs WHERE mac_addr = '1063C8C1387B9C739166' AND app_code = '039' ========================2020-09-07 14:14:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '325700' ========================2020-09-07 14:14:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '325700' ========================2020-09-07 14:14: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 ( '325700', '1063C8C1387B9C739166', '039', 'DESKTOP-DDNOFRU', '110', '1280', '720', 'sum907', '성심산업[전우배]', '246014889207' ) ========================2020-09-07 15:29:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LS36GJD parm_os_type = 110 parm_screen_w = 1344 parm_screen_h = 840 parm_user_mac = D050991F2C14127D4B80 sCDKey = 259119579505 sName = DESKTOP-LS36GJD ========================2020-09-07 15:29:13======================== 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 = '259119579505' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-07 15:29:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dptmdkdl1' ========================2020-09-07 15:29:13======================== SELECT idx FROM macs WHERE mac_addr = 'D050991F2C14127D4B80' AND app_code = '039' ========================2020-09-07 15:29:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '325688' ========================2020-09-07 15:29:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '325688' ========================2020-09-07 15:29:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '325688', 'D050991F2C14127D4B80', '039', 'DESKTOP-LS36GJD', '110', '1344', '840', 'dptmdkdl1', '에스아이[에스아이]', '259119579505' ) ========================2020-09-07 15:29:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LS36GJD parm_os_type = 110 parm_screen_w = 1344 parm_screen_h = 840 parm_user_mac = D050991F2C14127D4B80 sCDKey = 259119579505 sName = DESKTOP-LS36GJD ========================2020-09-07 15:29:17======================== 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 = '259119579505' AND r.app_code = '039' AND r.app_block = 0