========================2018-04-26 10:34:26======================== noteurl_start parm_app_code = 046 parm_pc_name = 2번컴-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 94DE80524BE4362A53EF sCDKey = 003375716570 sName = 2번컴-PC ========================2018-04-26 10:34: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 = '003375716570' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-26 10:34:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kky0066' ========================2018-04-26 10:34:26======================== SELECT idx FROM macs WHERE mac_addr = '94DE80524BE4362A53EF' AND app_code = '046' ========================2018-04-26 10:34:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248151' ========================2018-04-26 10:34:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248151' ========================2018-04-26 10:34: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 ( '248151', '94DE80524BE4362A53EF', '046', '2번컴-PC', '90', '1600', '900', 'kky0066', '대영안전사[김상훈]', '003375716570' ) ========================2018-04-26 13:15:20======================== noteurl_start parm_app_code = 046 parm_pc_name = NICEDOG02 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D37C90FE286409E sCDKey = 938129979397 sName = KEY ========================2018-04-26 13:15:20======================== 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 = '938129979397' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-26 13:15:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mdpet' ========================2018-04-26 13:15:20======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D37C90FE286409E' AND app_code = '046' ========================2018-04-26 13:15:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '234551' ========================2018-04-26 13:15:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '234551' ========================2018-04-26 13:15:20======================== UPDATE mac_detail SET pc_name = 'KEY', os_type = '110', user_id = 'mdpet', user_name = '엠디펫[이종원]', screen_w = '1920', screen_h = '1080', cdkey = '938129979397' WHERE mac_idx = '234551' ========================2018-04-26 16:23:49======================== noteurl_start parm_app_code = 045 parm_pc_name = parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = AC81120DA64C1AE49CAC sCDKey = 414922505537 sName = ========================2018-04-26 16:23: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 = '414922505537' AND r.app_code = '045' AND r.app_block = 0 ========================2018-04-26 16:23:55======================== noteurl_start parm_app_code = 045 parm_pc_name = parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = AC81120DA64C1AE49CAC sCDKey = 414922505537 sName = 1 ========================2018-04-26 16:23:55======================== 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 = '414922505537' AND r.app_code = '045' AND r.app_block = 0 ========================2018-04-26 16:23:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'apackace' ========================2018-04-26 16:23:55======================== SELECT idx FROM macs WHERE mac_addr = 'AC81120DA64C1AE49CAC' AND app_code = '045' ========================2018-04-26 16:23:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248252' ========================2018-04-26 16:23:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248252' ========================2018-04-26 16:23:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248252', 'AC81120DA64C1AE49CAC', '045', '1', '90', '1280', '800', 'apackace', '에이스포장자재(주)[조성민]', '414922505537' ) ========================2018-04-26 17:53:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S7C7PTU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE76B1880C1683E sCDKey = 259186709328 sName = DESKTOP-S7C7PTU ========================2018-04-26 17:53: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 = '259186709328' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-26 17:53:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimja0825' ========================2018-04-26 17:53:39======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE76B1880C1683E' AND app_code = '039' ========================2018-04-26 17:53:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248296' ========================2018-04-26 17:53:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248296' ========================2018-04-26 17:53:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248296', '24F5AAE76B1880C1683E', '039', 'DESKTOP-S7C7PTU', '110', '1920', '1080', 'kimja0825', '서정enc[김정자]', '259186709328' ) ========================2018-04-26 18:02:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FGF13FM parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F82819841C47C6028FFB sCDKey = 964167603583 sName = DESKTOP-FGF13FM ========================2018-04-26 18:02:44======================== 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 = '964167603583' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-26 18:02:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'okk526' ========================2018-04-26 18:02:44======================== SELECT idx FROM macs WHERE mac_addr = 'F82819841C47C6028FFB' AND app_code = '039' ========================2018-04-26 18:02:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248298' ========================2018-04-26 18:02:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248298' ========================2018-04-26 18:02:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248298', 'F82819841C47C6028FFB', '039', 'DESKTOP-FGF13FM', '110', '1536', '864', 'okk526', '오성테크[김오경]', '964167603583' )