========================2021-04-09 09:13:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JSDUI7F parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B4B6760233A23C08F14D sCDKey = 369029175586 sName = DESKTOP-JSDUI7F ========================2021-04-09 09:13: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 = '369029175586' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-09 09:13:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kim133927' ========================2021-04-09 09:13:01======================== SELECT idx FROM macs WHERE mac_addr = 'B4B6760233A23C08F14D' AND app_code = '039' ========================2021-04-09 09:13:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340734' ========================2021-04-09 09:13:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340734' ========================2021-04-09 09:13: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 ( '340734', 'B4B6760233A23C08F14D', '039', 'DESKTOP-JSDUI7F', '110', '1600', '900', 'kim133927', '창평농원[김미경]', '369029175586' ) ========================2021-04-09 10:39:32======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:39: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:39:59======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:39: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:01======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:04======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:05======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:05======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:06======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:06======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:06======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:07======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:07======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:07======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:08======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40:08======================== 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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:08======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40:08======================== 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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:08======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40:08======================== 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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:09======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40:09======================== 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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:09======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40:09======================== 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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:10======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:27======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:29======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:29======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:30======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:31======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:40:55======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:40: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:42:48======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 10:42:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ecstel' ========================2021-04-09 10:42:48======================== SELECT idx FROM macs WHERE mac_addr = '505BC282C5BD8846AC8E' AND app_code = '050' ========================2021-04-09 10:42:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340773' ========================2021-04-09 10:42:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340773' ========================2021-04-09 10:42: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 ( '340773', '505BC282C5BD8846AC8E', '050', 'DESKTOP-LAM4QLA', '109', '1536', '864', 'ecstel', '(주)이씨에스텔레콤[유지해]', '452775506015' ) ========================2021-04-09 10:42:58======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-LAM4QLA parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 505BC282C5BD8846AC8E sCDKey = 452775506015 sName = DESKTOP-LAM4QLA ========================2021-04-09 10:42: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2021-04-09 15:12:35======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-TLIM80K parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99E7A5A2AAB7DA2A sCDKey = 959984696638 sName = DESKTOP-TLIM80K ========================2021-04-09 15:12: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 = '959984696638' AND r.app_code = '046' AND r.app_block = 0 ========================2021-04-09 15:21:00======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-TLIM80K parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99E7A5A2AAB7DA2A sCDKey = 959984696638 sName = DESKTOP-TLIM80K ========================2021-04-09 15:21: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 = '959984696638' AND r.app_code = '046' AND r.app_block = 0 ========================2021-04-09 15:21:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ys8230884' ========================2021-04-09 15:21:00======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99E7A5A2AAB7DA2A' AND app_code = '046' ========================2021-04-09 15:21:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340783' ========================2021-04-09 15:21:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340783' ========================2021-04-09 15:21:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '340783', 'B42E99E7A5A2AAB7DA2A', '046', 'DESKTOP-TLIM80K', '110', '1920', '1080', 'ys8230884', '(주)유성건재철물[정연순]', '959984696638' ) ========================2021-04-09 15:21:11======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-TLIM80K parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99E7A5A2AAB7DA2A sCDKey = 959984696638 sName = DESKTOP-TLIM80K ========================2021-04-09 15:21: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 = '959984696638' AND r.app_code = '046' AND r.app_block = 0 ========================2021-04-09 15:49:39======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-AP85CC0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389823A85A178BA8A sCDKey = 002237082777 sName = DESKTOP-AP85CC0 ========================2021-04-09 15:49: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 = '002237082777' AND r.app_code = '045' AND r.app_block = 0 ========================2021-04-09 15:49:55======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-AP85CC0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389823A85A178BA8A sCDKey = 002237082777 sName = DESKTOP-AP85CC0 ========================2021-04-09 15:49: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 = '002237082777' AND r.app_code = '045' AND r.app_block = 0 ========================2021-04-09 15:49:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eunfish' ========================2021-04-09 15:49:55======================== SELECT idx FROM macs WHERE mac_addr = '988389823A85A178BA8A' AND app_code = '045' ========================2021-04-09 15:49:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340807' ========================2021-04-09 15:49:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340807' ========================2021-04-09 15:49: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 ( '340807', '988389823A85A178BA8A', '045', 'DESKTOP-AP85CC0', '110', '1920', '1080', 'eunfish', '주식회사 다솔낚시마트[최홍식]', '002237082777' ) ========================2021-04-09 17:01:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8GR975F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E9180F76A2B4EEE5 sCDKey = 017172186970 sName = samhan2003 ========================2021-04-09 17:01: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 = '017172186970' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-09 17:01:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samhan2003' ========================2021-04-09 17:01:11======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9180F76A2B4EEE5' AND app_code = '039' ========================2021-04-09 17:01:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340819' ========================2021-04-09 17:01:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340819' ========================2021-04-09 17:01:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '340819', '8CB0E9180F76A2B4EEE5', '039', 'samhan2003', '110', '1920', '1080', 'samhan2003', '삼한산업(주)[한상희]', '017172186970' ) ========================2021-04-09 17:10:07======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = C83A35C8BE742F43F70 sCDKey = 217223037343 sName = OFFICE-PC ========================2021-04-09 17:10: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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-09 17:10:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunjin677' ========================2021-04-09 17:10:07======================== SELECT idx FROM macs WHERE mac_addr = 'C83A35C8BE742F43F70' AND app_code = '039' ========================2021-04-09 17:10:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340821' ========================2021-04-09 17:10:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340821' ========================2021-04-09 17:10: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 ( '340821', 'C83A35C8BE742F43F70', '039', 'OFFICE-PC', '110', '1280', '1024', 'sunjin677', '선진FS[김형희]', '217223037343' )