========================2018-11-26 08:44:00======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-51PMH46 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74DFBFAE73535262F991 sCDKey = 434133617514 sName = 강정미1 ========================2018-11-26 08:44: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-26 08:44:21======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-51PMH46 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74DFBFAE73535262F991 sCDKey = 434133617514 sName = 강정미2 ========================2018-11-26 08:44:21======================== 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 = '048' AND r.app_block = 0 ========================2018-11-26 08:45:51======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-51PMH46 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74DFBFAE73535262F991 sCDKey = 434133617514 sName = 강정미1 ========================2018-11-26 08:45: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-26 08:45:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-26 08:45:51======================== SELECT idx FROM macs WHERE mac_addr = '74DFBFAE73535262F991' AND app_code = '048' ========================2018-11-26 08:45:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268871' ========================2018-11-26 08:45:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268871' ========================2018-11-26 08:45:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268871', '74DFBFAE73535262F991', '048', '강정미1', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2018-11-26 09:46:06======================== noteurl_start parm_app_code = 048 parm_pc_name = 김인영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B886876976697452D593 sCDKey = 434133617514 sName = 정현일 ========================2018-11-26 09:46:06======================== 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 = '048' AND r.app_block = 0 ========================2018-11-26 09:46:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-26 09:46:06======================== SELECT idx FROM macs WHERE mac_addr = 'B886876976697452D593' AND app_code = '048' ========================2018-11-26 09:46:06======================== 값이 없을 경우 ========================2018-11-26 09:53:43======================== noteurl_start parm_app_code = 047 parm_pc_name = 강정미1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 강정미1 ========================2018-11-26 09:53: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 = '434133617514' AND r.app_code = '047' AND r.app_block = 0 ========================2018-11-26 09:53:53======================== noteurl_start parm_app_code = 047 parm_pc_name = 강정미1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 강정미1 ========================2018-11-26 09:53:53======================== 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 ========================2018-11-26 09:54:06======================== noteurl_start parm_app_code = 047 parm_pc_name = 강정미1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 강정미1 ========================2018-11-26 09:54:06======================== 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 ========================2018-11-26 09:54:19======================== noteurl_start parm_app_code = 047 parm_pc_name = 강정미1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 강정미1 ========================2018-11-26 09:54:19======================== 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 ========================2018-11-26 09:54:34======================== noteurl_start parm_app_code = 048 parm_pc_name = 강정미1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 강정미1 ========================2018-11-26 09:54:34======================== 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 = '048' AND r.app_block = 0 ========================2018-11-26 09:54:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-26 09:54:34======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEB832C5262F991' AND app_code = '048' ========================2018-11-26 09:54:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254561' ========================2018-11-26 09:54:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254561' ========================2018-11-26 09:54:34======================== UPDATE mac_detail SET pc_name = '강정미1', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '254561' ========================2018-11-26 10:01:41======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74DFBFAE739E5262F991 sCDKey = 434133617514 sName = 김미해 ========================2018-11-26 10:01: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-26 10:01:45======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74DFBFAE739E5262F991 sCDKey = 434133617514 sName = 김미해 ========================2018-11-26 10:01:45======================== 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 = '048' AND r.app_block = 0 ========================2018-11-26 10:03:40======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74DFBFAE739E5262F991 sCDKey = 434133617514 sName = 김미해 ========================2018-11-26 10:03: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-26 10:03:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-26 10:03:40======================== SELECT idx FROM macs WHERE mac_addr = '74DFBFAE739E5262F991' AND app_code = '048' ========================2018-11-26 10:03:40======================== 값이 없을 경우 ========================2018-11-26 10:07:34======================== noteurl_start parm_app_code = 048 parm_pc_name = 김미해 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB82EE5262F991 sCDKey = 434133617514 sName = 김미해 ========================2018-11-26 10:07:34======================== 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 = '048' AND r.app_block = 0 ========================2018-11-26 10:07:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-26 10:07:34======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEB82EE5262F991' AND app_code = '048' ========================2018-11-26 10:07:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242763' ========================2018-11-26 10:07:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242763' ========================2018-11-26 10:07:34======================== UPDATE mac_detail SET pc_name = '김미해', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '242763' ========================2018-11-26 13:14:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-05CHNNC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C69134546D124C412F sCDKey = 468467075468 sName = DESKTOP-05CHNNC ========================2018-11-26 13:14:21======================== 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 = '468467075468' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 13:14:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skpanel1885' ========================2018-11-26 13:14:21======================== SELECT idx FROM macs WHERE mac_addr = '94C69134546D124C412F' AND app_code = '039' ========================2018-11-26 13:14:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268922' ========================2018-11-26 13:14:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268922' ========================2018-11-26 13:14:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268922', '94C69134546D124C412F', '039', 'DESKTOP-05CHNNC', '110', '1920', '1080', 'skpanel1885', '세경판넬[강석우]', '468467075468' ) ========================2018-11-26 15:08:18======================== noteurl_start parm_app_code = 046 parm_pc_name = PC3 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C5C8E8542383442DC9C sCDKey = 108094650671 sName = PC3 ========================2018-11-26 15:08: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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-26 15:08:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2018-11-26 15:08:18======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E8542383442DC9C' AND app_code = '046' ========================2018-11-26 15:08:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268941' ========================2018-11-26 15:08:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268941' ========================2018-11-26 15:08: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 ( '268941', '9C5C8E8542383442DC9C', '046', 'PC3', '90', '1920', '1080', 'a09sang', '(주)거상[장동익]', '108094650671' ) ========================2018-11-26 16:36:42======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = BC5FF4EB35116C729225 sCDKey = 643239656819 sName = ========================2018-11-26 16:36: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 = '643239656819' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 16:37:10======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = BC5FF4EB35116C729225 sCDKey = 643239656819 sName = user ========================2018-11-26 16:37:10======================== 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 = '643239656819' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 16:37:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cas609' ========================2018-11-26 16:37:10======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4EB35116C729225' AND app_code = '039' ========================2018-11-26 16:37:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268955' ========================2018-11-26 16:37:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268955' ========================2018-11-26 16:37:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268955', 'BC5FF4EB35116C729225', '039', 'user', '90', '1680', '1050', 'cas609', '장화용한국사[장화용]', '643239656819' ) ========================2018-11-26 17:36:30======================== noteurl_start parm_app_code = 039 parm_pc_name = GOGOS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3CC6993302 sCDKey = 476035831696 sName = GOGOS-PC ========================2018-11-26 17:36: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 17:38:29======================== noteurl_start parm_app_code = 039 parm_pc_name = GOGOS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3CC6993302 sCDKey = 476035831696 sName = GOGOS-PC ========================2018-11-26 17:38: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 17:40:40======================== noteurl_start parm_app_code = 039 parm_pc_name = GOGOS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3CC6993302 sCDKey = 476035831696 sName = GOGOS-PC ========================2018-11-26 17:40: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 17:40:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jjh5384' ========================2018-11-26 17:40:40======================== SELECT idx FROM macs WHERE mac_addr = '7085C2770A3CC6993302' AND app_code = '039' ========================2018-11-26 17:40:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268952' ========================2018-11-26 17:40:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268952' ========================2018-11-26 17:40: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 ( '268952', '7085C2770A3CC6993302', '039', 'GOGOS-PC', '90', '1920', '1080', 'jjh5384', '대동포장[장두원]', '476035831696' ) ========================2018-11-26 17:40:48======================== noteurl_start parm_app_code = 039 parm_pc_name = GOGOS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3CC6993302 sCDKey = 476035831696 sName = GOGOS-PC ========================2018-11-26 17:40:48======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 17:40:58======================== noteurl_start parm_app_code = 039 parm_pc_name = GOGOS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3CC6993302 sCDKey = 476035831696 sName = GOGOS-PC ========================2018-11-26 17:40: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 17:41:01======================== noteurl_start parm_app_code = 039 parm_pc_name = GOGOS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3CC6993302 sCDKey = 476035831696 sName = GOGOS-PC ========================2018-11-26 17:41: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-26 17:41:06======================== noteurl_start parm_app_code = 039 parm_pc_name = GOGOS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3CC6993302 sCDKey = 476035831696 sName = GOGOS-PC ========================2018-11-26 17:41:06======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0