========================2020-06-19 13:42:45======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-1FDFBUG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99C9CDD782683067 sCDKey = 316592127001 sName = DESKTOP-1FDFBUG ========================2020-06-19 13:42: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 = '316592127001' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-19 13:42:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-19 13:42:45======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C9CDD782683067' AND app_code = '048' ========================2020-06-19 13:42:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319874' ========================2020-06-19 13:42:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319874' ========================2020-06-19 13:42:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319874', 'B42E99C9CDD782683067', '048', 'DESKTOP-1FDFBUG', '�쐢�룄�슦 10', '0', '0', 'robustmd', '로부스트엠디[오경숙]', '316592127001' ) ========================2020-06-19 15:46:00======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF7328C8C25A0E160A sCDKey = 034322302191 sName = USER-PC ========================2020-06-19 15:46:00======================== 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 = '034322302191' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-19 15:46:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yujung6852' ========================2020-06-19 15:46:00======================== SELECT idx FROM macs WHERE mac_addr = '50AF7328C8C25A0E160A' AND app_code = '046' ========================2020-06-19 15:46:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320036' ========================2020-06-19 15:46:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320036' ========================2020-06-19 15:46:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320036', '50AF7328C8C25A0E160A', '046', 'USER-PC', '90', '1024', '768', 'yujung6852', '(주)유정배관[윤경환]', '034322302191' ) ========================2020-06-19 15:52:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SP2O63J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A159176573FC6E21E3 sCDKey = 452631342040 sName = DESKTOP-SP2O63J ========================2020-06-19 15: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 = '452631342040' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-19 15:52:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adtech0202' ========================2020-06-19 15:52:46======================== SELECT idx FROM macs WHERE mac_addr = 'A8A159176573FC6E21E3' AND app_code = '039' ========================2020-06-19 15:52:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320037' ========================2020-06-19 15:52:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320037' ========================2020-06-19 15:52:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320037', 'A8A159176573FC6E21E3', '039', 'DESKTOP-SP2O63J', '110', '1920', '1080', 'adtech0202', '에이디테크[고남섭]', '452631342040' ) ========================2020-06-19 15:58:36======================== noteurl_start parm_app_code = 039 parm_pc_name = MJ468UKOIF parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003018A8C5CCC807F0A sCDKey = 452631342040 sName = MJ468UKOIF ========================2020-06-19 15:58:36======================== 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 = '452631342040' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-19 15:58:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adtech0202' ========================2020-06-19 15:58:36======================== SELECT idx FROM macs WHERE mac_addr = '003018A8C5CCC807F0A' AND app_code = '039' ========================2020-06-19 15:58:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '152593' ========================2020-06-19 15:58:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '152593' ========================2020-06-19 15:58:36======================== UPDATE mac_detail SET pc_name = 'MJ468UKOIF', os_type = '90', user_id = 'adtech0202', user_name = '에이디테크[고남섭]', screen_w = '1920', screen_h = '1080', cdkey = '452631342040' WHERE mac_idx = '152593' ========================2020-06-19 16:00:18======================== noteurl_start parm_app_code = 039 parm_pc_name = VSZ6TJUFD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDA73D78BCB68932 sCDKey = 452631342040 sName = VSZ6TJUFD ========================2020-06-19 16:00:18======================== 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 = '452631342040' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-19 16:00:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adtech0202' ========================2020-06-19 16:00:18======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDA73D78BCB68932' AND app_code = '039' ========================2020-06-19 16:00:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279714' ========================2020-06-19 16:00:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279714' ========================2020-06-19 16:00:18======================== UPDATE mac_detail SET pc_name = 'VSZ6TJUFD', os_type = '110', user_id = 'adtech0202', user_name = '에이디테크[고남섭]', screen_w = '1920', screen_h = '1080', cdkey = '452631342040' WHERE mac_idx = '279714'