========================2019-02-01 08:30:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DYUNOFFICE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F14BDA0AA233C88 sCDKey = 227786812716 sName = DYUNOFFICE ========================2019-02-01 08:30: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 = '227786812716' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-01 08:31:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DYUNOFFICE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F14BDA0AA233C88 sCDKey = 227786812716 sName = DYUNOFFICE ========================2019-02-01 08:31:26======================== 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 = '227786812716' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-01 08:31:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DYUNOFFICE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F14BDA0AA233C88 sCDKey = 227786812716 sName = DYUNOFFICE ========================2019-02-01 08:31: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 = '227786812716' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-01 08:32:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DYUNOFFICE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F14BDA0AA233C88 sCDKey = 227786812716 sName = DYUNOFFICE ========================2019-02-01 08:32: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 = '227786812716' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-01 08:32:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DYUNOFFICE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F14BDA0AA233C88 sCDKey = 227786812716 sName = DYUNOFFICE ========================2019-02-01 08:32: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 = '227786812716' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-01 08:56:05======================== noteurl_start parm_app_code = 047 parm_pc_name = 강정미2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883898745E7D87CAEF4 sCDKey = 434133617514 sName = 강정미2 ========================2019-02-01 08:56:05======================== 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 = '434133617514' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-01 09:11:55======================== 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 = 8C89A5535B433480179E sCDKey = 277886843570 sName = USER ========================2019-02-01 09:11: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 = '277886843570' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-01 09:11:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs8419' ========================2019-02-01 09:11:55======================== SELECT idx FROM macs WHERE mac_addr = '8C89A5535B433480179E' AND app_code = '039' ========================2019-02-01 09:11:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276048' ========================2019-02-01 09:11:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276048' ========================2019-02-01 09:11:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '276048', '8C89A5535B433480179E', '039', 'USER', '90', '1920', '1080', 'cs8419', '창성정육유통[정행심]', '277886843570' ) ========================2019-02-01 13:28:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8LUM6LH parm_os_type = 110 parm_screen_w = 768 parm_screen_h = 768 parm_user_mac = 1449E05FC81523A7EF0 sCDKey = 151336211301 sName = DESKTOP-8LUM6LH ========================2019-02-01 13:28: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 = '151336211301' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-01 13:28:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jaeminei' ========================2019-02-01 13:28:56======================== SELECT idx FROM macs WHERE mac_addr = '1449E05FC81523A7EF0' AND app_code = '039' ========================2019-02-01 13:28:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274602' ========================2019-02-01 13:28:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274602' ========================2019-02-01 13:28: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 ( '274602', '1449E05FC81523A7EF0', '039', 'DESKTOP-8LUM6LH', '110', '768', '768', 'jaeminei', '호정[김기현]', '151336211301' ) ========================2019-02-01 16:49:37======================== noteurl_start parm_app_code = 046 parm_pc_name = 5775-경태 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 74C63BA2AADDF8EB58DC sCDKey = 343408108095 sName = 5775-경태 ========================2019-02-01 16:49:37======================== 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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-01 16:49:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rain1479' ========================2019-02-01 16:49:37======================== SELECT idx FROM macs WHERE mac_addr = '74C63BA2AADDF8EB58DC' AND app_code = '046' ========================2019-02-01 16:49:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260444' ========================2019-02-01 16:49:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260444' ========================2019-02-01 16:49:37======================== UPDATE mac_detail SET pc_name = '5775-경태', os_type = '110', user_id = 'rain1479', user_name = '한영사[고경태]', screen_w = '2560', screen_h = '1080', cdkey = '343408108095' WHERE mac_idx = '260444' ========================2019-02-01 17:34:01======================== noteurl_start parm_app_code = 047 parm_pc_name = HJH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 950224410979 sName = HJH-PC ========================2019-02-01 17:34: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 = '950224410979' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-01 17:34:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2019-02-01 17:34:01======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '047' ========================2019-02-01 17:34:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229613' ========================2019-02-01 17:34:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '229613' ========================2019-02-01 17:34:01======================== UPDATE mac_detail SET pc_name = 'HJH-PC', os_type = '�쐢�룄�슦 10', user_id = 'wogus36', user_name = '[황재현]', screen_w = '0', screen_h = '0', cdkey = '950224410979' WHERE mac_idx = '229613' ========================2019-02-01 17:49:43======================== noteurl_start parm_app_code = 039 parm_pc_name = SJENG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039AE95AA580C51E2F sCDKey = 374148684699 sName = SJENG-PC ========================2019-02-01 17:49:43======================== 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 = '374148684699' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-01 17:49:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'inyoung1778' ========================2019-02-01 17:49:43======================== SELECT idx FROM macs WHERE mac_addr = 'E8039AE95AA580C51E2F' AND app_code = '039' ========================2019-02-01 17:49:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276130' ========================2019-02-01 17:49:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276130' ========================2019-02-01 17:49:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '276130', 'E8039AE95AA580C51E2F', '039', 'SJENG-PC', '90', '1920', '1080', 'inyoung1778', '동아아케이트관리소[최인영]', '374148684699' ) ========================2019-02-01 18:00:02======================== noteurl_start parm_app_code = 046 parm_pc_name = TITAN-S160 parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = F4B52008C5FD98613EF0 sCDKey = 146021747717 sName = TITAN-S160 ========================2019-02-01 18:00: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 = '146021747717' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-01 18:00:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'osan7770' ========================2019-02-01 18:00:02======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52008C5FD98613EF0' AND app_code = '046' ========================2019-02-01 18:00:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276131' ========================2019-02-01 18:00:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276131' ========================2019-02-01 18:00: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 ( '276131', 'F4B52008C5FD98613EF0', '046', 'TITAN-S160', '90', '1024', '768', 'osan7770', '오산목재[김대환]', '146021747717' ) ========================2019-02-01 18:02:35======================== noteurl_start parm_app_code = 046 parm_pc_name = TITAN-S160-1 parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = F4B52008C84B98613EF0 sCDKey = 146021747717 sName = TITAN-S160-1 ========================2019-02-01 18:02: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 = '146021747717' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-01 18:02:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'osan7770' ========================2019-02-01 18:02:35======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52008C84B98613EF0' AND app_code = '046' ========================2019-02-01 18:02:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276132' ========================2019-02-01 18:02:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276132' ========================2019-02-01 18:02: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 ( '276132', 'F4B52008C84B98613EF0', '046', 'TITAN-S160-1', '90', '1024', '768', 'osan7770', '오산목재[김대환]', '146021747717' )