========================2018-02-12 09:12:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UC5GCVJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307CAC253935 sCDKey = 997008129713 sName = DESKTOP-UC5GCVJ ========================2018-02-12 09:12: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 = '997008129713' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 09:12:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ria8210' ========================2018-02-12 09:12:40======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307CAC253935' AND app_code = '039' ========================2018-02-12 09:12:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '231751' ========================2018-02-12 09:12:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '231751' ========================2018-02-12 09:12:40======================== UPDATE mac_detail SET pc_name = 'DESKTOP-UC5GCVJ', os_type = '110', user_id = 'ria8210', user_name = '미진소프트[김민정]', screen_w = '1920', screen_h = '1080', cdkey = '997008129713' WHERE mac_idx = '231751' ========================2018-02-12 10:00:18======================== 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 = D027880784025CF70ACB sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-02-12 10:00: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:01:07======================== 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 = D027880784025CF70ACB sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-02-12 10:01:07======================== 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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:35:15======================== noteurl_start parm_app_code = 039 parm_pc_name = FIRST-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 001377453E8E7A217F47 sCDKey = 755038250550 sName = FIRST-PC ========================2018-02-12 10:35:15======================== 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 = '755038250550' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:35:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skyx012' ========================2018-02-12 10:35:15======================== SELECT idx FROM macs WHERE mac_addr = '001377453E8E7A217F47' AND app_code = '039' ========================2018-02-12 10:35:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241869' ========================2018-02-12 10:35:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241869' ========================2018-02-12 10:35:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241869', '001377453E8E7A217F47', '039', 'FIRST-PC', '90', '1600', '900', 'skyx012', '정우초경[정현근]', '755038250550' ) ========================2018-02-12 10:36:23======================== 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 = D027880784025CF70ACB sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-02-12 10:36:23======================== 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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:36:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2018-02-12 10:36:23======================== SELECT idx FROM macs WHERE mac_addr = 'D027880784025CF70ACB' AND app_code = '039' ========================2018-02-12 10:36:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '100481' ========================2018-02-12 10:36:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '100481' ========================2018-02-12 10:36:23======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'julee37', user_name = '개성자바라, 스텐나라[이순녀]', screen_w = '1680', screen_h = '1050', cdkey = '210742859361' WHERE mac_idx = '100481' ========================2018-02-12 10:42:20======================== 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 = D02788078402984E2974 sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-02-12 10:42:20======================== 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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:42:24======================== 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 = D02788078402984E2974 sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-02-12 10:42: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:42:57======================== 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 = D02788078402984E2974 sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-02-12 10:42: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:43:37======================== 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 = D02788078402984E2974 sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-02-12 10:43: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:48:20======================== 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 = D02788078402984E2974 sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-02-12 10:48:20======================== 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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 10:48:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2018-02-12 10:48:20======================== SELECT idx FROM macs WHERE mac_addr = 'D02788078402984E2974' AND app_code = '039' ========================2018-02-12 10:48:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198515' ========================2018-02-12 10:48:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198515' ========================2018-02-12 10:48:20======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'julee37', user_name = '개성자바라, 스텐나라[이순녀]', screen_w = '1680', screen_h = '1050', cdkey = '210742859361' WHERE mac_idx = '198515' ========================2018-02-12 11:58:48======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-81JGTFO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C8D3FFDDCAC2965B4432 sCDKey = 850547206049 sName = DESKTOP-81JGTFO ========================2018-02-12 11:58: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 = '850547206049' AND r.app_code = '048' AND r.app_block = 0 ========================2018-02-12 11:58:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chamnara' ========================2018-02-12 11:58:48======================== SELECT idx FROM macs WHERE mac_addr = 'C8D3FFDDCAC2965B4432' AND app_code = '048' ========================2018-02-12 11:58:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241999' ========================2018-02-12 11:58:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241999' ========================2018-02-12 11:58: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 ( '241999', 'C8D3FFDDCAC2965B4432', '048', 'DESKTOP-81JGTFO', '�쐢�룄�슦 10', '0', '0', 'chamnara', '(주)참나라 농업회사법인[임준상]', '850547206049' ) ========================2018-02-12 13:08:42======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 24F5AADD1B803C6EA39D sCDKey = 203284525937 sName = ========================2018-02-12 13:08: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 = '203284525937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 13:08:52======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 24F5AADD1B803C6EA39D sCDKey = 203284525937 sName = 합천기계산업 ========================2018-02-12 13:08:52======================== 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 = '203284525937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 13:09:00======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 24F5AADD1B803C6EA39D sCDKey = 203184525937 sName = 합천기계산업 ========================2018-02-12 13:09: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 = '203184525937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 13:10:31======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 24F5AADD1B803C6EA39D sCDKey = 203284525937 sName = 합천기계산업 ========================2018-02-12 13:10: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 = '203284525937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 13:11:40======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 24F5AADD1B803C6EA39D sCDKey = 202384525937 sName = 합천기계산업 ========================2018-02-12 13:11: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 = '202384525937' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 13:11:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skd77' ========================2018-02-12 13:11:40======================== SELECT idx FROM macs WHERE mac_addr = '24F5AADD1B803C6EA39D' AND app_code = '039' ========================2018-02-12 13:11:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242004' ========================2018-02-12 13:11:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242004' ========================2018-02-12 13:11: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 ( '242004', '24F5AADD1B803C6EA39D', '039', '합천기계산업', '110', '1536', '864', 'skd77', '성광기계[김대원]', '202384525937' ) ========================2018-02-12 13:47:28======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-K81J7NTLGEC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E19C70A3E5A7296 sCDKey = 586506022316 sName = WIN-K81J7NTLGEC ========================2018-02-12 13:47:28======================== 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 = '586506022316' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 13:47:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ems1532' ========================2018-02-12 13:47:28======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E19C70A3E5A7296' AND app_code = '039' ========================2018-02-12 13:47:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242015' ========================2018-02-12 13:47:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242015' ========================2018-02-12 13:47:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '242015', 'E0D55E19C70A3E5A7296', '039', 'WIN-K81J7NTLGEC', '90', '1920', '1080', 'ems1532', '이엠에스TECH[김승수]', '586506022316' ) ========================2018-02-12 15:12:06======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 002421B319C124CA1BE3 sCDKey = 812834265902 sName = MSDN-SPECIAL ========================2018-02-12 15:12: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 = '812834265902' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 15:12:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vnfmsshdtks' ========================2018-02-12 15:12:06======================== SELECT idx FROM macs WHERE mac_addr = '002421B319C124CA1BE3' AND app_code = '039' ========================2018-02-12 15:12:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242028' ========================2018-02-12 15:12:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242028' ========================2018-02-12 15:12: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 ( '242028', '002421B319C124CA1BE3', '039', 'MSDN-SPECIAL', '90', '1280', '1024', 'vnfmsshdtks', '푸른농산[이재훈]', '812834265902' ) ========================2018-02-12 16:33:02======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-53N079G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FFFFFFFFFFFFB63B458A sCDKey = 645263831716 sName = WINDOWS-53N079G ========================2018-02-12 16:33:02======================== 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 = '645263831716' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 16:39:10======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-53N079G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FFFFFFFFFFFFB63B458A sCDKey = 645263831716 sName = WINDOWS-53N079G ========================2018-02-12 16:39: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 = '645263831716' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 16:40:12======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-53N079G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FFFFFFFFFFFFB63B458A sCDKey = 645263831716 sName = WINDOWS-53N079G ========================2018-02-12 16:40: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 = '645263831716' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-12 16:40:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuh5300' ========================2018-02-12 16:40:12======================== SELECT idx FROM macs WHERE mac_addr = 'FFFFFFFFFFFFB63B458A' AND app_code = '039' ========================2018-02-12 16:40:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242040' ========================2018-02-12 16:40:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242040' ========================2018-02-12 16:40: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 ( '242040', 'FFFFFFFFFFFFB63B458A', '039', 'WINDOWS-53N079G', '110', '1920', '1080', 'yuh5300', '삼성상사[윤현중]', '645263831716' )