========================2019-01-16 07:59:22======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-9A8SRQS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883897E060368F70999 sCDKey = 434133617514 sName = DESKTOP-9A8SRQS ========================2019-01-16 07:59: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-16 07:59:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-01-16 07:59:22======================== SELECT idx FROM macs WHERE mac_addr = '9883897E060368F70999' AND app_code = '048' ========================2019-01-16 07:59:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240015' ========================2019-01-16 07:59:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240015' ========================2019-01-16 07:59:22======================== UPDATE mac_detail SET pc_name = 'DESKTOP-9A8SRQS', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '240015' ========================2019-01-16 07:59:26======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-9A8SRQS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883897E060368F70999 sCDKey = 434133617514 sName = DESKTOP-9A8SRQS ========================2019-01-16 07:59: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-16 09:51:17======================== noteurl_start parm_app_code = 039 parm_pc_name = USER0-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6E53B98893EF1C sCDKey = 564285429917 sName = USER0-PC ========================2019-01-16 09:51:17======================== 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 = '564285429917' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-16 09:51:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejifc' ========================2019-01-16 09:51:17======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6E53B98893EF1C' AND app_code = '039' ========================2019-01-16 09:51:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274276' ========================2019-01-16 09:51:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274276' ========================2019-01-16 09:51:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274276', 'E8039A6E53B98893EF1C', '039', 'USER0-PC', '90', '1920', '1080', 'sejifc', '(주)세지에프씨[박재완]', '564285429917' ) ========================2019-01-16 09:51:48======================== noteurl_start parm_app_code = 039 parm_pc_name = JSBANG parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6E4FC98893EF1C sCDKey = 564285429917 sName = JSBANG ========================2019-01-16 09:51: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 = '564285429917' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-16 09:51:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejifc' ========================2019-01-16 09:51:48======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6E4FC98893EF1C' AND app_code = '039' ========================2019-01-16 09:51:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274275' ========================2019-01-16 09:51:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274275' ========================2019-01-16 09:51:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274275', 'E8039A6E4FC98893EF1C', '039', 'JSBANG', '90', '1920', '1080', 'sejifc', '(주)세지에프씨[박재완]', '564285429917' ) ========================2019-01-16 09:53:27======================== noteurl_start parm_app_code = 039 parm_pc_name = JHLEE parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A68A50A8893EF1C sCDKey = 564285429917 sName = JHLEE ========================2019-01-16 09:53:27======================== 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 = '564285429917' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-16 09:53:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sejifc' ========================2019-01-16 09:53:27======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A68A50A8893EF1C' AND app_code = '039' ========================2019-01-16 09:53:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274273' ========================2019-01-16 09:53:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274273' ========================2019-01-16 09:53:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274273', 'E8039A68A50A8893EF1C', '039', 'JHLEE', '90', '1920', '1080', 'sejifc', '(주)세지에프씨[박재완]', '564285429917' ) ========================2019-01-16 13:46:17======================== noteurl_start parm_app_code = 050 parm_pc_name = ROK-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1078D24A72D6C80FC73C sCDKey = 037873364154 sName = ROK-PC ========================2019-01-16 13:46:17======================== 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 = '037873364154' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-16 14:13:11======================== noteurl_start parm_app_code = 039 parm_pc_name = HJKIM parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002454FC1C6732A69AEA sCDKey = 564285429917 sName = HJKIM ========================2019-01-16 14:13:11======================== 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 = '564285429917' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-16 14:20:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-T42BQMI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE961D3C92014D2 sCDKey = 699642175334 sName = DESKTOP-T42BQMI ========================2019-01-16 14:20:42======================== 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 = '699642175334' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-16 14:20:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'as760228' ========================2019-01-16 14:20:42======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE961D3C92014D2' AND app_code = '039' ========================2019-01-16 14:20:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274323' ========================2019-01-16 14:20:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274323' ========================2019-01-16 14:20:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274323', '24F5AAE961D3C92014D2', '039', 'DESKTOP-T42BQMI', '110', '1920', '1080', 'as760228', '횡성지게차[김기영]', '699642175334' ) ========================2019-01-16 15:17:29======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80FA8278265CFF06 sCDKey = 270965864323 sName = POS2 ========================2019-01-16 15:17:29======================== 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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-16 15:17:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2019-01-16 15:17:29======================== SELECT idx FROM macs WHERE mac_addr = '94DE80FA8278265CFF06' AND app_code = '046' ========================2019-01-16 15:17:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274337' ========================2019-01-16 15:17:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274337' ========================2019-01-16 15:17:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274337', '94DE80FA8278265CFF06', '046', 'POS2', '90', '1920', '1080', 'kyr0909', '동양종합식품[김영록]', '270965864323' ) ========================2019-01-16 15:28:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-39BKA44 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3872A2AC5CA sCDKey = 772176789257 sName = DESKTOP-39BKA44 ========================2019-01-16 15:28: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 = '772176789257' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-16 15:28:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ryuej' ========================2019-01-16 15:28:32======================== SELECT idx FROM macs WHERE mac_addr = '6C299540D3872A2AC5CA' AND app_code = '039' ========================2019-01-16 15:28:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274339' ========================2019-01-16 15:28:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274339' ========================2019-01-16 15:28:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274339', '6C299540D3872A2AC5CA', '039', 'DESKTOP-39BKA44', '110', '1366', '768', 'ryuej', '정인케미칼[류은정]', '772176789257' ) ========================2019-01-16 16:05:06======================== noteurl_start parm_app_code = 046 parm_pc_name = EPSERVER parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E57A2F0DEC403C1 sCDKey = 270965864323 sName = EPSERVER ========================2019-01-16 16:05:06======================== 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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-16 16:05:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2019-01-16 16:05:06======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E57A2F0DEC403C1' AND app_code = '046' ========================2019-01-16 16:05:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248670' ========================2019-01-16 16:05:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248670' ========================2019-01-16 16:05:06======================== UPDATE mac_detail SET pc_name = 'EPSERVER', os_type = '90', user_id = 'kyr0909', user_name = '동양종합식품[김영록]', screen_w = '1920', screen_h = '1080', cdkey = '270965864323' WHERE mac_idx = '248670' ========================2019-01-16 16:05:55======================== noteurl_start parm_app_code = 046 parm_pc_name = 동양3-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D435E9A9216691C5F0 sCDKey = 270965864323 sName = 동양3-PC ========================2019-01-16 16:05: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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-16 16:05:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2019-01-16 16:05:55======================== SELECT idx FROM macs WHERE mac_addr = '74D435E9A9216691C5F0' AND app_code = '046' ========================2019-01-16 16:05:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274342' ========================2019-01-16 16:05:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274342' ========================2019-01-16 16:05: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 ( '274342', '74D435E9A9216691C5F0', '046', '동양3-PC', '90', '1920', '1080', 'kyr0909', '동양종합식품[김영록]', '270965864323' ) ========================2019-01-16 16:11:42======================== noteurl_start parm_app_code = 046 parm_pc_name = SERVER parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 408D5CFDC77A128878B5 sCDKey = C:\\Users\\R01 sName = SERVER ========================2019-01-16 16:11:42======================== 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 = 'CUSERSR01' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-16 16:16:34======================== noteurl_start parm_app_code = 046 parm_pc_name = SERVER parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 408D5CFDC77A128878B5 sCDKey = C:\\Users\\R01 sName = SERVER ========================2019-01-16 16:16: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 = 'CUSERSR01' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-16 16:16:43======================== noteurl_start parm_app_code = 046 parm_pc_name = SERVER parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 408D5CFDC77A128878B5 sCDKey = 270965864323 sName = SERVER ========================2019-01-16 16:16: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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-16 16:16:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2019-01-16 16:16:43======================== SELECT idx FROM macs WHERE mac_addr = '408D5CFDC77A128878B5' AND app_code = '046' ========================2019-01-16 16:16:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243381' ========================2019-01-16 16:16:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243381' ========================2019-01-16 16:16:43======================== UPDATE mac_detail SET pc_name = 'SERVER', os_type = '90', user_id = 'kyr0909', user_name = '동양종합식품[김영록]', screen_w = '1680', screen_h = '1050', cdkey = '270965864323' WHERE mac_idx = '243381' ========================2019-01-16 16:22:26======================== noteurl_start parm_app_code = 046 parm_pc_name = POS1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80FA807CC04558F5 sCDKey = 270965864323 sName = POS1 ========================2019-01-16 16:22: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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-16 16:22:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2019-01-16 16:22:26======================== SELECT idx FROM macs WHERE mac_addr = '94DE80FA807CC04558F5' AND app_code = '046' ========================2019-01-16 16:22:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274345' ========================2019-01-16 16:22:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274345' ========================2019-01-16 16:22: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 ( '274345', '94DE80FA807CC04558F5', '046', 'POS1', '90', '1920', '1080', 'kyr0909', '동양종합식품[김영록]', '270965864323' )