========================2019-08-29 05:24:05======================== noteurl_start parm_app_code = 050 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E811323A9E084653DE66 sCDKey = 827961918887 sName = nevisldh ========================2019-08-29 05:24: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 = '827961918887' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-29 05:24:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nevisldh' ========================2019-08-29 05:24:05======================== SELECT idx FROM macs WHERE mac_addr = 'E811323A9E084653DE66' AND app_code = '050' ========================2019-08-29 05:24:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294279' ========================2019-08-29 05:24:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294279' ========================2019-08-29 05:24:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '294279', 'E811323A9E084653DE66', '050', 'nevisldh', '90', '1920', '1080', 'nevisldh', '이동현[이동현]', '827961918887' ) ========================2019-08-29 05:24:20======================== noteurl_start parm_app_code = 050 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E811323A9E084653DE66 sCDKey = 827961918887 sName = nevisldh ========================2019-08-29 05:24: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 = '827961918887' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-29 07:50:29======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99471E9E9067E647 sCDKey = 169591860148 sName = pos5(190829) ========================2019-08-29 07:50: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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-29 08:01:59======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99471E9E9067E647 sCDKey = 169591860148 sName = POS5(190829) ========================2019-08-29 08: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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-29 08:01:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjss064' ========================2019-08-29 08:01:59======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99471E9E9067E647' AND app_code = '046' ========================2019-08-29 08:01:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294283' ========================2019-08-29 08:01:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294283' ========================2019-08-29 08: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 ( '294283', 'B42E99471E9E9067E647', '046', 'POS5(190829)', '90', '1920', '1080', 'hjss064', '형제상사주식회사[양진규]', '169591860148' ) ========================2019-08-29 09:12:12======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E994722509067E647 sCDKey = 169591860148 sName = POS6(190829) ========================2019-08-29 09:12:12======================== 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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-29 09:12:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjss064' ========================2019-08-29 09:12:12======================== SELECT idx FROM macs WHERE mac_addr = 'B42E994722509067E647' AND app_code = '046' ========================2019-08-29 09:12:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294293' ========================2019-08-29 09:12:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294293' ========================2019-08-29 09:12:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '294293', 'B42E994722509067E647', '046', 'POS6(190829)', '90', '1920', '1080', 'hjss064', '형제상사주식회사[양진규]', '169591860148' ) ========================2019-08-29 09:58:59======================== noteurl_start parm_app_code = 045 parm_pc_name = PPSSAMWON parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7427EA0CCAA2BE7786DB sCDKey = 160292300001 sName = PPSSAMWON ========================2019-08-29 09:58: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 = '160292300001' AND r.app_code = '045' AND r.app_block = 0 ========================2019-08-29 09:58:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samwon6440' ========================2019-08-29 09:58:59======================== SELECT idx FROM macs WHERE mac_addr = '7427EA0CCAA2BE7786DB' AND app_code = '045' ========================2019-08-29 09:58:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294300' ========================2019-08-29 09:58:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294300' ========================2019-08-29 09:58: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 ( '294300', '7427EA0CCAA2BE7786DB', '045', 'PPSSAMWON', '110', '1920', '1080', 'samwon6440', '삼원유통[박범진]', '160292300001' ) ========================2019-08-29 12:28:41======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-OFFICE- parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = 2C56DC3B39E7A07C8389 sCDKey = 510930360362 sName = DESKTOP-OFFICE- ========================2019-08-29 12:28: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 = '510930360362' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-29 17:06:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OCDFFT6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7415205241538C9E1176 sCDKey = 551114429977 sName = DESKTOP-OCDFFT6 ========================2019-08-29 17:06: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 = '551114429977' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 17:06:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'selim7914' ========================2019-08-29 17:06:25======================== SELECT idx FROM macs WHERE mac_addr = '7415205241538C9E1176' AND app_code = '039' ========================2019-08-29 17:06:25======================== 값이 없을 경우 ========================2019-08-29 17:06:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OCDFFT6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7415205241538C9E1176 sCDKey = 551114429977 sName = DESKTOP-OCDFFT6 ========================2019-08-29 17:06:31======================== 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 = '551114429977' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 17:06:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'selim7914' ========================2019-08-29 17:06:31======================== SELECT idx FROM macs WHERE mac_addr = '7415205241538C9E1176' AND app_code = '039' ========================2019-08-29 17:06:31======================== 값이 없을 경우 ========================2019-08-29 17:08:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OCDFFT6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7415205241538C9E1176 sCDKey = 551114429977 sName = DESKTOP-OCDFFT6 ========================2019-08-29 17:08: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 = '551114429977' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 17:08:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'selim7914' ========================2019-08-29 17:08:40======================== SELECT idx FROM macs WHERE mac_addr = '7415205241538C9E1176' AND app_code = '039' ========================2019-08-29 17:08:40======================== 값이 없을 경우 ========================2019-08-29 20:38:21======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:38: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:38:25======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:38: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:38:56======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:38: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:39:37======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:39:37======================== 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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:40:05======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = rjd6243 ========================2019-08-29 20:40: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:40:12======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:40:12======================== 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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:40:48======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:40: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:42:52======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:42: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:42:54======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:42:56======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:42: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:42:57======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:42: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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-29 20:44:03======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-29 20:44:03======================== 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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0