========================2020-02-07 09:22:47======================== noteurl_start parm_app_code = 047 parm_pc_name = DAEKWANG parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA14A1C549EAA1BE74 sCDKey = 573223153338 sName = DAEKWANG ========================2020-02-07 09: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 = '573223153338' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-07 09:22:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'shyotdari' ========================2020-02-07 09:22:47======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14A1C549EAA1BE74' AND app_code = '047' ========================2020-02-07 09:22:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271500' ========================2020-02-07 09:22:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271500' ========================2020-02-07 09:22:47======================== UPDATE mac_detail SET pc_name = 'DAEKWANG', os_type = '�쐢�룄�슦 7', user_id = 'shyotdari', user_name = '대광악세사리[김승남]', screen_w = '0', screen_h = '0', cdkey = '573223153338' WHERE mac_idx = '271500' ========================2020-02-07 09:28:59======================== noteurl_start parm_app_code = 047 parm_pc_name = ACC-MOM parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E14A3A1D4FF9A28 sCDKey = 573223153338 sName = ACC-MOM ========================2020-02-07 09:28: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 = '573223153338' AND r.app_code = '047' AND r.app_block = 0 ========================2020-02-07 09:28:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'shyotdari' ========================2020-02-07 09:28:59======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E14A3A1D4FF9A28' AND app_code = '047' ========================2020-02-07 09:28:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271501' ========================2020-02-07 09:28:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271501' ========================2020-02-07 09:28:59======================== UPDATE mac_detail SET pc_name = 'ACC-MOM', os_type = '�쐢�룄�슦 7', user_id = 'shyotdari', user_name = '대광악세사리[김승남]', screen_w = '0', screen_h = '0', cdkey = '573223153338' WHERE mac_idx = '271501' ========================2020-02-07 10:48:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FE7R8VG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6E8E0ACAD69DDA9B2A92 sCDKey = 378087224489 sName = DESKTOP-FE7R8VG ========================2020-02-07 10:48: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 = '378087224489' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-07 10:48:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jyounger72' ========================2020-02-07 10:48:39======================== SELECT idx FROM macs WHERE mac_addr = '6E8E0ACAD69DDA9B2A92' AND app_code = '039' ========================2020-02-07 10:48:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310037' ========================2020-02-07 10:48:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310037' ========================2020-02-07 10:48:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310037', '6E8E0ACAD69DDA9B2A92', '039', 'DESKTOP-FE7R8VG', '110', '1920', '1080', 'jyounger72', 'Easy-M[이제영]', '378087224489' ) ========================2020-02-07 10:48:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FE7R8VG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6E8E0ACAD69DDA9B2A92 sCDKey = 378087224489 sName = DESKTOP-FE7R8VG ========================2020-02-07 10:48: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 = '378087224489' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-07 10:53:20======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A8D1E01800B9B0F sCDKey = 109328527074 sName = OKPOS ========================2020-02-07 10:53: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 = '109328527074' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-07 10:53:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lyj3274' ========================2020-02-07 10:53:20======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A8D1E01800B9B0F' AND app_code = '046' ========================2020-02-07 10:53:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310038' ========================2020-02-07 10:53:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310038' ========================2020-02-07 10:53: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 ( '310038', 'B8975A8D1E01800B9B0F', '046', 'OKPOS', '64', '1024', '768', 'lyj3274', '애견용품할인매장[김명기]', '109328527074' ) ========================2020-02-07 13:35:49======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41CCD7A68C7CAFB sCDKey = 591867603635 sName = OKPOS ========================2020-02-07 13: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 = '591867603635' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-07 13:35:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n1352244271' ========================2020-02-07 13:35:49======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41CCD7A68C7CAFB' AND app_code = '046' ========================2020-02-07 13:35:49======================== 값이 없을 경우 ========================2020-02-07 13:36:47======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41CCD7A68C7CAFB sCDKey = 591867603635 sName = OKPOS ========================2020-02-07 13:36: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 = '591867603635' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-07 13:36:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n1352244271' ========================2020-02-07 13:36:47======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41CCD7A68C7CAFB' AND app_code = '046' ========================2020-02-07 13:36:47======================== 값이 없을 경우 ========================2020-02-07 13:39:22======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41CCD7A68C7CAFB sCDKey = 591867603635 sName = OKPOS ========================2020-02-07 13:39:22======================== 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 = '591867603635' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-07 13:39:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n1352244271' ========================2020-02-07 13:39:22======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41CCD7A68C7CAFB' AND app_code = '046' ========================2020-02-07 13:39:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310063' ========================2020-02-07 13:39:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310063' ========================2020-02-07 13:39:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310063', '68EDA41CCD7A68C7CAFB', '046', 'OKPOS', '110', '1024', '768', 'n1352244271', '신원종합주방[임상혁]', '591867603635' ) ========================2020-02-07 13:39:32======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41CCD7A68C7CAFB sCDKey = 591867603635 sName = 신원주방 ========================2020-02-07 13: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 = '591867603635' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-07 17:04:48======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-6E20C07 parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = ACFDCEDE5A5DFEF865B4 sCDKey = 003401679376 sName = DESKTOP-6E20C07 ========================2020-02-07 17:04: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2020-02-07 17:05:14======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-6E20C07 parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = ACFDCEDE5A5DFEF865B4 sCDKey = 003401679376 sName = 자산(서초) ========================2020-02-07 17:05: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2020-02-07 17:06:22======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-6E20C07 parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = ACFDCEDE5A5DFEF865B4 sCDKey = 003401679367 sName = 자산(서초) ========================2020-02-07 17:06:22======================== 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 = '003401679367' AND r.app_code = '051' AND r.app_block = 0 ========================2020-02-07 17:06:37======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-6E20C07 parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = ACFDCEDE5A5DFEF865B4 sCDKey = 003401679376 sName = 자산(서초) ========================2020-02-07 17:06: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2020-02-07 17:10:46======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-6E20C07 parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = ACFDCEDE5A5DFEF865B4 sCDKey = 003401679376 sName = 자산(서초) ========================2020-02-07 17:10:46======================== 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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2020-02-07 17:10:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2020-02-07 17:10:46======================== SELECT idx FROM macs WHERE mac_addr = 'ACFDCEDE5A5DFEF865B4' AND app_code = '051' ========================2020-02-07 17:10:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310100' ========================2020-02-07 17:10:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310100' ========================2020-02-07 17:10:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310100', 'ACFDCEDE5A5DFEF865B4', '051', '자산(서초)', '109', '1366', '768', 'skinfosec', '인포섹[이대윤]', '003401679376' )