========================2018-01-04 09:41:07======================== noteurl_start parm_app_code = 045 parm_pc_name = HJH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 054558848729 sName = HJH-PC ========================2018-01-04 09:41: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 = '054558848729' AND r.app_code = '045' AND r.app_block = 0 ========================2018-01-04 09:41:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2018-01-04 09:41:07======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '045' ========================2018-01-04 09:41:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '225603' ========================2018-01-04 09:41:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '225603' ========================2018-01-04 09:41: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 ( '225603', 'F44D30B9AE60D8075059', '045', 'HJH-PC', '110', '1920', '1080', 'wogus36', '[황재현]', '054558848729' ) ========================2018-01-04 10:09:01======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90E6BADBD7562C3899D2 sCDKey = 301532188735 sName = USER ========================2018-01-04 10:09:01======================== 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 = '301532188735' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-04 10:09:15======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90E6BADBD7562C3899D2 sCDKey = 301532188735 sName = USER ========================2018-01-04 10:09: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 = '301532188735' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-04 10:09:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yj2888' ========================2018-01-04 10:09:15======================== SELECT idx FROM macs WHERE mac_addr = '90E6BADBD7562C3899D2' AND app_code = '039' ========================2018-01-04 10:09:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238152' ========================2018-01-04 10:09:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238152' ========================2018-01-04 10:09: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 ( '238152', '90E6BADBD7562C3899D2', '039', 'USER', '90', '1920', '1080', 'yj2888', '용진공업사[김인숙]', '301532188735' ) ========================2018-01-04 10:32:02======================== noteurl_start parm_app_code = 039 parm_pc_name = 경리2-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE806AAFE0705335F7 sCDKey = 338270963977 sName = 경리2-PC ========================2018-01-04 10:32: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 = '338270963977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-04 10:32:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daall2004' ========================2018-01-04 10:32:02======================== SELECT idx FROM macs WHERE mac_addr = '94DE806AAFE0705335F7' AND app_code = '039' ========================2018-01-04 10:32:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238158' ========================2018-01-04 10:32:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238158' ========================2018-01-04 10:32: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 ( '238158', '94DE806AAFE0705335F7', '039', '경리2-PC', '90', '1920', '1080', 'daall2004', '(주)다올정밀[(주)다올정밀]', '338270963977' ) ========================2018-01-04 10:32:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DIRE-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F079595D67044EC9F1A2 sCDKey = 338270963977 sName = DIRE-PC ========================2018-01-04 10:32:14======================== 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 = '338270963977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-04 10:32:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daall2004' ========================2018-01-04 10:32:14======================== SELECT idx FROM macs WHERE mac_addr = 'F079595D67044EC9F1A2' AND app_code = '039' ========================2018-01-04 10:32:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236917' ========================2018-01-04 10:32:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236917' ========================2018-01-04 10:32:14======================== UPDATE mac_detail SET pc_name = 'DIRE-PC', os_type = '90', user_id = 'daall2004', user_name = '(주)다올정밀[(주)다올정밀]', screen_w = '1920', screen_h = '1080', cdkey = '338270963977' WHERE mac_idx = '236917' ========================2018-01-04 10:32:31======================== noteurl_start parm_app_code = 039 parm_pc_name = OWNER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E2BF69F12D56E4A sCDKey = 338270963977 sName = OWNER-PC ========================2018-01-04 10:32:31======================== 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 = '338270963977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-04 10:32:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daall2004' ========================2018-01-04 10:32:31======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E2BF69F12D56E4A' AND app_code = '039' ========================2018-01-04 10:32:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238157' ========================2018-01-04 10:32:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238157' ========================2018-01-04 10:32:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238157', 'E0D55E2BF69F12D56E4A', '039', 'OWNER-PC', '90', '1920', '1080', 'daall2004', '(주)다올정밀[(주)다올정밀]', '338270963977' ) ========================2018-01-04 11:46:18======================== noteurl_start parm_app_code = 046 parm_pc_name = DAYUEN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050999F11E2BACB49BC sCDKey = 868089309660 sName = DAYUEN-PC ========================2018-01-04 11:46:18======================== 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 = '868089309660' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-04 11:46:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'swgy7887' ========================2018-01-04 11:46:18======================== SELECT idx FROM macs WHERE mac_addr = 'D050999F11E2BACB49BC' AND app_code = '046' ========================2018-01-04 11:46:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238169' ========================2018-01-04 11:46:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238169' ========================2018-01-04 11:46:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238169', 'D050999F11E2BACB49BC', '046', 'DAYUEN-PC', '90', '1920', '1080', 'swgy7887', '주식회사 현대미디어에이스[최성욱]', '868089309660' ) ========================2018-01-04 14:12:25======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 50B7C368290D62A9266C sCDKey = 453015259105 sName = ADMIN-PC ========================2018-01-04 14:12: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 = '453015259105' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-04 14:12:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'w787654' ========================2018-01-04 14:12:25======================== SELECT idx FROM macs WHERE mac_addr = '50B7C368290D62A9266C' AND app_code = '039' ========================2018-01-04 14:12:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238177' ========================2018-01-04 14:12:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238177' ========================2018-01-04 14:12:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238177', '50B7C368290D62A9266C', '039', 'ADMIN-PC', '90', '1366', '768', 'w787654', 'W기공소[임상욱]', '453015259105' ) ========================2018-01-04 16:04:08======================== noteurl_start parm_app_code = 048 parm_pc_name = 회의실-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 0030677FFED8C6CDB9D1 sCDKey = 867768264557 sName = 회의실-PC ========================2018-01-04 16:04: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 = '867768264557' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-04 16:04:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mjdev' ========================2018-01-04 16:04:08======================== SELECT idx FROM macs WHERE mac_addr = '0030677FFED8C6CDB9D1' AND app_code = '048' ========================2018-01-04 16:04:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238208' ========================2018-01-04 16:04:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238208' ========================2018-01-04 16:04:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238208', '0030677FFED8C6CDB9D1', '048', '회의실-PC', '�쐢�룄�슦 10', '0', '0', 'mjdev', '엠제이소프트[최상호]', '867768264557' )