========================2021-05-27 09:44:41======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-VSJLFRD parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = F80DAC10358C162AF0F6 sCDKey = 670640017003 sName = DESKTOP-VSJLFRD ========================2021-05-27 09:44: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 = '670640017003' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-27 09:49:24======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-VSJLFRD parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = F80DAC10358C162AF0F6 sCDKey = 212845321133 sName = DESKTOP-VSJLFRD ========================2021-05-27 09:49: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 = '212845321133' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-27 09:49:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeil0989' ========================2021-05-27 09:49:24======================== SELECT idx FROM macs WHERE mac_addr = 'F80DAC10358C162AF0F6' AND app_code = '046' ========================2021-05-27 09:49:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343649' ========================2021-05-27 09:49:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343649' ========================2021-05-27 09:49:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '343649', 'F80DAC10358C162AF0F6', '046', 'DESKTOP-VSJLFRD', '110', '3440', '1440', 'jeil0989', '제일기계공구[오대환]', '212845321133' ) ========================2021-05-27 10:03:31======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HM4INQ3 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = BC5FF4F4D1F286AEBC19 sCDKey = 616636429020 sName = DESKTOP-HM4INQ3 ========================2021-05-27 10:03:31======================== 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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-27 10:17:46======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HM4INQ3 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = BC5FF4F4D1F286AEBC19 sCDKey = 616636429020 sName = DESKTOP-HM4INQ3 ========================2021-05-27 10:17:46======================== 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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-27 10:17:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qkdxo200' ========================2021-05-27 10:17:46======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4F4D1F286AEBC19' AND app_code = '046' ========================2021-05-27 10:17:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344223' ========================2021-05-27 10:17:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344223' ========================2021-05-27 10:17:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '344223', 'BC5FF4F4D1F286AEBC19', '046', 'DESKTOP-HM4INQ3', '110', '1280', '1024', 'qkdxo200', '성도유통[방휘대]', '616636429020' ) ========================2021-05-27 10:29:46======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-LB0412E parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00241D55B904A8D86111 sCDKey = 454489402850 sName = DESKTOP-LB0412E ========================2021-05-27 10:29:46======================== 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 = '454489402850' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-27 10:29:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 's960505' ========================2021-05-27 10:29:46======================== SELECT idx FROM macs WHERE mac_addr = '00241D55B904A8D86111' AND app_code = '047' ========================2021-05-27 10:29:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344232' ========================2021-05-27 10:29:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344232' ========================2021-05-27 10:29:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '344232', '00241D55B904A8D86111', '047', 'DESKTOP-LB0412E', '�쐢�룄�슦 10', '0', '0', 's960505', '빅보이유통[손석봉]', '454489402850' ) ========================2021-05-27 13:03:25======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-0E6EFAM parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 94C691FE47206C2C4281 sCDKey = 620618697812 sName = 배관공구24시포스 ========================2021-05-27 13:03: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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-27 13:03:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-27 13:03:25======================== SELECT idx FROM macs WHERE mac_addr = '94C691FE47206C2C4281' AND app_code = '046' ========================2021-05-27 13:03:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344246' ========================2021-05-27 13:03:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344246' ========================2021-05-27 13:03:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '344246', '94C691FE47206C2C4281', '046', '배관공구24시포스', '110', '1680', '1050', 'k4074356', '주식회사배관공구24시[김귀한]', '620618697812' ) ========================2021-05-27 13:39:22======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6UDQ8SM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3C7C3FF3E351F65F2609 sCDKey = 971342867571 sName = DESKTOP-6UDQ8SM ========================2021-05-27 13:39:22======================== 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 = '971342867571' AND r.app_code = '039' AND r.app_block = 0 ========================2021-05-27 13:39:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mtdst30' ========================2021-05-27 13:39:22======================== SELECT idx FROM macs WHERE mac_addr = '3C7C3FF3E351F65F2609' AND app_code = '039' ========================2021-05-27 13:39:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344250' ========================2021-05-27 13:39:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344250' ========================2021-05-27 13:39:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '344250', '3C7C3FF3E351F65F2609', '039', 'DESKTOP-6UDQ8SM', '110', '1920', '1080', 'mtdst30', '주식회사에스하이테크[유용훈]', '971342867571' ) ========================2021-05-27 14:50:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-Q1671TK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8BBC119715890C13917 sCDKey = 936245283016 sName = DESKTOP-Q1671TK ========================2021-05-27 14:50: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 = '936245283016' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-27 14:50:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeong4023' ========================2021-05-27 14:50:55======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC119715890C13917' AND app_code = '046' ========================2021-05-27 14:50:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343680' ========================2021-05-27 14:50:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343680' ========================2021-05-27 14:50:55======================== UPDATE mac_detail SET pc_name = 'DESKTOP-Q1671TK', os_type = '110', user_id = 'jeong4023', user_name = '[김태정]', screen_w = '1920', screen_h = '1080', cdkey = '936245283016' WHERE mac_idx = '343680' ========================2021-05-27 16:34:50======================== noteurl_start parm_app_code = 046 parm_pc_name = CHOCO-2DD4BEC4A parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F04DA2EF4B1F70979762 sCDKey = 620618697812 sName = CHOCO-2DD4BEC4A ========================2021-05-27 16:34:50======================== 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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-27 16:34:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-27 16:34:50======================== SELECT idx FROM macs WHERE mac_addr = 'F04DA2EF4B1F70979762' AND app_code = '046' ========================2021-05-27 16:34:50======================== 값이 없을 경우 ========================2021-05-27 16:38:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-0E6EFAM parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 94C691FE47206C2C4281 sCDKey = 620618697812 sName = DESKTOP-0E6EFAM ========================2021-05-27 16:38:36======================== 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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-27 16:38:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2021-05-27 16:38:36======================== SELECT idx FROM macs WHERE mac_addr = '94C691FE47206C2C4281' AND app_code = '046' ========================2021-05-27 16:38:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344246' ========================2021-05-27 16:38:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344246' ========================2021-05-27 16:38:36======================== UPDATE mac_detail SET pc_name = 'DESKTOP-0E6EFAM', os_type = '110', user_id = 'k4074356', user_name = '주식회사배관공구24시[김귀한]', screen_w = '1680', screen_h = '1050', cdkey = '620618697812' WHERE mac_idx = '344246'