========================2018-10-10 09:31:51======================== noteurl_start parm_app_code = 039 parm_pc_name = SDSHOP-PC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 00E0914FB0536012A825 sCDKey = 917325696225 sName = SDSHOP-PC ========================2018-10-10 09:31: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 = '917325696225' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-10 09:31:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bovitex' ========================2018-10-10 09:31:51======================== SELECT idx FROM macs WHERE mac_addr = '00E0914FB0536012A825' AND app_code = '039' ========================2018-10-10 09:31:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '218270' ========================2018-10-10 09:31:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '218270' ========================2018-10-10 09:31:51======================== UPDATE mac_detail SET pc_name = 'SDSHOP-PC', os_type = '110', user_id = 'bovitex', user_name = '주식회사보은텍스비젼[오현우]', screen_w = '1366', screen_h = '768', cdkey = '917325696225' WHERE mac_idx = '218270' ========================2018-10-10 09:58:14======================== noteurl_start parm_app_code = 039 parm_pc_name = GSA parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 00245459DF9718FC0300 sCDKey = 977685040084 sName = GSA ========================2018-10-10 09:58: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 = '977685040084' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-10 09:58:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ahnki7295' ========================2018-10-10 09:58:14======================== SELECT idx FROM macs WHERE mac_addr = '00245459DF9718FC0300' AND app_code = '039' ========================2018-10-10 09:58:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261234' ========================2018-10-10 09:58:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261234' ========================2018-10-10 09:58:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261234', '00245459DF9718FC0300', '039', 'GSA', '90', '1366', '768', 'ahnki7295', '코스정보통신[이근제]', '977685040084' ) ========================2018-10-10 11:25:30======================== noteurl_start parm_app_code = 039 parm_pc_name = CNP181004C parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = BC5FF4E3DE4EDA1998C8 sCDKey = 395923947487 sName = CNP181004C ========================2018-10-10 11:25: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 = '395923947487' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-10 11:25:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yjframe' ========================2018-10-10 11:25:30======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4E3DE4EDA1998C8' AND app_code = '039' ========================2018-10-10 11:25:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261805' ========================2018-10-10 11:25:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261805' ========================2018-10-10 11:25:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261805', 'BC5FF4E3DE4EDA1998C8', '039', 'CNP181004C', '90', '1280', '1024', 'yjframe', '영진프레임[김병태]', '395923947487' ) ========================2018-10-10 11:47:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MV7FKA1 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 003067528105761E07B0 sCDKey = 781008131999 sName = DESKTOP-MV7FKA1 ========================2018-10-10 11:47: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 = '781008131999' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-10 11:47:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'changmoo' ========================2018-10-10 11:47:20======================== SELECT idx FROM macs WHERE mac_addr = '003067528105761E07B0' AND app_code = '039' ========================2018-10-10 11:47:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261974' ========================2018-10-10 11:47:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261974' ========================2018-10-10 11:47:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261974', '003067528105761E07B0', '039', 'DESKTOP-MV7FKA1', '110', '1280', '1024', 'changmoo', '일미식품[이창무]', '781008131999' ) ========================2018-10-10 11:58:38======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-V8HEQLM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E82A44B2EC331E6A96EF sCDKey = 932847330830 sName = DESKTOP-V8HEQLM ========================2018-10-10 11:58:38======================== 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 = '932847330830' AND r.app_code = '045' AND r.app_block = 0 ========================2018-10-10 11:58:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chamnara' ========================2018-10-10 11:58:38======================== SELECT idx FROM macs WHERE mac_addr = 'E82A44B2EC331E6A96EF' AND app_code = '045' ========================2018-10-10 11:58:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252994' ========================2018-10-10 11:58:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252994' ========================2018-10-10 11:58:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252994', 'E82A44B2EC331E6A96EF', '045', 'DESKTOP-V8HEQLM', '110', '1920', '1080', 'chamnara', '(주)참나라 농업회사법인[임준상]', '932847330830' ) ========================2018-10-10 11:58:44======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-V8HEQLM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E82A44B2EC331E6A96EF sCDKey = 932847330830 sName = DESKTOP-V8HEQLM ========================2018-10-10 11:58: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 = '932847330830' AND r.app_code = '045' AND r.app_block = 0 ========================2018-10-10 11:58:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chamnara' ========================2018-10-10 11:58:44======================== SELECT idx FROM macs WHERE mac_addr = 'E82A44B2EC331E6A96EF' AND app_code = '045' ========================2018-10-10 11:58:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252994' ========================2018-10-10 11:58:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252994' ========================2018-10-10 11:58:44======================== UPDATE mac_detail SET pc_name = 'DESKTOP-V8HEQLM', os_type = '110', user_id = 'chamnara', user_name = '(주)참나라 농업회사법인[임준상]', screen_w = '1920', screen_h = '1080', cdkey = '932847330830' WHERE mac_idx = '252994' ========================2018-10-10 15:33:29======================== noteurl_start parm_app_code = 039 parm_pc_name = 7-5경리총무 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002454F9E704BCBF3BBE sCDKey = 831747718511 sName = 7-5경리총무 ========================2018-10-10 15:33:29======================== 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 = '831747718511' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-10 15:33:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'insan1' ========================2018-10-10 15:33:29======================== SELECT idx FROM macs WHERE mac_addr = '002454F9E704BCBF3BBE' AND app_code = '039' ========================2018-10-10 15:33:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261997' ========================2018-10-10 15:33:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261997' ========================2018-10-10 15:33:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261997', '002454F9E704BCBF3BBE', '039', '7-5경리총무', '90', '1920', '1080', 'insan1', '인산빌딩[최정환]', '831747718511' ) ========================2018-10-10 16:18:54======================== noteurl_start parm_app_code = 039 parm_pc_name = COM5ST parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8975A4BEC42A4999F90 sCDKey = 941510009506 sName = COM5ST ========================2018-10-10 16:18:54======================== 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 = '941510009506' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-10 16:18:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ca5223' ========================2018-10-10 16:18:54======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A4BEC42A4999F90' AND app_code = '039' ========================2018-10-10 16:18:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260288' ========================2018-10-10 16:18:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260288' ========================2018-10-10 16:18:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260288', 'B8975A4BEC42A4999F90', '039', 'COM5ST', '90', '1920', '1080', 'ca5223', '청암창호[권창환]', '941510009506' )