========================2019-02-02 10:03:10======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-02 10:03:10======================== 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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-02 10:03:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-02 10:03:10======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-02 10:03:10======================== 값이 없을 경우 ========================2019-02-02 10:03:42======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-02 10:03: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-02 10:03:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-02 10:03:42======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-02 10:03:42======================== 값이 없을 경우 ========================2019-02-02 10:06:30======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-02 10:06:30======================== 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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-02 10:06:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-02 10:06:30======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-02 10:06:30======================== 값이 없을 경우 ========================2019-02-02 10:09:56======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-02 10:09: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-02 10:09:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-02 10:09:56======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-02 10:09:56======================== 값이 없을 경우 ========================2019-02-02 10:14:44======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-02 10:14: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-02 10:14:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-02 10:14:44======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-02 10:14:44======================== 값이 없을 경우 ========================2019-02-02 10:15:20======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-02 10: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-02 10:15:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-02 10:15:20======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-02 10:15:20======================== 값이 없을 경우 ========================2019-02-02 10:18:28======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-02 10:18:28======================== 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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-02 10:18:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-02 10:18:28======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-02 10:18:28======================== 값이 없을 경우 ========================2019-02-02 10:22:41======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-02 10: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-02 10:22:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-02 10:22:41======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-02 10:22:41======================== 값이 없을 경우 ========================2019-02-02 17:22:47======================== noteurl_start parm_app_code = 047 parm_pc_name = ASPC03-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 40B0769EDA4284C65352 sCDKey = 338944911116 sName = ASPC03-PC ========================2019-02-02 17:22:47======================== 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 = '338944911116' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-02 17:22:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nabacsa1' ========================2019-02-02 17:22:47======================== SELECT idx FROM macs WHERE mac_addr = '40B0769EDA4284C65352' AND app_code = '047' ========================2019-02-02 17:22:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276194' ========================2019-02-02 17:22:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276194' ========================2019-02-02 17:22:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '276194', '40B0769EDA4284C65352', '047', 'ASPC03-PC', '�쐢�룄�슦 7', '0', '0', 'nabacsa1', '대산자재[나대일]', '338944911116' ) ========================2019-02-02 20:24:07======================== noteurl_start parm_app_code = 047 parm_pc_name = PC08-강희국 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E1BBA46F7E4CF60 sCDKey = 338944911116 sName = PC08-강희국 ========================2019-02-02 20:24: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 = '338944911116' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-02 20:24:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nabacsa1' ========================2019-02-02 20:24:08======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E1BBA46F7E4CF60' AND app_code = '047' ========================2019-02-02 20:24:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276211' ========================2019-02-02 20:24:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276211' ========================2019-02-02 20:24:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '276211', 'E0D55E1BBA46F7E4CF60', '047', 'PC08-강희국', '�쐢�룄�슦 7', '0', '0', 'nabacsa1', '대산자재[나대일]', '338944911116' )