========================2019-12-02 09:04:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7NRS6SJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C860009B9462CB19079 sCDKey = 120409448074 sName = DESKTOP-7NRS6SJ ========================2019-12-02 09:04:45======================== 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 = '120409448074' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-02 09:04:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ryohan' ========================2019-12-02 09:04:45======================== SELECT idx FROM macs WHERE mac_addr = 'C860009B9462CB19079' AND app_code = '039' ========================2019-12-02 09:04:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304078' ========================2019-12-02 09:04:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304078' ========================2019-12-02 09:04:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '304078', 'C860009B9462CB19079', '039', 'DESKTOP-7NRS6SJ', '110', '1920', '1080', 'ryohan', '주식회사 비제이테크[박상진]', '120409448074' ) ========================2019-12-02 09:59:34======================== 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 = E811323663C9482BD035 sCDKey = 613018646791 sName = USER-PC ========================2019-12-02 09:59: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 = '613018646791' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-02 13:24:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8RQN9H4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D05099312FB1DC99132B sCDKey = 455125924650 sName = DESKTOP-8RQN9H4 ========================2019-12-02 13:24: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 = '455125924650' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-02 13:24:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'smsin2315' ========================2019-12-02 13:24:50======================== SELECT idx FROM macs WHERE mac_addr = 'D05099312FB1DC99132B' AND app_code = '039' ========================2019-12-02 13:24:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304153' ========================2019-12-02 13:24:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304153' ========================2019-12-02 13:24:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '304153', 'D05099312FB1DC99132B', '039', 'DESKTOP-8RQN9H4', '110', '1920', '1080', 'smsin2315', '소하리어탕국수[신수문]', '455125924650' ) ========================2019-12-02 13:59:32======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-3EGMASL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001A807F49FDBA167656 sCDKey = 990337893755 sName = 노트북테스트 ========================2019-12-02 13:59: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 = '990337893755' AND r.app_code = '047' AND r.app_block = 0 ========================2019-12-02 13:59:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2019-12-02 13:59:32======================== SELECT idx FROM macs WHERE mac_addr = '001A807F49FDBA167656' AND app_code = '047' ========================2019-12-02 13:59:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304258' ========================2019-12-02 13:59:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304258' ========================2019-12-02 13:59:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '304258', '001A807F49FDBA167656', '047', '노트북테스트', '�쐢�룄�슦 10', '0', '0', 'adam5352', '오상목해피아울렛농업회사법인(주)[해피아울렛농업회사법인(주)]테스트[오상목해피아울렛농업회사법인(주)[해피]', '990337893755' ) ========================2019-12-02 15:09:58======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-NH3LPI8 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 50E085092ED762355B28 sCDKey = 341650495865 sName = DESKTOP-NH3LPI8 ========================2019-12-02 15:09: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 = '341650495865' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-02 15:10:26======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-NH3LPI8 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 50E085092ED762355B28 sCDKey = 341650495865 sName = DESKTOP-NH3LPI8 ========================2019-12-02 15:10:26======================== 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 = '341650495865' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-02 15:12:38======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-NH3LPI8 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 50E085092ED762355B28 sCDKey = 623018646791 sName = DESKTOP-NH3LPI8 ========================2019-12-02 15:12: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 = '623018646791' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-02 15:12:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-NH3LPI8 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 50E085092ED762355B28 sCDKey = 623018646791 sName = DESKTOP-NH3LPI8 ========================2019-12-02 15:12: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 = '623018646791' AND r.app_code = '046' AND r.app_block = 0