========================2018-11-21 09:01:59======================== noteurl_start parm_app_code = 039 parm_pc_name = D-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 00226884960B929BD466 sCDKey = 964284886951 sName = D-PC ========================2018-11-21 09:01:59======================== 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 = '964284886951' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-21 09:01:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'candy3843' ========================2018-11-21 09:01:59======================== SELECT idx FROM macs WHERE mac_addr = '00226884960B929BD466' AND app_code = '039' ========================2018-11-21 09:01:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268387' ========================2018-11-21 09:01:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268387' ========================2018-11-21 09:01:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268387', '00226884960B929BD466', '039', 'D-PC', '90', '1600', '900', 'candy3843', '양구물산[박종근]', '964284886951' ) ========================2018-11-21 12:02:53======================== noteurl_start parm_app_code = 045 parm_pc_name = 김정훈부장-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002522B5CC0F562D64F8 sCDKey = 190431733807 sName = 김정훈부장-PC ========================2018-11-21 12:02:53======================== 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 = '190431733807' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-21 12:02:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sionpack' ========================2018-11-21 12:02:53======================== SELECT idx FROM macs WHERE mac_addr = '002522B5CC0F562D64F8' AND app_code = '045' ========================2018-11-21 12:02:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268421' ========================2018-11-21 12:02:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268421' ========================2018-11-21 12:02:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268421', '002522B5CC0F562D64F8', '045', '김정훈부장-PC', '90', '1920', '1080', 'sionpack', '주식회사 시온[윤창호]', '190431733807' ) ========================2018-11-21 12:15:58======================== noteurl_start parm_app_code = 045 parm_pc_name = LHS parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C22085427E078437 sCDKey = 190431733807 sName = LHS ========================2018-11-21 12:15:58======================== 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 = '190431733807' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-21 12:15:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sionpack' ========================2018-11-21 12:15:58======================== SELECT idx FROM macs WHERE mac_addr = '7085C22085427E078437' AND app_code = '045' ========================2018-11-21 12:15:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268424' ========================2018-11-21 12:15:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268424' ========================2018-11-21 12:15:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268424', '7085C22085427E078437', '045', 'LHS', '90', '1920', '1080', 'sionpack', '주식회사 시온[윤창호]', '190431733807' ) ========================2018-11-21 12:36:07======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-F5QEV9H parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 80FA5B41EFFB46CB5B8F sCDKey = 190431733807 sName = DESKTOP-F5QEV9H ========================2018-11-21 12:36:07======================== 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 = '190431733807' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-21 12:36:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sionpack' ========================2018-11-21 12:36:07======================== SELECT idx FROM macs WHERE mac_addr = '80FA5B41EFFB46CB5B8F' AND app_code = '045' ========================2018-11-21 12:36:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268427' ========================2018-11-21 12:36:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268427' ========================2018-11-21 12:36:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268427', '80FA5B41EFFB46CB5B8F', '045', 'DESKTOP-F5QEV9H', '110', '1536', '864', 'sionpack', '주식회사 시온[윤창호]', '190431733807' ) ========================2018-11-21 12:47:25======================== noteurl_start parm_app_code = 045 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F832E47151BA3CBDA936 sCDKey = 190431733807 sName = 정병희 ========================2018-11-21 12:47:25======================== 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 = '190431733807' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-21 13:44:19======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2018-11-21 13:44:19======================== 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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-21 13:46:11======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2018-11-21 13:46: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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-21 13:47:00======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2018-11-21 13:47: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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-21 13:47:53======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-SMQ1I9C parm_os_type = 109 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = E840F24C66D25CFDDFB3 sCDKey = 132377683037 sName = DESKTOP-SMQ1I9C ========================2018-11-21 13:47:53======================== 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 = '132377683037' AND r.app_code = '050' AND r.app_block = 0 ========================2018-11-21 13:47:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyn00009' ========================2018-11-21 13:47:53======================== SELECT idx FROM macs WHERE mac_addr = 'E840F24C66D25CFDDFB3' AND app_code = '050' ========================2018-11-21 13:47:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268431' ========================2018-11-21 13:47:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268431' ========================2018-11-21 13:47:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268431', 'E840F24C66D25CFDDFB3', '050', 'DESKTOP-SMQ1I9C', '109', '1280', '1024', 'hyn00009', '첨단OA[현병규]', '132377683037' ) ========================2018-11-21 13:47:58======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-SMQ1I9C parm_os_type = 109 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = E840F24C66D25CFDDFB3 sCDKey = 132377683037 sName = DESKTOP-SMQ1I9C ========================2018-11-21 13:47:58======================== 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 = '132377683037' AND r.app_code = '050' AND r.app_block = 0 ========================2018-11-21 13:52:21======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2018-11-21 13:52:21======================== 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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-21 13:52:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'groutmart' ========================2018-11-21 13:52:21======================== SELECT idx FROM macs WHERE mac_addr = '60029238BF014A97C7E2' AND app_code = '046' ========================2018-11-21 13:52:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252137' ========================2018-11-21 13:52:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252137' ========================2018-11-21 13:52:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252137', '60029238BF014A97C7E2', '046', 'MSDN-SPECIAL', '90', '1920', '1080', 'groutmart', '크린앤네이처[줄눈마트]', '573190698474' ) ========================2018-11-21 15:21:58======================== noteurl_start parm_app_code = 039 parm_pc_name = LGPC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E09154DB3BF2D8187D sCDKey = 756760173401 sName = LGPC ========================2018-11-21 15:21:58======================== 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 = '756760173401' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-21 15:21:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tkcjscjfanf1' ========================2018-11-21 15:21:58======================== SELECT idx FROM macs WHERE mac_addr = '00E09154DB3BF2D8187D' AND app_code = '039' ========================2018-11-21 15:21:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268457' ========================2018-11-21 15:21:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268457' ========================2018-11-21 15:21:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268457', '00E09154DB3BF2D8187D', '039', 'LGPC', '110', '1920', '1080', 'tkcjscjfanf1', '사천건재사[임정수]', '756760173401' ) ========================2018-11-21 15:22:05======================== noteurl_start parm_app_code = 039 parm_pc_name = LGPC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E09154DB3BF2D8187D sCDKey = 756760173401 sName = LGPC ========================2018-11-21 15:22:05======================== 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 = '756760173401' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-21 15:23:02======================== noteurl_start parm_app_code = 039 parm_pc_name = LGPC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E09154DB3BF2D8187D sCDKey = tkcjscjfanf1 sName = LGPC ========================2018-11-21 15:23:02======================== 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 = 'TKCJSCJFANF1' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-21 15:23:55======================== noteurl_start parm_app_code = 039 parm_pc_name = LGPC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E09154DB3BF2D8187D sCDKey = 756760173401 sName = LGPC ========================2018-11-21 15: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 = '756760173401' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-21 15:23:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tkcjscjfanf1' ========================2018-11-21 15:23:55======================== SELECT idx FROM macs WHERE mac_addr = '00E09154DB3BF2D8187D' AND app_code = '039' ========================2018-11-21 15:23:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268457' ========================2018-11-21 15:23:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268457' ========================2018-11-21 15:23:55======================== UPDATE mac_detail SET pc_name = 'LGPC', os_type = '110', user_id = 'tkcjscjfanf1', user_name = '사천건재사[임정수]', screen_w = '1920', screen_h = '1080', cdkey = '756760173401' WHERE mac_idx = '268457' ========================2018-11-21 15:58:04======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2018-11-21 15:58: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-21 15:58:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-21 15:58:04======================== SELECT idx FROM macs WHERE mac_addr = '98838987DB4ED87CAEF4' AND app_code = '048' ========================2018-11-21 15:58:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268463' ========================2018-11-21 15:58:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268463' ========================2018-11-21 15:58:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268463', '98838987DB4ED87CAEF4', '048', '김수영', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2018-11-21 15:58:11======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2018-11-21 15:58: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-21 15:58:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-21 15:58:11======================== SELECT idx FROM macs WHERE mac_addr = '98838987DB4ED87CAEF4' AND app_code = '048' ========================2018-11-21 15:58:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268463' ========================2018-11-21 15:58:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268463' ========================2018-11-21 15:58:11======================== UPDATE mac_detail SET pc_name = '김수영', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '268463' ========================2018-11-21 16:42:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NMF6GMN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30E46FDF12C25870 sCDKey = 412794676239 sName = industry2 ========================2018-11-21 16:42: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 = '412794676239' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-21 16:42:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'industry2' ========================2018-11-21 16:42:54======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30E46FDF12C25870' AND app_code = '039' ========================2018-11-21 16:42:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268472' ========================2018-11-21 16:42:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268472' ========================2018-11-21 16:42:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268472', 'F44D30E46FDF12C25870', '039', 'industry2', '110', '1920', '1080', 'industry2', '(주)한울[이공엽]', '412794676239' ) ========================2018-11-21 17:38:53======================== noteurl_start parm_app_code = 048 parm_pc_name = 김인영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAE563317452D593 sCDKey = 434133617514 sName = 정현일 ========================2018-11-21 17:38:53======================== 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 ========================2018-11-21 17:38:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-21 17:38:53======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE563317452D593' AND app_code = '048' ========================2018-11-21 17:38:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242764' ========================2018-11-21 17:38:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242764' ========================2018-11-21 17:38:53======================== UPDATE mac_detail SET pc_name = '정현일', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '242764' ========================2018-11-21 17:42:48======================== noteurl_start parm_app_code = 048 parm_pc_name = 강정미2018 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883898182284CA1F0E3 sCDKey = 434133617514 sName = 강정미1 ========================2018-11-21 17:42: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-21 17:42:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-21 17:42:48======================== SELECT idx FROM macs WHERE mac_addr = '9883898182284CA1F0E3' AND app_code = '048' ========================2018-11-21 17:42:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239964' ========================2018-11-21 17:42:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239964' ========================2018-11-21 17:42:48======================== UPDATE mac_detail SET pc_name = '강정미1', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '239964' ========================2018-11-21 17:50:44======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-51PMH46 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 신입사원 ========================2018-11-21 17:50: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-21 17:50:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-21 17:50:44======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEB832C5262F991' AND app_code = '048' ========================2018-11-21 17:50:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254561' ========================2018-11-21 17:50:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254561' ========================2018-11-21 17:50:44======================== UPDATE mac_detail SET pc_name = '신입사원', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '254561' ========================2018-11-21 17:50:50======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-51PMH46 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 신입사원 ========================2018-11-21 17:50:50======================== 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 ========================2018-11-21 17:50:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-21 17:50:50======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEB832C5262F991' AND app_code = '048' ========================2018-11-21 17:50:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254561' ========================2018-11-21 17:50:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254561' ========================2018-11-21 17:50:50======================== UPDATE mac_detail SET pc_name = '신입사원', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '254561'