========================2019-10-30 09:38:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KNQ7C1M parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C8FF28C79F9F12A3E273 sCDKey = 736015519448 sName = DESKTOP-KNQ7C1M ========================2019-10-30 09:38: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 = '736015519448' AND r.app_code = '039' AND r.app_block = 0 ========================2019-10-30 09:38:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tndbs12' ========================2019-10-30 09:38:26======================== SELECT idx FROM macs WHERE mac_addr = 'C8FF28C79F9F12A3E273' AND app_code = '039' ========================2019-10-30 09:38:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '299725' ========================2019-10-30 09:38:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '299725' ========================2019-10-30 09:38: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 ( '299725', 'C8FF28C79F9F12A3E273', '039', 'DESKTOP-KNQ7C1M', '110', '1920', '1080', 'tndbs12', '수복유통[김수윤]', '736015519448' ) ========================2019-10-30 11:41:41======================== noteurl_start parm_app_code = 039 parm_pc_name = 6976-MGR-ADD1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C5C8E87370BBC0300B9 sCDKey = 013564170965 sName = 6976-MGR-ADD1 ========================2019-10-30 11:41: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 = '013564170965' AND r.app_code = '039' AND r.app_block = 0 ========================2019-10-30 11:41:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qnc00294' ========================2019-10-30 11:41:41======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E87370BBC0300B9' AND app_code = '039' ========================2019-10-30 11:41:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '189712' ========================2019-10-30 11:41:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '189712' ========================2019-10-30 11:41:41======================== UPDATE mac_detail SET pc_name = '6976-MGR-ADD1', os_type = '90', user_id = 'qnc00294', user_name = '주식회사초지[정준목]', screen_w = '1920', screen_h = '1080', cdkey = '013564170965' WHERE mac_idx = '189712' ========================2019-10-30 14:46:39======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-10-30 14:46:39======================== 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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-30 14:46:49======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-10-30 14:46:49======================== 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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-30 14:46:51======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-10-30 14:46:51======================== 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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-30 14:47:35======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-10-30 14:47:35======================== 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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-30 14:47:45======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-10-30 14:47: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-30 14:48:48======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-10-30 14:48:48======================== 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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-30 14:51:26======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-10-30 14:51: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-30 15:08:32======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-10-30 15:08:32======================== 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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2019-10-30 15:17:04======================== noteurl_start parm_app_code = 039 parm_pc_name = A-PC parm_os_type = 90 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 002522A3F62D5A8D2744 sCDKey = 789105512965 sName = A-PC ========================2019-10-30 15:17:04======================== 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 = '789105512965' AND r.app_code = '039' AND r.app_block = 0 ========================2019-10-30 15:17:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeep2014' ========================2019-10-30 15:17:04======================== SELECT idx FROM macs WHERE mac_addr = '002522A3F62D5A8D2744' AND app_code = '039' ========================2019-10-30 15:17:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '193385' ========================2019-10-30 15:17:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '193385' ========================2019-10-30 15:17:04======================== UPDATE mac_detail SET pc_name = 'A-PC', os_type = '90', user_id = 'jeep2014', user_name = '태성코아[박종길]', screen_w = '1360', screen_h = '768', cdkey = '789105512965' WHERE mac_idx = '193385' ========================2019-10-30 16:59:12======================== noteurl_start parm_app_code = 050 parm_pc_name = T2580A parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = E8039A6C334D980A8610 sCDKey = 171343494665 sName = T2580A ========================2019-10-30 16:59: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 = '171343494665' AND r.app_code = '050' AND r.app_block = 0