========================2020-02-27 08:24:34======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 6045CB9C24E2 sName = POS ========================2020-02-27 08:24: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 = '6045CB9C24E2' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:24:48======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 08:24: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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:24:56======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 08:24:56======================== 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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:27:20======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 003400980708 sName = DESKTOP-RIU7E7C ========================2020-02-27 08:27: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 = '003400980708' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:27:39======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 003400982708 sName = DESKTOP-RIU7E7C ========================2020-02-27 08:27: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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:28:39======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 003400982708 sName = DESKTOP-RIU7E7C ========================2020-02-27 08:28: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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:29:38======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 08:29:38======================== 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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:31:44======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 08:31: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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:36:02======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 08:36: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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:39:20======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 08:39: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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:39:33======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = admin ========================2020-02-27 08:39:33======================== 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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:39:40======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 08:39:40======================== 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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:39:53======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 08:39: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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 08:53:48======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = 최민구 ========================2020-02-27 08:53: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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 09:02:40======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = 최민구 ========================2020-02-27 09:02:40======================== 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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 09:17:51======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 397741594204 sName = DESKTOP-RIU7E7C ========================2020-02-27 09:17: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 = '397741594204' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 09:17:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyun1' ========================2020-02-27 09:17:51======================== SELECT idx FROM macs WHERE mac_addr = '9883892E09ACAA233C88' AND app_code = '046' ========================2020-02-27 09:17:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198520' ========================2020-02-27 09:17:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198520' ========================2020-02-27 09:17:51======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RIU7E7C', os_type = '110', user_id = 'hyun1', user_name = '소망매점[조재성]', screen_w = '1366', screen_h = '768', cdkey = '397741594204' WHERE mac_idx = '198520' ========================2020-02-27 09:46:35======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9C24E22F00C22 sCDKey = 383848729867 sName = POS ========================2020-02-27 09:46: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 = '383848729867' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-27 09:46:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jaewani21' ========================2020-02-27 09:46:35======================== SELECT idx FROM macs WHERE mac_addr = '6045CB9C24E22F00C22' AND app_code = '046' ========================2020-02-27 09:46:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311626' ========================2020-02-27 09:46:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311626' ========================2020-02-27 09:46:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311626', '6045CB9C24E22F00C22', '046', 'POS', '110', '1920', '1080', 'jaewani21', '청우상사[최민구]', '383848729867' ) ========================2020-02-27 13:12:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IGE3BNE parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 6C626D3D983D9CE75785 sCDKey = 892592379421 sName = DESKTOP-IGE3BNE ========================2020-02-27 13:12: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 = '892592379421' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 13:12:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gosen2012' ========================2020-02-27 13:12:20======================== SELECT idx FROM macs WHERE mac_addr = '6C626D3D983D9CE75785' AND app_code = '039' ========================2020-02-27 13:12:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311659' ========================2020-02-27 13:12:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311659' ========================2020-02-27 13:12:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311659', '6C626D3D983D9CE75785', '039', 'DESKTOP-IGE3BNE', '110', '1536', '864', 'gosen2012', '고센산업개발(주)[김은자]', '892592379421' ) ========================2020-02-27 15:33:34======================== noteurl_start parm_app_code = 039 parm_pc_name = A50PH-DESK parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 8C89A5A23F7D6200B34F sCDKey = 112661075321 sName = A50PH-DESK ========================2020-02-27 15:33: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 = '112661075321' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 15:33:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee0man' ========================2020-02-27 15:33:34======================== SELECT idx FROM macs WHERE mac_addr = '8C89A5A23F7D6200B34F' AND app_code = '039' ========================2020-02-27 15:33:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311684' ========================2020-02-27 15:33:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311684' ========================2020-02-27 15:33:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311684', '8C89A5A23F7D6200B34F', '039', 'A50PH-DESK', '110', '1280', '1024', 'lee0man', '상이재[이영만]', '112661075321' ) ========================2020-02-27 17:22:41======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-3T17EOK parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A85E45151BF488A90BDE sCDKey = 958864665488 sName = 서버pc ========================2020-02-27 17:22: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 = '958864665488' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-27 17:22:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'baket' ========================2020-02-27 17:22:41======================== SELECT idx FROM macs WHERE mac_addr = 'A85E45151BF488A90BDE' AND app_code = '047' ========================2020-02-27 17:22:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311702' ========================2020-02-27 17:22:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311702' ========================2020-02-27 17:22:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311702', 'A85E45151BF488A90BDE', '047', '서버pc', '�쐢�룄�슦 10', '0', '0', 'baket', '샤네마네킹[신경학]', '958864665488' ) ========================2020-02-27 17:22:51======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CFS2R6S parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A85E451217F20699720C sCDKey = 958864665488 sName = DESKTOP-CFS2R6S ========================2020-02-27 17:22: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 = '958864665488' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-27 17:22:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'baket' ========================2020-02-27 17:22:51======================== SELECT idx FROM macs WHERE mac_addr = 'A85E451217F20699720C' AND app_code = '047' ========================2020-02-27 17:22:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311703' ========================2020-02-27 17:22:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311703' ========================2020-02-27 17:22:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311703', 'A85E451217F20699720C', '047', 'DESKTOP-CFS2R6S', '�쐢�룄�슦 10', '0', '0', 'baket', '샤네마네킹[신경학]', '958864665488' ) ========================2020-02-27 17:22:58======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TP8ANKR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A85E45151BED3A7FECEC sCDKey = 958864665488 sName = DESKTOP-TP8ANKR ========================2020-02-27 17:22: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 = '958864665488' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-27 17:22:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'baket' ========================2020-02-27 17:22:58======================== SELECT idx FROM macs WHERE mac_addr = 'A85E45151BED3A7FECEC' AND app_code = '047' ========================2020-02-27 17:22:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311704' ========================2020-02-27 17:22:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311704' ========================2020-02-27 17:22: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 ( '311704', 'A85E45151BED3A7FECEC', '047', 'DESKTOP-TP8ANKR', '�쐢�룄�슦 10', '0', '0', 'baket', '샤네마네킹[신경학]', '958864665488' ) ========================2020-02-27 17:29:55======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파의놋북 ========================2020-02-27 17:29: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:29:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:29:55======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:29:55======================== 값이 없을 경우 ========================2020-02-27 17:30:29======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = ========================2020-02-27 17:30: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:30:39======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유니푸드텍 ========================2020-02-27 17:30: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:30:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:30:39======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:30:39======================== 값이 없을 경우 ========================2020-02-27 17:30:49======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파놋북 ========================2020-02-27 17:30: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:30:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:30:49======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:30:49======================== 값이 없을 경우 ========================2020-02-27 17:30:50======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파놋북 ========================2020-02-27 17:30: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:30:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:30:51======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:30:51======================== 값이 없을 경우 ========================2020-02-27 17:30:51======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파놋북 ========================2020-02-27 17:30: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:30:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:30:51======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:30:51======================== 값이 없을 경우 ========================2020-02-27 17:30:52======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파놋북 ========================2020-02-27 17:30:52======================== 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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:30:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:30:52======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:30:52======================== 값이 없을 경우 ========================2020-02-27 17:30:52======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파놋북 ========================2020-02-27 17:30:52======================== 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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:30:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:30:52======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:30:52======================== 값이 없을 경우 ========================2020-02-27 17:31:14======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파의놋북 ========================2020-02-27 17:31:14======================== 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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:31:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:31:14======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:31:14======================== 값이 없을 경우 ========================2020-02-27 17:34:33======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파의놋북 ========================2020-02-27 17:34:33======================== 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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:34:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:34:33======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:34:33======================== 값이 없을 경우 ========================2020-02-27 17:35:49======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파의놋북 ========================2020-02-27 17:35: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:35:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:35:49======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:35:49======================== 값이 없을 경우 ========================2020-02-27 17:37:57======================== noteurl_start parm_app_code = 039 parm_pc_name = 유주파파의놋북 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 187220524153C8045B50 sCDKey = 935851285112 sName = 유주파파의놋북 ========================2020-02-27 17:37:57======================== 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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:37:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:37:57======================== SELECT idx FROM macs WHERE mac_addr = '187220524153C8045B50' AND app_code = '039' ========================2020-02-27 17:37:57======================== 값이 없을 경우 ========================2020-02-27 17:48:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7HO8QM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99901E9CBE44694C sCDKey = 935851285112 sName = DESKTOP-L7HO8QM ========================2020-02-27 17:48:33======================== 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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-27 17:48:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-02-27 17:48:33======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99901E9CBE44694C' AND app_code = '039' ========================2020-02-27 17:48:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294609' ========================2020-02-27 17:48:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294609' ========================2020-02-27 17:48:33======================== UPDATE mac_detail SET pc_name = 'DESKTOP-L7HO8QM', os_type = '110', user_id = 'unifoodkorea', user_name = '유니푸드텍[변차환]', screen_w = '1920', screen_h = '1080', cdkey = '935851285112' WHERE mac_idx = '294609' ========================2020-02-27 18:10:01======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ONI2KP5 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F4B520225136287612B8 sCDKey = 563134336022 sName = DESKTOP-ONI2KP5 ========================2020-02-27 18:10:01======================== 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 = '563134336022' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-27 18:10:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'baegwan24' ========================2020-02-27 18:10:01======================== SELECT idx FROM macs WHERE mac_addr = 'F4B520225136287612B8' AND app_code = '047' ========================2020-02-27 18:10:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311717' ========================2020-02-27 18:10:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311717' ========================2020-02-27 18:10:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311717', 'F4B520225136287612B8', '047', 'DESKTOP-ONI2KP5', '�쐢�룄�슦 10', '0', '0', 'baegwan24', '배관공구24시송산점[고진동]', '563134336022' )