========================2019-01-14 09:18:02======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18CF5E9414F620B43BE8 sCDKey = 204096420552 sName = SEC3 ========================2019-01-14 09:18: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 = '204096420552' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-14 09:18:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ki0889' ========================2019-01-14 09:18:02======================== SELECT idx FROM macs WHERE mac_addr = '18CF5E9414F620B43BE8' AND app_code = '039' ========================2019-01-14 09:18:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '133709' ========================2019-01-14 09:18:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '133709' ========================2019-01-14 09:18:02======================== UPDATE mac_detail SET pc_name = 'SEC3', os_type = '110', user_id = 'ki0889', user_name = '경일포장[김기춘]', screen_w = '1920', screen_h = '1080', cdkey = '204096420552' WHERE mac_idx = '133709' ========================2019-01-14 13:09:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S6IVUEU parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 309C23E0B714284BC450 sCDKey = 079447494493 sName = DESKTOP-S6IVUEU ========================2019-01-14 13:09: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 = '079447494493' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-14 13:09:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jagal25' ========================2019-01-14 13:09:12======================== SELECT idx FROM macs WHERE mac_addr = '309C23E0B714284BC450' AND app_code = '039' ========================2019-01-14 13:09:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274043' ========================2019-01-14 13:09:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274043' ========================2019-01-14 13:09:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274043', '309C23E0B714284BC450', '039', 'DESKTOP-S6IVUEU', '110', '1440', '900', 'jagal25', '부산어패류처리조합[이주애]', '079447494493' ) ========================2019-01-14 15:04:42======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CEC69A0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 04922648C40C1087798E sCDKey = 245131852832 sName = DESKTOP-CEC69A0 ========================2019-01-14 15:04:42======================== 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 = '245131852832' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-14 15:04:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'firstbm' ========================2019-01-14 15:04:42======================== SELECT idx FROM macs WHERE mac_addr = '04922648C40C1087798E' AND app_code = '047' ========================2019-01-14 15:04:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274064' ========================2019-01-14 15:04:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274064' ========================2019-01-14 15:04:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274064', '04922648C40C1087798E', '047', 'DESKTOP-CEC69A0', '�쐢�룄�슦 10', '0', '0', 'firstbm', '하나종합건재[강희구]', '245131852832' ) ========================2019-01-14 15:17:15======================== noteurl_start parm_app_code = 039 parm_pc_name = KS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80523C0674613DD9 sCDKey = 309996447406 sName = 경수물류 ========================2019-01-14 15:17:15======================== 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 = '309996447406' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-14 15:17:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjloveq' ========================2019-01-14 15:17:15======================== SELECT idx FROM macs WHERE mac_addr = '94DE80523C0674613DD9' AND app_code = '039' ========================2019-01-14 15:17:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274061' ========================2019-01-14 15:17:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274061' ========================2019-01-14 15:17:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274061', '94DE80523C0674613DD9', '039', '경수물류', '90', '1920', '1080', 'sjloveq', '경수물류 주식회사[오지숙]', '309996447406' ) ========================2019-01-14 15:17:20======================== noteurl_start parm_app_code = 039 parm_pc_name = KS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80523C0674613DD9 sCDKey = 309996447406 sName = 경수물류 ========================2019-01-14 15:17:20======================== 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 = '309996447406' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-14 15:17:22======================== noteurl_start parm_app_code = 039 parm_pc_name = KS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80523C0674613DD9 sCDKey = 309996447406 sName = 경수물류 ========================2019-01-14 15:17: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 = '309996447406' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-14 15:20:40======================== 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 = 1867B022B48CD051FDA3 sCDKey = 807375456416 sName = USER-PC ========================2019-01-14 15:20: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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-14 15:20:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gana4807' ========================2019-01-14 15:20:40======================== SELECT idx FROM macs WHERE mac_addr = '1867B022B48CD051FDA3' AND app_code = '047' ========================2019-01-14 15:20:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274072' ========================2019-01-14 15:20:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274072' ========================2019-01-14 15:20:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274072', '1867B022B48CD051FDA3', '047', 'USER-PC', '�쐢�룄�슦 7', '0', '0', 'gana4807', '(주)가나24시동물병원[김창규]', '807375456416' ) ========================2019-01-14 20:57:16======================== noteurl_start parm_app_code = 039 parm_pc_name = YOUNGHUN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A0A8CD63F6C874C7498D sCDKey = 807343105782 sName = 카베(KAHVE) ========================2019-01-14 20:57:16======================== 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 = '807343105782' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-14 20:57:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoonh01' ========================2019-01-14 20:57:16======================== SELECT idx FROM macs WHERE mac_addr = 'A0A8CD63F6C874C7498D' AND app_code = '039' ========================2019-01-14 20:57:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271713' ========================2019-01-14 20:57:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271713' ========================2019-01-14 20:57:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271713', 'A0A8CD63F6C874C7498D', '039', '카베(KAHVE)', '110', '1536', '864', 'yoonh01', '카베(KAHVE)[윤영훈]', '807343105782' )