========================2021-01-09 14:54:22======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GS5D17G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB05191027AB8D sCDKey = 865918677414 sName = SUBPOS ========================2021-01-09 14:54: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 = '865918677414' AND r.app_code = '046' AND r.app_block = 0 ========================2021-01-09 14:55:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GS5D17G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB05191027AB8D sCDKey = 865918677414 sName = SUBPOS ========================2021-01-09 14:55: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 = '865918677414' AND r.app_code = '046' AND r.app_block = 0 ========================2021-01-09 14:59:00======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GS5D17G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB05191027AB8D sCDKey = 865918677414 sName = DESKTOP-GS5D17G ========================2021-01-09 14:59: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 = '865918677414' AND r.app_code = '046' AND r.app_block = 0 ========================2021-01-09 15:03:03======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GS5D17G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB05191027AB8D sCDKey = 865918677414 sName = SUBPOS ========================2021-01-09 15:03: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 = '865918677414' AND r.app_code = '046' AND r.app_block = 0 ========================2021-01-09 15:03:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sprit01' ========================2021-01-09 15:03:03======================== SELECT idx FROM macs WHERE mac_addr = 'E89A8FDB05191027AB8D' AND app_code = '046' ========================2021-01-09 15:03:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334355' ========================2021-01-09 15:03:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334355' ========================2021-01-09 15:03:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334355', 'E89A8FDB05191027AB8D', '046', 'SUBPOS', '110', '1920', '1080', 'sprit01', '신화종합상사[이재훈]', '865918677414' ) ========================2021-01-09 21:53:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E36D988F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2021-01-09 21:53: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-09 21:53:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E36D988F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2021-01-09 21:53: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-09 21:54:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E36D988F85E5384 sCDKey = 88366CF09F9 sName = DESKTOP-IHIELAL ========================2021-01-09 21:54: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 = '88366CF09F9' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-09 21:56:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E36D988F85E5384 sCDKey = 34938-shinds sName = DESKTOP-IHIELAL ========================2021-01-09 21:56: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 = '34938SHINDS' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-09 21:58:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E36D988F85E5384 sCDKey = 34938-shinds sName = DESKTOP-IHIELAL ========================2021-01-09 21:58: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 = '34938SHINDS' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-09 23:08:51======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-P5U8F3L parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74E50B9C3A9038292B33 sCDKey = 865918677414 sName = SUBPOS ========================2021-01-09 23:08: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 = '865918677414' AND r.app_code = '046' AND r.app_block = 0 ========================2021-01-09 23:10:02======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-P5U8F3L parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74E50B9C3A9038292B33 sCDKey = 865918677414 sName = SUBPOS ========================2021-01-09 23:10:02======================== 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 = '865918677414' AND r.app_code = '046' AND r.app_block = 0 ========================2021-01-09 23:10:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sprit01' ========================2021-01-09 23:10:02======================== SELECT idx FROM macs WHERE mac_addr = '74E50B9C3A9038292B33' AND app_code = '046' ========================2021-01-09 23:10:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334376' ========================2021-01-09 23:10:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334376' ========================2021-01-09 23:10:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334376', '74E50B9C3A9038292B33', '046', 'SUBPOS', '110', '1920', '1080', 'sprit01', '신화종합상사[이재훈]', '865918677414' )