========================2020-01-15 06:13:06======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-HDSGO4R parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E995A40AC26606CDA sCDKey = 519446023808 sName = DESKTOP-HDSGO4R ========================2020-01-15 06:13: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 = '519446023808' AND r.app_code = '048' AND r.app_block = 0 ========================2020-01-15 06:13:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jaeshim1439' ========================2020-01-15 06:13:06======================== SELECT idx FROM macs WHERE mac_addr = 'B42E995A40AC26606CDA' AND app_code = '048' ========================2020-01-15 06:13:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308175' ========================2020-01-15 06:13:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308175' ========================2020-01-15 06:13:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308175', 'B42E995A40AC26606CDA', '048', 'DESKTOP-HDSGO4R', '�쐢�룄�슦 10', '0', '0', 'jaeshim1439', '주식회사현동인터내셔널[이재심]', '519446023808' ) ========================2020-01-15 09:34:47======================== noteurl_start parm_app_code = 039 parm_pc_name = SSNTW10HX64 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 98838917548CE0BFFC88 sCDKey = 827754547202 sName = SSNTW10HX64 ========================2020-01-15 09:34: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 = '827754547202' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-15 09:34:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhw600' ========================2020-01-15 09:34:47======================== SELECT idx FROM macs WHERE mac_addr = '98838917548CE0BFFC88' AND app_code = '039' ========================2020-01-15 09:34:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308197' ========================2020-01-15 09:34:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308197' ========================2020-01-15 09:34:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308197', '98838917548CE0BFFC88', '039', 'SSNTW10HX64', '110', '1366', '768', 'jhw600', '서진안전[장호원]', '827754547202' ) ========================2020-01-15 11:15:36======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CFAKFUV parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050991D919B68481B52 sCDKey = 845470325870 sName = DESKTOP-CFAKFUV ========================2020-01-15 11:15: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 = '845470325870' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-15 11:15:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daesin' ========================2020-01-15 11:15:37======================== SELECT idx FROM macs WHERE mac_addr = 'D050991D919B68481B52' AND app_code = '039' ========================2020-01-15 11:15:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308225' ========================2020-01-15 11:15:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308225' ========================2020-01-15 11:15: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 ( '308225', 'D050991D919B68481B52', '039', 'DESKTOP-CFAKFUV', '110', '1920', '1080', 'daesin', '대신중기[김명상]', '845470325870' ) ========================2020-01-15 13:05:57======================== noteurl_start parm_app_code = 047 parm_pc_name = ADMINISTRATOR parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A0A921F942362F3 sCDKey = 034291734286 sName = ADMINISTRATOR ========================2020-01-15 13:05: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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-01-15 13:10:49======================== noteurl_start parm_app_code = 047 parm_pc_name = ADMINISTRATOR parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A0A921F942362F3 sCDKey = 034291734286 sName = ADMINISTRATOR ========================2020-01-15 13:10:49======================== 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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-01-15 13:11:11======================== noteurl_start parm_app_code = 047 parm_pc_name = ADMINISTRATOR parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A0A921F942362F3 sCDKey = 034291734286 sName = ADMINISTRATOR ========================2020-01-15 13:11:11======================== 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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-01-15 13:11:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-01-15 13:11:12======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A0A921F942362F3' AND app_code = '047' ========================2020-01-15 13:11:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308243' ========================2020-01-15 13:11:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308243' ========================2020-01-15 13:11:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308243', 'B8975A0A921F942362F3', '047', 'ADMINISTRATOR', '�쐢�룄�슦 7', '0', '0', 'yuillss', '유일공구철물[김번영]', '034291734286' ) ========================2020-01-15 13:12:44======================== noteurl_start parm_app_code = 047 parm_pc_name = ADMINISTRATOR parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A0A900F942362F3 sCDKey = 034291734286 sName = ADMINISTRATOR ========================2020-01-15 13:12: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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-01-15 13:12:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-01-15 13:12:44======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A0A900F942362F3' AND app_code = '047' ========================2020-01-15 13:12:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308245' ========================2020-01-15 13:12:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308245' ========================2020-01-15 13:12:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308245', 'B8975A0A900F942362F3', '047', 'ADMINISTRATOR', '�쐢�룄�슦 7', '0', '0', 'yuillss', '유일공구철물[김번영]', '034291734286' ) ========================2020-01-15 13:14:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0P6RO9F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAEAC11F46736890 sCDKey = 453168321923 sName = DESKTOP-0P6RO9F ========================2020-01-15 13:14: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 = '453168321923' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-15 13:14:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k104121' ========================2020-01-15 13:14:48======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEAC11F46736890' AND app_code = '039' ========================2020-01-15 13:14:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308246' ========================2020-01-15 13:14:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308246' ========================2020-01-15 13:14:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308246', '24F5AAEAC11F46736890', '039', 'DESKTOP-0P6RO9F', '110', '1920', '1080', 'k104121', '법무사문병식[김보정]', '453168321923' ) ========================2020-01-15 13:18:29======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A0A900F942362F3 sCDKey = 682632039503 sName = ADMINISTRATOR ========================2020-01-15 13:18: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 = '682632039503' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 13:18:41======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A0A900F942362F3 sCDKey = 682832039503 sName = ADMINISTRATOR ========================2020-01-15 13:18: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 = '682832039503' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 13:18:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-01-15 13:18:41======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A0A900F942362F3' AND app_code = '046' ========================2020-01-15 13:18:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229778' ========================2020-01-15 13:18:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '229778' ========================2020-01-15 13:18:41======================== UPDATE mac_detail SET pc_name = 'ADMINISTRATOR', os_type = '90', user_id = 'yuillss', user_name = '유일공구철물[김번영]', screen_w = '1024', screen_h = '768', cdkey = '682832039503' WHERE mac_idx = '229778' ========================2020-01-15 13:21:08======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A0A921F942362F3 sCDKey = 682832039503 sName = ADMINISTRATOR ========================2020-01-15 13:21: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 = '682832039503' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 13:21:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-01-15 13:21:08======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A0A921F942362F3' AND app_code = '046' ========================2020-01-15 13:21:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229159' ========================2020-01-15 13:21:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '229159' ========================2020-01-15 13:21:08======================== UPDATE mac_detail SET pc_name = 'ADMINISTRATOR', os_type = '90', user_id = 'yuillss', user_name = '유일공구철물[김번영]', screen_w = '1024', screen_h = '768', cdkey = '682832039503' WHERE mac_idx = '229159' ========================2020-01-15 13:27:43======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AF6F99B942362F3 sCDKey = 682832039503 sName = ADMINISTRATOR ========================2020-01-15 13:27: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 = '682832039503' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 13:27:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-01-15 13:27:43======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AF6F99B942362F3' AND app_code = '046' ========================2020-01-15 13:27:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229160' ========================2020-01-15 13:27:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '229160' ========================2020-01-15 13:27:43======================== UPDATE mac_detail SET pc_name = 'ADMINISTRATOR', os_type = '90', user_id = 'yuillss', user_name = '유일공구철물[김번영]', screen_w = '1024', screen_h = '768', cdkey = '682832039503' WHERE mac_idx = '229160' ========================2020-01-15 13:31:53======================== noteurl_start parm_app_code = 047 parm_pc_name = ADMINISTRATOR parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975AF6F99B1ED4F19D sCDKey = 034291734286 sName = ADMINISTRATOR ========================2020-01-15 13:31: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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-01-15 13:31:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-01-15 13:31:53======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AF6F99B1ED4F19D' AND app_code = '047' ========================2020-01-15 13:31:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306823' ========================2020-01-15 13:31:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306823' ========================2020-01-15 13:31:53======================== UPDATE mac_detail SET pc_name = 'ADMINISTRATOR', os_type = '�쐢�룄�슦 7', user_id = 'yuillss', user_name = '유일공구철물[김번영]', screen_w = '0', screen_h = '0', cdkey = '034291734286' WHERE mac_idx = '306823' ========================2020-01-15 13:53:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-58KBD5U parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1867B032E36A8594EF0 sCDKey = 272831752859 sName = DESKTOP-58KBD5U ========================2020-01-15 13:53: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 = '272831752859' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-15 13:53:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljw418' ========================2020-01-15 13:53:56======================== SELECT idx FROM macs WHERE mac_addr = '1867B032E36A8594EF0' AND app_code = '039' ========================2020-01-15 13:53:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308077' ========================2020-01-15 13:53:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308077' ========================2020-01-15 13:53: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 ( '308077', '1867B032E36A8594EF0', '039', 'DESKTOP-58KBD5U', '110', '1920', '1080', 'ljw418', '(주)대명박스[박근학]', '272831752859' ) ========================2020-01-15 15:29:22======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 9C5C8E873A6CE7346EE sCDKey = 170172852468 sName = 맹병렬 ========================2020-01-15 15:29: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 = '170172852468' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-15 15:29:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sasimi2918' ========================2020-01-15 15:29:22======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E873A6CE7346EE' AND app_code = '039' ========================2020-01-15 15:29:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308269' ========================2020-01-15 15:29:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308269' ========================2020-01-15 15:29:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308269', '9C5C8E873A6CE7346EE', '039', '맹병렬', '90', '1680', '1050', 'sasimi2918', '다랑참치[맹병열]', '170172852468' ) ========================2020-01-15 15:29:29======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 9C5C8E873A6CE7346EE sCDKey = 170172852468 sName = 맹병렬 ========================2020-01-15 15:29: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 = '170172852468' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-15 16:27:39======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 487017981012 sName = MSDN-SPECIAL ========================2020-01-15 16:27:39======================== 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 = '487017981012' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 16:27:54======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2020-01-15 16:27:54======================== 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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 16:28:47======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 487017981012 sName = MSDN-SPECIAL ========================2020-01-15 16:28: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 = '487017981012' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 16:29:56======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 487017981012 sName = MSDN-SPECIAL ========================2020-01-15 16:29: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 = '487017981012' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 16:31:31======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 487017981012 sName = MSDN-SPECIAL ========================2020-01-15 16:31: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 = '487017981012' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 16:32:14======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 487017981012 sName = MSDN-SPECIAL ========================2020-01-15 16:32:14======================== 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 = '487017981012' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 16:33:37======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 487017981012 sName = MSDN-SPECIAL ========================2020-01-15 16:33: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 = '487017981012' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 16:34:13======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 60029238BF014A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2020-01-15 16:34: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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2020-01-15 16:34:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'groutmart' ========================2020-01-15 16:34:13======================== SELECT idx FROM macs WHERE mac_addr = '60029238BF014A97C7E2' AND app_code = '046' ========================2020-01-15 16:34:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252137' ========================2020-01-15 16:34:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252137' ========================2020-01-15 16:34:13======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '110', user_id = 'groutmart', user_name = '크린앤네이처[줄눈마트]', screen_w = '1920', screen_h = '1080', cdkey = '573190698474' WHERE mac_idx = '252137'