========================2021-11-30 13:47:08======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7ATUVDS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 10F0056B8627EC27A63B sCDKey = 588524411493 sName = DESKTOP-7ATUVDS ========================2021-11-30 13:47:08======================== 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 = '588524411493' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-30 13:47:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onemart2019' ========================2021-11-30 13:47:08======================== SELECT idx FROM macs WHERE mac_addr = '10F0056B8627EC27A63B' AND app_code = '047' ========================2021-11-30 13:47:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355498' ========================2021-11-30 13:47:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355498' ========================2021-11-30 13:47:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355498', '10F0056B8627EC27A63B', '047', 'DESKTOP-7ATUVDS', '�쐢�룄�슦 10', '0', '0', 'onemart2019', 'ONEmart[송웅]', '588524411493' ) ========================2021-11-30 14:00:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9ACE4K9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99486A736684C8BD sCDKey = 708397078054 sName = DESKTOP-9ACE4K9 ========================2021-11-30 14:00:26======================== 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 = '708397078054' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-30 14:00:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'osm1950' ========================2021-11-30 14:00:26======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99486A736684C8BD' AND app_code = '039' ========================2021-11-30 14:00:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355502' ========================2021-11-30 14:00:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355502' ========================2021-11-30 14:00:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355502', 'B42E99486A736684C8BD', '039', 'DESKTOP-9ACE4K9', '110', '1920', '1080', 'osm1950', '성화상사[오승하]', '708397078054' ) ========================2021-11-30 15:52:54======================== noteurl_start parm_app_code = 046 parm_pc_name = HJH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 221315588543 sName = HJH-PC ========================2021-11-30 15:52:54======================== 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 = '221315588543' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-30 15:52:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2021-11-30 15:52:54======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '046' ========================2021-11-30 15:52:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244420' ========================2021-11-30 15:52:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244420' ========================2021-11-30 15:52:54======================== UPDATE mac_detail SET pc_name = 'HJH-PC', os_type = '110', user_id = 'wogus36', user_name = '[황재현]', screen_w = '1920', screen_h = '1080', cdkey = '221315588543' WHERE mac_idx = '244420' ========================2021-11-30 17:58:01======================== noteurl_start parm_app_code = 039 parm_pc_name = JIYE parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 74D43506B816261E2F40 sCDKey = 893947322630 sName = JIYE ========================2021-11-30 17:58:01======================== 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 = '893947322630' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-30 17:58:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sambopt' ========================2021-11-30 17:58:01======================== SELECT idx FROM macs WHERE mac_addr = '74D43506B816261E2F40' AND app_code = '039' ========================2021-11-30 17:58:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355532' ========================2021-11-30 17:58:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355532' ========================2021-11-30 17:58:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355532', '74D43506B816261E2F40', '039', 'JIYE', '110', '1680', '1050', 'sambopt', '삼보인쇄공사[손주혜]', '893947322630' )