========================2020-04-27 09:11:47======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN10-01 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = F0D5BF2297C3807F95C4 sCDKey = 338315316844 sName = WIN10-01 ========================2020-04-27 09:11:47======================== 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 = '338315316844' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-27 09:11:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ispa1020' ========================2020-04-27 09:11:47======================== SELECT idx FROM macs WHERE mac_addr = 'F0D5BF2297C3807F95C4' AND app_code = '039' ========================2020-04-27 09:11:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '316237' ========================2020-04-27 09:11:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '316237' ========================2020-04-27 09:11:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '316237', 'F0D5BF2297C3807F95C4', '039', 'WIN10-01', '110', '1366', '768', 'ispa1020', '스테셔너리코리아[최종진]', '338315316844' ) ========================2020-04-27 09:21:09======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JRR61MB parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 1C1B0D27672D5A0FE942 sCDKey = 020362258528 sName = DESKTOP-JRR61MB ========================2020-04-27 09:21:09======================== 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 = '020362258528' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-27 09:21:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nao2ya' ========================2020-04-27 09:21:09======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D27672D5A0FE942' AND app_code = '046' ========================2020-04-27 09:21:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '316256' ========================2020-04-27 09:21:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '316256' ========================2020-04-27 09:21:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '316256', '1C1B0D27672D5A0FE942', '046', 'DESKTOP-JRR61MB', '110', '1440', '900', 'nao2ya', '33오피스[남오희]', '020362258528' ) ========================2020-04-27 09:52:37======================== noteurl_start parm_app_code = 039 parm_pc_name = 석문철강 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A15912EA7944E92118 sCDKey = 936380938133 sName = 석문철강 ========================2020-04-27 09:52: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 = '936380938133' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-27 09:52:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gangha2' ========================2020-04-27 09:52:37======================== SELECT idx FROM macs WHERE mac_addr = 'A8A15912EA7944E92118' AND app_code = '039' ========================2020-04-27 09:52:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '316167' ========================2020-04-27 09:52:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '316167' ========================2020-04-27 09:52:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '316167', 'A8A15912EA7944E92118', '039', '석문철강', '110', '1920', '1080', 'gangha2', '석문철강[권영만]', '936380938133' ) ========================2020-04-27 13:48:43======================== noteurl_start parm_app_code = 039 parm_pc_name = SDH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B52017918E1C4E35F8 sCDKey = 870001717147 sName = SDH ========================2020-04-27 13:48:43======================== 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 = '870001717147' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-27 13:48:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nenara999' ========================2020-04-27 13:48:43======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52017918E1C4E35F8' AND app_code = '039' ========================2020-04-27 13:48:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306603' ========================2020-04-27 13:48:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306603' ========================2020-04-27 13:48:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '306603', 'F4B52017918E1C4E35F8', '039', 'SDH', '110', '1920', '1080', 'nenara999', '[성대휘]', '870001717147' ) ========================2020-04-27 14:06:34======================== noteurl_start parm_app_code = 051 parm_pc_name = LAPTOP-L8BDDINP parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D46D6D975D102EAF5312 sCDKey = 670894355181 sName = LAPTOP-L8BDDINP ========================2020-04-27 14:06: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 = '670894355181' AND r.app_code = '051' AND r.app_block = 0 ========================2020-04-27 14:06:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'across' ========================2020-04-27 14:06:34======================== SELECT idx FROM macs WHERE mac_addr = 'D46D6D975D102EAF5312' AND app_code = '051' ========================2020-04-27 14:06:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302353' ========================2020-04-27 14:06:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302353' ========================2020-04-27 14:06: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 ( '302353', 'D46D6D975D102EAF5312', '051', 'LAPTOP-L8BDDINP', '109', '1536', '864', 'across', '아크로스[김현철]', '670894355181' ) ========================2020-04-27 17:46:22======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-P0V3IET parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E5491690509A2669AF sCDKey = 084355111513 sName = DESKTOP-P0V3IET ========================2020-04-27 17:46: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 = '084355111513' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-27 17:46:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'paping68' ========================2020-04-27 17:46:22======================== SELECT idx FROM macs WHERE mac_addr = '50E5491690509A2669AF' AND app_code = '039' ========================2020-04-27 17:46:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '316318' ========================2020-04-27 17:46:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '316318' ========================2020-04-27 17:46: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 ( '316318', '50E5491690509A2669AF', '039', 'DESKTOP-P0V3IET', '110', '1920', '1080', 'paping68', '신세기통상[강인규]', '084355111513' ) ========================2020-04-27 20:08:52======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-DS1EQ87 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 1C6F659284F9EAD4AD7E sCDKey = 020362258528 sName = DESKTOP-DS1EQ87 ========================2020-04-27 20:08: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 = '020362258528' AND r.app_code = '046' AND r.app_block = 0