========================2019-01-29 08:28:07======================== noteurl_start parm_app_code = 047 parm_pc_name = LG-NOTE parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A0D37A1F822C24F65851 sCDKey = 106230963000 sName = LG-NOTE ========================2019-01-29 08:28:07======================== 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 = '106230963000' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-29 08:28:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lim8813' ========================2019-01-29 08:28:07======================== SELECT idx FROM macs WHERE mac_addr = 'A0D37A1F822C24F65851' AND app_code = '047' ========================2019-01-29 08:28:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275689' ========================2019-01-29 08:28:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275689' ========================2019-01-29 08:28:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275689', 'A0D37A1F822C24F65851', '047', 'LG-NOTE', '�쐢�룄�슦 10', '0', '0', 'lim8813', '서진아이엔디[임길재]', '106230963000' ) ========================2019-01-29 11:01:03======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-F82TLVA parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8C49750E4F8E8052BA9 sCDKey = 169780446996 sName = DESKTOP-F82TLVA ========================2019-01-29 11:01: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 = '169780446996' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-29 11:01:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sora2' ========================2019-01-29 11:01:03======================== SELECT idx FROM macs WHERE mac_addr = 'D8C49750E4F8E8052BA9' AND app_code = '050' ========================2019-01-29 11:01:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275699' ========================2019-01-29 11:01:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275699' ========================2019-01-29 11:01: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 ( '275699', 'D8C49750E4F8E8052BA9', '050', 'DESKTOP-F82TLVA', '109', '1920', '1080', 'sora2', 'SKSTOA[이소라]', '169780446996' ) ========================2019-01-29 15:10:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DV6L40T parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897FFC1DC056AA17 sCDKey = 926112676290 sName = DESKTOP-DV6L40T ========================2019-01-29 15:10: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 = '926112676290' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-29 15:10:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bfcwp' ========================2019-01-29 15:10:37======================== SELECT idx FROM macs WHERE mac_addr = '9883897FFC1DC056AA17' AND app_code = '039' ========================2019-01-29 15:10:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275738' ========================2019-01-29 15:10:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275738' ========================2019-01-29 15:10:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275738', '9883897FFC1DC056AA17', '039', 'DESKTOP-DV6L40T', '110', '1920', '1080', 'bfcwp', '비에프코리아[박종운]', '926112676290' ) ========================2019-01-29 16:54:25======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C20AA361D002CB9A sCDKey = 259187292107 sName = ========================2019-01-29 16:54:25======================== 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 = '259187292107' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-29 16:54:33======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C20AA361D002CB9A sCDKey = 259187292107 sName = 김민수 ========================2019-01-29 16:54:33======================== 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 = '259187292107' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-29 16:54:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bosskimminsu' ========================2019-01-29 16:54:34======================== SELECT idx FROM macs WHERE mac_addr = '7085C20AA361D002CB9A' AND app_code = '039' ========================2019-01-29 16:54:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275580' ========================2019-01-29 16:54:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275580' ========================2019-01-29 16:54: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 ( '275580', '7085C20AA361D002CB9A', '039', '김민수', '110', '1920', '1080', 'bosskimminsu', '크린베라텍[김민수]', '259187292107' ) ========================2019-01-29 16:54:48======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C20AA361D002CB9A sCDKey = 259187292107 sName = 김민수 ========================2019-01-29 16:54: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 = '259187292107' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-29 17:01:12======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-DM28F1U parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838988A58978DE41AB sCDKey = 434133617514 sName = DESKTOP-DM28F1U ========================2019-01-29 17:01:12======================== 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 ========================2019-01-29 17:10:50======================== noteurl_start parm_app_code = 047 parm_pc_name = 정현일 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838988A58978DE41AB sCDKey = 434133617514 sName = 정현일 ========================2019-01-29 17:10: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 = '434133617514' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-29 17:11:02======================== noteurl_start parm_app_code = 047 parm_pc_name = 정현일 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838988A58978DE41AB sCDKey = 434133617514 sName = 정현일 ========================2019-01-29 17:11: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 = '434133617514' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-29 17:11:08======================== noteurl_start parm_app_code = 047 parm_pc_name = 정현일 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838988A58978DE41AB sCDKey = 434133617514 sName = 정현일 ========================2019-01-29 17:11: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 = '434133617514' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-29 17:11:10======================== noteurl_start parm_app_code = 047 parm_pc_name = 정현일 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838988A58978DE41AB sCDKey = 434133617514 sName = 정현일 ========================2019-01-29 17:11: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 = '434133617514' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-29 17:11:37======================== noteurl_start parm_app_code = 048 parm_pc_name = 정현일 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838988A58978DE41AB sCDKey = 434133617514 sName = 정현일 ========================2019-01-29 17:11: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-29 17:11:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-01-29 17:11:37======================== SELECT idx FROM macs WHERE mac_addr = '98838988A58978DE41AB' AND app_code = '048' ========================2019-01-29 17:11:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275754' ========================2019-01-29 17:11:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275754' ========================2019-01-29 17:11:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275754', '98838988A58978DE41AB', '048', '정현일', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2019-01-29 17:13:44======================== noteurl_start parm_app_code = 048 parm_pc_name = 김미해 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389885DB878DE41AB sCDKey = 434133617514 sName = 김미해 ========================2019-01-29 17:13:44======================== 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 ========================2019-01-29 17:13:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-01-29 17:13:44======================== SELECT idx FROM macs WHERE mac_addr = '988389885DB878DE41AB' AND app_code = '048' ========================2019-01-29 17:13:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273636' ========================2019-01-29 17:13:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273636' ========================2019-01-29 17:13:44======================== UPDATE mac_detail SET pc_name = '김미해', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '273636' ========================2019-01-29 17:16:48======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2019-01-29 17:16: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-29 17:16:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-01-29 17:16:48======================== SELECT idx FROM macs WHERE mac_addr = '98838987DB4ED87CAEF4' AND app_code = '048' ========================2019-01-29 17:16:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268463' ========================2019-01-29 17:16:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268463' ========================2019-01-29 17:16:48======================== UPDATE mac_detail SET pc_name = '김수영', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '268463' ========================2019-01-29 17:44:21======================== noteurl_start parm_app_code = 047 parm_pc_name = USER-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C8F7339A0245D051FDA3 sCDKey = 807375456416 sName = 노트북 ========================2019-01-29 17:44: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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-29 17:44:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gana4807' ========================2019-01-29 17:44:21======================== SELECT idx FROM macs WHERE mac_addr = 'C8F7339A0245D051FDA3' AND app_code = '047' ========================2019-01-29 17:44:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275749' ========================2019-01-29 17:44:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275749' ========================2019-01-29 17:44:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275749', 'C8F7339A0245D051FDA3', '047', '노트북', '�쐢�룄�슦 7', '0', '0', 'gana4807', '(주)가나24시동물병원[김창규]', '807375456416' )