========================2024-06-19 10:12:41======================== noteurl_start parm_app_code = 051 parm_pc_name = BCWP-424012 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB87ED8F135F673557D sCDKey = 409328405866 sName = BCWP-424012 ========================2024-06-19 10:12: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 = '409328405866' AND r.app_code = '051' AND r.app_block = 0 ========================2024-06-19 10:12:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bcwp' ========================2024-06-19 10:12:41======================== SELECT idx FROM macs WHERE mac_addr = '8CB87ED8F135F673557D' AND app_code = '051' ========================2024-06-19 10:12:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407044' ========================2024-06-19 10:12:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407044' ========================2024-06-19 10:12:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407044', '8CB87ED8F135F673557D', '051', 'BCWP-424012', '109', '1920', '1080', 'bcwp', '비씨월드제약[비씨월드제약]', '409328405866' ) ========================2024-06-19 13:39:26======================== noteurl_start parm_app_code = 039 parm_pc_name = LABNPART parm_os_type = 110 parm_screen_w = 2048 parm_screen_h = 1152 parm_user_mac = 8CB0E915A0F5D0EB9932 sCDKey = 432114869519 sName = LABNPART ========================2024-06-19 13:39: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 = '432114869519' AND r.app_code = '039' AND r.app_block = 0 ========================2024-06-19 13:39:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'labnpart' ========================2024-06-19 13:39:26======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E915A0F5D0EB9932' AND app_code = '039' ========================2024-06-19 13:39:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407060' ========================2024-06-19 13:39:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407060' ========================2024-06-19 13:39:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407060', '8CB0E915A0F5D0EB9932', '039', 'LABNPART', '110', '2048', '1152', 'labnpart', '랩앤파트코리아[최영일]', '432114869519' ) ========================2024-06-19 13:39:37======================== noteurl_start parm_app_code = 039 parm_pc_name = LABNPART parm_os_type = 110 parm_screen_w = 2048 parm_screen_h = 1152 parm_user_mac = 8CB0E915A0F5D0EB9932 sCDKey = 432114869519 sName = LABNPART ========================2024-06-19 13: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 = '432114869519' AND r.app_code = '039' AND r.app_block = 0 ========================2024-06-19 16:01:09======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4VEK8DC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10FFE0090DD5827D0A5A sCDKey = 491076984531 sName = DESKTOP-4VEK8DC ========================2024-06-19 16:01: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 = '491076984531' AND r.app_code = '046' AND r.app_block = 0 ========================2024-06-19 16:01:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yipests' ========================2024-06-19 16:01:09======================== SELECT idx FROM macs WHERE mac_addr = '10FFE0090DD5827D0A5A' AND app_code = '046' ========================2024-06-19 16:01:09======================== 값이 없을 경우 ========================2024-06-19 16:01:51======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4VEK8DC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10FFE0090DD5827D0A5A sCDKey = 491076984531 sName = DESKTOP-4VEK8DC ========================2024-06-19 16:01:51======================== 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 = '491076984531' AND r.app_code = '046' AND r.app_block = 0 ========================2024-06-19 16:01:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yipests' ========================2024-06-19 16:01:51======================== SELECT idx FROM macs WHERE mac_addr = '10FFE0090DD5827D0A5A' AND app_code = '046' ========================2024-06-19 16:01:51======================== 값이 없을 경우 ========================2024-06-19 16:09:27======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4VEK8DC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10FFE0090DD5827D0A5A sCDKey = 491076984531 sName = DESKTOP-4VEK8DC ========================2024-06-19 16:09: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 = '491076984531' AND r.app_code = '046' AND r.app_block = 0 ========================2024-06-19 16:09:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yipests' ========================2024-06-19 16:09:27======================== SELECT idx FROM macs WHERE mac_addr = '10FFE0090DD5827D0A5A' AND app_code = '046' ========================2024-06-19 16:09:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407089' ========================2024-06-19 16:09:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407089' ========================2024-06-19 16:09:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407089', '10FFE0090DD5827D0A5A', '046', 'DESKTOP-4VEK8DC', '110', '1920', '1080', 'yipests', '용인농약종묘사[김정호]', '491076984531' ) ========================2024-06-19 16:09:30======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4VEK8DC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10FFE0090DD5827D0A5A sCDKey = 491076984531 sName = DESKTOP-4VEK8DC ========================2024-06-19 16:09: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 = '491076984531' AND r.app_code = '046' AND r.app_block = 0