========================2021-07-23 13:23:44======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB0FCE143BB83D sCDKey = 952469659701 sName = MSDN-SPECIAL ========================2021-07-23 13:23:44======================== 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 = '952469659701' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-23 13:23:59======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB0FCE143BB83D sCDKey = 952469659701 sName = MSDN-SPECIAL ========================2021-07-23 13:23:59======================== 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 = '952469659701' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-23 13:23:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs466' ========================2021-07-23 13:23:59======================== SELECT idx FROM macs WHERE mac_addr = 'E89A8FDB0FCE143BB83D' AND app_code = '039' ========================2021-07-23 13:23:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '185379' ========================2021-07-23 13:23:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '185379' ========================2021-07-23 13:23:59======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'bs466', user_name = '명진산업[부산지사]', screen_w = '1920', screen_h = '1080', cdkey = '952469659701' WHERE mac_idx = '185379' ========================2021-07-23 13:55:58======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-PTN1OFD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B4B52FB5503D6E009188 sCDKey = 737699781943 sName = DESKTOP-PTN1OFD ========================2021-07-23 13:55: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 = '737699781943' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-23 13:55:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dwriro75' ========================2021-07-23 13:55:58======================== SELECT idx FROM macs WHERE mac_addr = 'B4B52FB5503D6E009188' AND app_code = '039' ========================2021-07-23 13:55:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348009' ========================2021-07-23 13:55:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348009' ========================2021-07-23 13:55: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 ( '348009', 'B4B52FB5503D6E009188', '039', 'DESKTOP-PTN1OFD', '110', '1920', '1080', 'dwriro75', '(주)엘엠에스코리아[김용수]', '737699781943' ) ========================2021-07-23 14:25:43======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FB4Q5II parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A8A1594EE27532E85C33 sCDKey = 037433637550 sName = DESKTOP-FB4Q5II ========================2021-07-23 14:25: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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-07-23 14:44:17======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FB4Q5II parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A8A1594EE27532E85C33 sCDKey = 037433637550 sName = DESKTOP-FB4Q5II ========================2021-07-23 14:44: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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-07-23 14:44:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hpf1937' ========================2021-07-23 14:44:17======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1594EE27532E85C33' AND app_code = '048' ========================2021-07-23 14:44:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '345364' ========================2021-07-23 14:44:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '345364' ========================2021-07-23 14:44:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '345364', 'A8A1594EE27532E85C33', '048', 'DESKTOP-FB4Q5II', '�쐢�룄�슦 10', '0', '0', 'hpf1937', '주식회사 햇품유통[이남훈]', '037433637550' ) ========================2021-07-23 14:44:30======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FB4Q5II parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A8A1594EE27532E85C33 sCDKey = 037433637550 sName = DESKTOP-FB4Q5II ========================2021-07-23 14:44: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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-07-23 14:45:00======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FB4Q5II parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A8A1594EE27532E85C33 sCDKey = 037433637550 sName = DESKTOP-FB4Q5II ========================2021-07-23 14:45: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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-07-23 15:35:47======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-I78EUGC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FC3497BC48D89EB96F9E sCDKey = 037433637550 sName = DESKTOP-I78EUGC ========================2021-07-23 15:35: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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-07-23 15:35:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hpf1937' ========================2021-07-23 15:35:47======================== SELECT idx FROM macs WHERE mac_addr = 'FC3497BC48D89EB96F9E' AND app_code = '048' ========================2021-07-23 15:35:47======================== 값이 없을 경우 ========================2021-07-23 15:36:59======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-I78EUGC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FC3497BC48D89EB96F9E sCDKey = 037433637550 sName = DESKTOP-I78EUGC ========================2021-07-23 15:36:59======================== 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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-07-23 15:36:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hpf1937' ========================2021-07-23 15:36:59======================== SELECT idx FROM macs WHERE mac_addr = 'FC3497BC48D89EB96F9E' AND app_code = '048' ========================2021-07-23 15:36:59======================== 값이 없을 경우 ========================2021-07-23 15:41:12======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-I78EUGC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FC3497BC48D89EB96F9E sCDKey = 037433637550 sName = DESKTOP-I78EUGC ========================2021-07-23 15:41:12======================== 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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-07-23 15:41:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hpf1937' ========================2021-07-23 15:41:12======================== SELECT idx FROM macs WHERE mac_addr = 'FC3497BC48D89EB96F9E' AND app_code = '048' ========================2021-07-23 15:41:12======================== 값이 없을 경우 ========================2021-07-23 15:49:13======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-I78EUGC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FC3497BC48D89EB96F9E sCDKey = 037433637550 sName = DESKTOP-I78EUGC ========================2021-07-23 15:49:13======================== 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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-07-23 15:49:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hpf1937' ========================2021-07-23 15:49:13======================== SELECT idx FROM macs WHERE mac_addr = 'FC3497BC48D89EB96F9E' AND app_code = '048' ========================2021-07-23 15:49:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348023' ========================2021-07-23 15:49:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348023' ========================2021-07-23 15:49:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '348023', 'FC3497BC48D89EB96F9E', '048', 'DESKTOP-I78EUGC', '�쐢�룄�슦 10', '0', '0', 'hpf1937', '주식회사 햇품유통[이남훈]', '037433637550' ) ========================2021-07-23 17:03:18======================== noteurl_start parm_app_code = 046 parm_pc_name = TODAM-MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30AF727E1AE49397 sCDKey = 806188523362 sName = TODAM-MAIN ========================2021-07-23 17:03: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 = '806188523362' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-23 17:03:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'todamls' ========================2021-07-23 17:03:18======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30AF727E1AE49397' AND app_code = '046' ========================2021-07-23 17:03:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250267' ========================2021-07-23 17:03:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250267' ========================2021-07-23 17:03:18======================== UPDATE mac_detail SET pc_name = 'TODAM-MAIN', os_type = '110', user_id = 'todamls', user_name = '토담물류[유대웅]', screen_w = '1920', screen_h = '1080', cdkey = '806188523362' WHERE mac_idx = '250267'