========================2020-07-24 09:38:22======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FFU158G parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 34CFF63B340902F63433 sCDKey = 434133617514 sName = DESKTOP-FFU158G ========================2020-07-24 09:38: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-24 09:38:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2020-07-24 09:38:22======================== SELECT idx FROM macs WHERE mac_addr = '34CFF63B340902F63433' AND app_code = '048' ========================2020-07-24 09:38:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322330' ========================2020-07-24 09:38:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322330' ========================2020-07-24 09:38:22======================== UPDATE mac_detail SET pc_name = 'DESKTOP-FFU158G', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '322330' ========================2020-07-24 15:49:51======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-F0LCQ4F parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99C4527770E9B22A sCDKey = 780547338320 sName = 오승용 ========================2020-07-24 15:49: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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-24 15:49:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-07-24 15:49:51======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C4527770E9B22A' AND app_code = '048' ========================2020-07-24 15:49:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322594' ========================2020-07-24 15:49:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322594' ========================2020-07-24 15:49:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322594', 'B42E99C4527770E9B22A', '048', '오승용', '�쐢�룄�슦 10', '0', '0', 'aone0022', '(주)에이원메디칼[강창중]', '780547338320' ) ========================2020-07-24 16:05:32======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-76STLVG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E5369E3B2C3FA8B sCDKey = 965956583563 sName = DESKTOP-76STLVG ========================2020-07-24 16:05: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 = '965956583563' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-24 16:06:10======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-76STLVG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E5369E3B2C3FA8B sCDKey = 965986583563 sName = DESKTOP-76STLVG ========================2020-07-24 16:06: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 = '965986583563' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-24 16:06:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sevenbike' ========================2020-07-24 16:06:10======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E5369E3B2C3FA8B' AND app_code = '046' ========================2020-07-24 16:06:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322599' ========================2020-07-24 16:06:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322599' ========================2020-07-24 16:06:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322599', 'E0D55E5369E3B2C3FA8B', '046', 'DESKTOP-76STLVG', '110', '1920', '1080', 'sevenbike', '세븐바이크[김필태]', '965986583563' ) ========================2020-07-24 16:06:13======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-76STLVG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E5369E3B2C3FA8B sCDKey = 965986583563 sName = DESKTOP-76STLVG ========================2020-07-24 16:06:13======================== 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 = '965986583563' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-24 16:06:30======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-76STLVG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E5369E3B2C3FA8B sCDKey = 965986583563 sName = DESKTOP-76STLVG ========================2020-07-24 16:06: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 = '965986583563' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-24 16:09:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OA07 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8113236CC10980C6F13 sCDKey = 291853185304 sName = DESKTOP-OA07 ========================2020-07-24 16:09:21======================== 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 = '291853185304' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-24 16:09:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ch11963' ========================2020-07-24 16:09:22======================== SELECT idx FROM macs WHERE mac_addr = 'E8113236CC10980C6F13' AND app_code = '039' ========================2020-07-24 16:09:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322600' ========================2020-07-24 16:09:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322600' ========================2020-07-24 16:09: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 ( '322600', 'E8113236CC10980C6F13', '039', 'DESKTOP-OA07', '110', '1600', '900', 'ch11963', '신창코팅[최완규]', '291853185304' ) ========================2020-07-24 16:13:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3PCHVJ0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A697FFE9464BA10 sCDKey = 539630984489 sName = DESKTOP-3PCHVJ0 ========================2020-07-24 16:13: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 = '539630984489' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-24 16:13:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori7889' ========================2020-07-24 16:13:34======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A697FFE9464BA10' AND app_code = '039' ========================2020-07-24 16:13:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322601' ========================2020-07-24 16:13:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322601' ========================2020-07-24 16:13:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322601', 'E8039A697FFE9464BA10', '039', 'DESKTOP-3PCHVJ0', '110', '1920', '1080', 'woori7889', '우리철강주식회사[김영춘]', '539630984489' ) ========================2020-07-24 16:31:43======================== noteurl_start parm_app_code = 045 parm_pc_name = NOTEBOOK1 parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 0013027FD60A98E50522 sCDKey = 413363772239 sName = NOTEBOOK1 ========================2020-07-24 16:31:43======================== 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 = '413363772239' AND r.app_code = '045' AND r.app_block = 0 ========================2020-07-24 16:31:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gwangrim' ========================2020-07-24 16:31:43======================== SELECT idx FROM macs WHERE mac_addr = '0013027FD60A98E50522' AND app_code = '045' ========================2020-07-24 16:31:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322602' ========================2020-07-24 16:31:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322602' ========================2020-07-24 16:31:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322602', '0013027FD60A98E50522', '045', 'NOTEBOOK1', '90', '1280', '800', 'gwangrim', '광림장갑[김규휴]', '413363772239' )