========================2020-10-13 07:08:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PDAQC2F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC34119295DC11 sCDKey = 206167080603 sName = DESKTOP-PDAQC2F ========================2020-10-13 07:08: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 = '206167080603' AND r.app_code = '046' AND r.app_block = 0 ========================2020-10-13 07:08:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eodyam' ========================2020-10-13 07:08:40======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AC34119295DC11' AND app_code = '046' ========================2020-10-13 07:08:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '327849' ========================2020-10-13 07:08:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '327849' ========================2020-10-13 07:08: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 ( '327849', '50B7C3AC34119295DC11', '046', 'DESKTOP-PDAQC2F', '110', '1920', '1080', 'eodyam', '삼보건재철물[장경옥]', '206167080603' ) ========================2020-10-13 07:09:01======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PDAQC2F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC34119295DC11 sCDKey = 206167080603 sName = DESKTOP-PDAQC2F ========================2020-10-13 07: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 = '206167080603' AND r.app_code = '046' AND r.app_block = 0 ========================2020-10-13 07:09:20======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PDAQC2F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC34119295DC11 sCDKey = 206167080603 sName = DESKTOP-PDAQC2F ========================2020-10-13 07:09: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 = '206167080603' AND r.app_code = '046' AND r.app_block = 0 ========================2020-10-13 10:10:41======================== noteurl_start parm_app_code = 039 parm_pc_name = SERVER00 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D43511FDAFCE9BAC2F sCDKey = 216004924551 sName = SERVER00 ========================2020-10-13 10:10:41======================== 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 = '216004924551' AND r.app_code = '039' AND r.app_block = 0 ========================2020-10-13 10:10:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pshzlh' ========================2020-10-13 10:10:41======================== SELECT idx FROM macs WHERE mac_addr = '74D43511FDAFCE9BAC2F' AND app_code = '039' ========================2020-10-13 10:10:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '327861' ========================2020-10-13 10:10:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '327861' ========================2020-10-13 10:10:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '327861', '74D43511FDAFCE9BAC2F', '039', 'SERVER00', '90', '1920', '1080', 'pshzlh', '탑청과[박승호]', '216004924551' ) ========================2020-10-13 10:11:42======================== noteurl_start parm_app_code = 045 parm_pc_name = LAPTOP-KTA534UI parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = A0C589776F416E506246 sCDKey = 795663959041 sName = LAPTOP-KTA534UI ========================2020-10-13 10:11: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 = '795663959041' AND r.app_code = '045' AND r.app_block = 0 ========================2020-10-13 10:11:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hifill5125' ========================2020-10-13 10:11:42======================== SELECT idx FROM macs WHERE mac_addr = 'A0C589776F416E506246' AND app_code = '045' ========================2020-10-13 10:11:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '327859' ========================2020-10-13 10:11:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '327859' ========================2020-10-13 10:11: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 ( '327859', 'A0C589776F416E506246', '045', 'LAPTOP-KTA534UI', '110', '1280', '720', 'hifill5125', '대부상사[성낙철]', '795663959041' ) ========================2020-10-13 11:22:39======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-1FDFBUG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99C9CDD782683067 sCDKey = 780547338320 sName = 오소정 ========================2020-10-13 11:22:39======================== 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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-10-13 11:22:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-10-13 11:22:39======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C9CDD782683067' AND app_code = '048' ========================2020-10-13 11:22:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319874' ========================2020-10-13 11:22:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319874' ========================2020-10-13 11:22:39======================== UPDATE mac_detail SET pc_name = '오소정', os_type = '�쐢�룄�슦 10', user_id = 'aone0022', user_name = '(주)에이원메디칼[강창중]', screen_w = '0', screen_h = '0', cdkey = '780547338320' WHERE mac_idx = '319874' ========================2020-10-13 11:26:02======================== noteurl_start parm_app_code = 048 parm_pc_name = AONE-1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E9943750CD18FA2D0 sCDKey = 780547338320 sName = 이한별 ========================2020-10-13 11:26: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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-10-13 11:26:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-10-13 11:26:02======================== SELECT idx FROM macs WHERE mac_addr = 'B42E9943750CD18FA2D0' AND app_code = '048' ========================2020-10-13 11:26:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '327686' ========================2020-10-13 11:26:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '327686' ========================2020-10-13 11:26: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 ( '327686', 'B42E9943750CD18FA2D0', '048', '이한별', '�쐢�룄�슦 10', '0', '0', 'aone0022', '(주)에이원메디칼[강창중]', '780547338320' ) ========================2020-10-13 13:09:55======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7M644CJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30BC74C27870A406 sCDKey = 807375456416 sName = DESKTOP-7M644CJ ========================2020-10-13 13:09: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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2020-10-13 13:09:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gana4807' ========================2020-10-13 13:09:55======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC74C27870A406' AND app_code = '047' ========================2020-10-13 13:09:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278633' ========================2020-10-13 13:09:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278633' ========================2020-10-13 13:09:55======================== UPDATE mac_detail SET pc_name = 'DESKTOP-7M644CJ', os_type = '�쐢�룄�슦 10', user_id = 'gana4807', user_name = '(주)가나24시동물병원[김창규]', screen_w = '0', screen_h = '0', cdkey = '807375456416' WHERE mac_idx = '278633' ========================2020-10-13 15:03:08======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 943551094481 sName = HANDO ========================2020-10-13 15:03: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 = '943551094481' AND r.app_code = '039' AND r.app_block = 0 ========================2020-10-13 15:03:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kaf0303' ========================2020-10-13 15:03:08======================== SELECT idx FROM macs WHERE mac_addr = '98838981F74D76D7F1ED' AND app_code = '039' ========================2020-10-13 15:03:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235354' ========================2020-10-13 15:03:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235354' ========================2020-10-13 15:03:08======================== UPDATE mac_detail SET pc_name = 'HANDO', os_type = '110', user_id = 'kaf0303', user_name = '한도시스템(주)[임문희]', screen_w = '1920', screen_h = '1080', cdkey = '943551094481' WHERE mac_idx = '235354' ========================2020-10-13 15:06:17======================== noteurl_start parm_app_code = 039 parm_pc_name = LEE parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A644ADEC0611F13 sCDKey = 943551094481 sName = LEE ========================2020-10-13 15:06:17======================== 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 = '943551094481' AND r.app_code = '039' AND r.app_block = 0 ========================2020-10-13 15:06:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kaf0303' ========================2020-10-13 15:06:18======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A644ADEC0611F13' AND app_code = '039' ========================2020-10-13 15:06:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '48195' ========================2020-10-13 15:06:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '48195' ========================2020-10-13 15:06:18======================== UPDATE mac_detail SET pc_name = 'LEE', os_type = '90', user_id = 'kaf0303', user_name = '한도시스템(주)[임문희]', screen_w = '1920', screen_h = '1080', cdkey = '943551094481' WHERE mac_idx = '48195' ========================2020-10-13 15:06:47======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2020-10-13 15:06:47======================== 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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2020-10-13 15:06:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hando77' ========================2020-10-13 15:06:47======================== SELECT idx FROM macs WHERE mac_addr = '98838981F74D76D7F1ED' AND app_code = '039' ========================2020-10-13 15:06:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235354' ========================2020-10-13 15:06:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235354' ========================2020-10-13 15:06:47======================== UPDATE mac_detail SET pc_name = 'HANDO', os_type = '110', user_id = 'hando77', user_name = '한도교역[한도교역]', screen_w = '1920', screen_h = '1080', cdkey = '173379187341' WHERE mac_idx = '235354' ========================2020-10-13 16:23:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OTH3580 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3C7C3F139A433AE53305 sCDKey = 787140740812 sName = DESKTOP-OTH3580 ========================2020-10-13 16:23: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 = '787140740812' AND r.app_code = '039' AND r.app_block = 0 ========================2020-10-13 16:23:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rladudghl16' ========================2020-10-13 16:23:18======================== SELECT idx FROM macs WHERE mac_addr = '3C7C3F139A433AE53305' AND app_code = '039' ========================2020-10-13 16:23:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '327899' ========================2020-10-13 16:23:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '327899' ========================2020-10-13 16:23: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 ( '327899', '3C7C3F139A433AE53305', '039', 'DESKTOP-OTH3580', '110', '1920', '1080', 'rladudghl16', '삼립용화[김영회]', '787140740812' )