========================2019-12-16 09:56:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EVVJ3DN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90B11C638406C6923586 sCDKey = 827012175285 sName = DESKTOP-EVVJ3DN ========================2019-12-16 09:56:00======================== 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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 10:03:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EVVJ3DN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90B11C638406C6923586 sCDKey = 827012175285 sName = DESKTOP-EVVJ3DN ========================2019-12-16 10:03:24======================== 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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 10:04:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EVVJ3DN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90B11C638406C6923586 sCDKey = 827012175285 sName = optimec12 ========================2019-12-16 10:04:23======================== 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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 10:04:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EVVJ3DN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90B11C638406C6923586 sCDKey = 827012175285 sName = optimec12 ========================2019-12-16 10:04:52======================== 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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 10:06:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EVVJ3DN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90B11C638406C6923586 sCDKey = 827012175285 sName = DESKTOP-EVVJ3DN ========================2019-12-16 10:06:56======================== 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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 10:06:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'optimec12' ========================2019-12-16 10:06:56======================== SELECT idx FROM macs WHERE mac_addr = '90B11C638406C6923586' AND app_code = '039' ========================2019-12-16 10:06:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303771' ========================2019-12-16 10:06:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '303771' ========================2019-12-16 10:06:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '303771', '90B11C638406C6923586', '039', 'DESKTOP-EVVJ3DN', '110', '1920', '1080', 'optimec12', '진아트[노진화]', '827012175285' ) ========================2019-12-16 10:07:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EVVJ3DN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90B11C638406C6923586 sCDKey = 827012175285 sName = DESKTOP-EVVJ3DN ========================2019-12-16 10:07: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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 11:20:55======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = C83A35C8BE74846BB25F sCDKey = 217223037343 sName = OFFICE-PC ========================2019-12-16 11:20:55======================== 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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 11:20:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunjin677' ========================2019-12-16 11:20:56======================== SELECT idx FROM macs WHERE mac_addr = 'C83A35C8BE74846BB25F' AND app_code = '039' ========================2019-12-16 11:20:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284851' ========================2019-12-16 11:20:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '284851' ========================2019-12-16 11:20:56======================== UPDATE mac_detail SET pc_name = 'OFFICE-PC', os_type = '110', user_id = 'sunjin677', user_name = '선진FS[김형희]', screen_w = '1280', screen_h = '1024', cdkey = '217223037343' WHERE mac_idx = '284851' ========================2019-12-16 11:22:28======================== noteurl_start parm_app_code = 039 parm_pc_name = HWA-PC parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 408D5CC09DD62448FE57 sCDKey = 217223037343 sName = HWA-PC ========================2019-12-16 11:22:28======================== 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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 11:22:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunjin677' ========================2019-12-16 11:22:28======================== SELECT idx FROM macs WHERE mac_addr = '408D5CC09DD62448FE57' AND app_code = '039' ========================2019-12-16 11:22:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286545' ========================2019-12-16 11:22:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286545' ========================2019-12-16 11:22:28======================== UPDATE mac_detail SET pc_name = 'HWA-PC', os_type = '110', user_id = 'sunjin677', user_name = '선진FS[김형희]', screen_w = '1360', screen_h = '768', cdkey = '217223037343' WHERE mac_idx = '286545' ========================2019-12-16 11:59:58======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6MENOFN parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = E0D55EBBB5D1BAB5CCD3 sCDKey = 252447530356 sName = DESKTOP-6MENOFN ========================2019-12-16 11:59:58======================== 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 = '252447530356' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 11:59:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daigeq' ========================2019-12-16 11:59:58======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EBBB5D1BAB5CCD3' AND app_code = '039' ========================2019-12-16 11:59:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305530' ========================2019-12-16 11:59:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '305530' ========================2019-12-16 11:59:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '305530', 'E0D55EBBB5D1BAB5CCD3', '039', 'DESKTOP-6MENOFN', '110', '1280', '1024', 'daigeq', '(주)삼원에스엠테크[조혜정]', '252447530356' ) ========================2019-12-16 14:56:33======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-ONFGJTU parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1831BF247EA8E830C480 sCDKey = 248664335664 sName = DESKTOP-ONFGJTU ========================2019-12-16 14:56: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 = '248664335664' AND r.app_code = '050' AND r.app_block = 0 ========================2019-12-16 14:56:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gwacheon' ========================2019-12-16 14:56:33======================== SELECT idx FROM macs WHERE mac_addr = '1831BF247EA8E830C480' AND app_code = '050' ========================2019-12-16 14:56:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305557' ========================2019-12-16 14:56:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '305557' ========================2019-12-16 14:56:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '305557', '1831BF247EA8E830C480', '050', 'DESKTOP-ONFGJTU', '109', '1920', '1080', 'gwacheon', '과천청사관리소[관리과]', '248664335664' ) ========================2019-12-16 15:52:35======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002511C2D30070C03CD8 sCDKey = 591682675505 sName = USER-PC ========================2019-12-16 15:52:35======================== 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 = '591682675505' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-16 15:52:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yrjh11' ========================2019-12-16 15:52:35======================== SELECT idx FROM macs WHERE mac_addr = '002511C2D30070C03CD8' AND app_code = '039' ========================2019-12-16 15:52:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303858' ========================2019-12-16 15:52:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '303858' ========================2019-12-16 15:52:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '303858', '002511C2D30070C03CD8', '039', 'USER-PC', '90', '1920', '1080', 'yrjh11', '보창산업[보창산업]', '591682675505' ) ========================2019-12-16 16:00:25======================== noteurl_start ========================2019-12-16 16:00: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 = '' AND r.app_code = '' AND r.app_block = 0