========================2020-11-23 10:51:50======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GO8STMH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 803253F4639D6DBC9E9 sCDKey = 342918991698 sName = DESKTOP-GO8STMH ========================2020-11-23 10:51: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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-23 10:51:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-11-23 10:51:50======================== SELECT idx FROM macs WHERE mac_addr = '803253F4639D6DBC9E9' AND app_code = '046' ========================2020-11-23 10:51:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312854' ========================2020-11-23 10:51:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312854' ========================2020-11-23 10:51:50======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GO8STMH', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]', screen_w = '1920', screen_h = '1080', cdkey = '342918991698' WHERE mac_idx = '312854' ========================2020-11-23 11:29:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S0TGTE2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCEE7BE1F414E8DEBC55 sCDKey = 205642902379 sName = DESKTOP-S0TGTE2 ========================2020-11-23 11:29: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 = '205642902379' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-23 11:29:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjc5120' ========================2020-11-23 11:29:35======================== SELECT idx FROM macs WHERE mac_addr = 'BCEE7BE1F414E8DEBC55' AND app_code = '039' ========================2020-11-23 11:29:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330664' ========================2020-11-23 11:29:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330664' ========================2020-11-23 11:29: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 ( '330664', 'BCEE7BE1F414E8DEBC55', '039', 'DESKTOP-S0TGTE2', '110', '1920', '1080', 'kjc5120', '대일몰딩[박영순]', '205642902379' ) ========================2020-11-23 11:55:26======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-B8JEQON parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99CF4C6FCCF5F7AC sCDKey = 381943393149 sName = DESKTOP-B8JEQON ========================2020-11-23 11:55: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 = '381943393149' AND r.app_code = '045' AND r.app_block = 0 ========================2020-11-23 11:55:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'guyoung1030' ========================2020-11-23 11:55:27======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99CF4C6FCCF5F7AC' AND app_code = '045' ========================2020-11-23 11:55:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330670' ========================2020-11-23 11:55:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330670' ========================2020-11-23 11:55:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330670', 'B42E99CF4C6FCCF5F7AC', '045', 'DESKTOP-B8JEQON', '110', '1920', '1080', 'guyoung1030', '(주)봉농[정구영]', '381943393149' ) ========================2020-11-23 13:27:33======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-DPC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CF05D9A8115603E8C96 sCDKey = 618650604114 sName = USER-DPC ========================2020-11-23 13:27:33======================== 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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-23 13:27:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daelim1060' ========================2020-11-23 13:27:33======================== SELECT idx FROM macs WHERE mac_addr = '2CF05D9A8115603E8C96' AND app_code = '046' ========================2020-11-23 13:27:35======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-DPC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CF05D9A8115603E8C96 sCDKey = 618650604114 sName = USER-DPC ========================2020-11-23 13:27: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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-23 13:27:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daelim1060' ========================2020-11-23 13:27:35======================== SELECT idx FROM macs WHERE mac_addr = '2CF05D9A8115603E8C96' AND app_code = '046' ========================2020-11-23 13:27:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330593' ========================2020-11-23 13:27:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330593' ========================2020-11-23 13:27:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330593' ========================2020-11-23 13:27:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330593' ========================2020-11-23 13:27:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330593', '2CF05D9A8115603E8C96', '046', 'USER-DPC', '110', '1920', '1080', 'daelim1060', '대림농자재[이완구]', '618650604114' ) ========================2020-11-23 13:27:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330593', '2CF05D9A8115603E8C96', '046', 'USER-DPC', '110', '1920', '1080', 'daelim1060', '대림농자재[이완구]', '618650604114' ) ========================2020-11-23 14:43:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SE6DP2L parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF4DBE1942A009100 sCDKey = 223168473699 sName = DESKTOP-SE6DP2L ========================2020-11-23 14:43:57======================== 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 = '223168473699' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-23 14:43:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sms5289' ========================2020-11-23 14:43:57======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DBE1942A009100' AND app_code = '039' ========================2020-11-23 14:43:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330689' ========================2020-11-23 14:43:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330689' ========================2020-11-23 14:43:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330689', 'BC5FF4DBE1942A009100', '039', 'DESKTOP-SE6DP2L', '110', '1920', '1080', 'sms5289', '금성산업[송미숙]', '223168473699' ) ========================2020-11-23 16:07:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HUBJLQ8 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 049226D921B2CFE1204 sCDKey = 644939780548 sName = DESKTOP-HUBJLQ8 ========================2020-11-23 16:07: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 = '644939780548' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-23 16:07:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pr7221366' ========================2020-11-23 16:07:31======================== SELECT idx FROM macs WHERE mac_addr = '049226D921B2CFE1204' AND app_code = '039' ========================2020-11-23 16:07:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330698' ========================2020-11-23 16:07:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330698' ========================2020-11-23 16:07:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330698', '049226D921B2CFE1204', '039', 'DESKTOP-HUBJLQ8', '110', '1920', '1080', 'pr7221366', '광고기획푸름[박동근]', '644939780548' ) ========================2020-11-23 16:16:08======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = BCEE7B8AAD85CC9E9A24 sCDKey = 709761992239 sName = MSDN-SPECIAL ========================2020-11-23 16:16: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 = '709761992239' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-23 16:16:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bluefe225' ========================2020-11-23 16:16:08======================== SELECT idx FROM macs WHERE mac_addr = 'BCEE7B8AAD85CC9E9A24' AND app_code = '039' ========================2020-11-23 16:16:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329497' ========================2020-11-23 16:16:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329497' ========================2020-11-23 16:16:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329497', 'BCEE7B8AAD85CC9E9A24', '039', 'MSDN-SPECIAL', '90', '1680', '1050', 'bluefe225', '영진산업[김영선]', '709761992239' ) ========================2020-11-23 17:53:45======================== noteurl_start parm_app_code = 050 parm_pc_name = GT-D11008A parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F46D04D667B73624250E sCDKey = 783859378736 sName = GT-D11008A ========================2020-11-23 17:53: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 = '783859378736' AND r.app_code = '050' AND r.app_block = 0