========================2020-03-12 09:38:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FJCD1DG parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0862669EA6316AE39184 sCDKey = 210742859361 sName = DESKTOP-FJCD1DG ========================2020-03-12 09:38:19======================== 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 ========================2020-03-12 09:39:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FJCD1DG parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0862669EA6316AE39184 sCDKey = 210742859361 sName = DESKTOP-FJCD1DG ========================2020-03-12 09:39: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 09:39:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2020-03-12 09:39:41======================== SELECT idx FROM macs WHERE mac_addr = '0862669EA6316AE39184' AND app_code = '039' ========================2020-03-12 09:39:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312799' ========================2020-03-12 09:39:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312799' ========================2020-03-12 09:39:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '312799', '0862669EA6316AE39184', '039', 'DESKTOP-FJCD1DG', '110', '1680', '1050', 'julee37', '개성자바라, 스텐나라[이순녀]', '210742859361' ) ========================2020-03-12 13:35:14======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GO8STMH parm_os_type = 110 parm_screen_w = 1080 parm_screen_h = 1920 parm_user_mac = 803253F4639D6DBC9E9 sCDKey = 342918991698 sName = DESKTOP-GO8STMH ========================2020-03-12 13:35: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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-12 13:35:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-03-12 13:35:14======================== SELECT idx FROM macs WHERE mac_addr = '803253F4639D6DBC9E9' AND app_code = '046' ========================2020-03-12 13:35:14======================== 값이 없을 경우 ========================2020-03-12 14:06:49======================== 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-03-12 14:06: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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-12 14:06:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-03-12 14:06:49======================== SELECT idx FROM macs WHERE mac_addr = '803253F4639D6DBC9E9' AND app_code = '046' ========================2020-03-12 14:06:49======================== 값이 없을 경우 ========================2020-03-12 14:08:28======================== 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-03-12 14:08: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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-12 14:08:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-03-12 14:08:28======================== SELECT idx FROM macs WHERE mac_addr = '803253F4639D6DBC9E9' AND app_code = '046' ========================2020-03-12 14:08:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312854' ========================2020-03-12 14:08:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312854' ========================2020-03-12 14:08: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 ( '312854', '803253F4639D6DBC9E9', '046', 'DESKTOP-GO8STMH', '110', '1920', '1080', 'jun9317718', '한농연농자재영농조합법인[전종석]', '342918991698' ) ========================2020-03-12 15:51:48======================== noteurl_start parm_app_code = 046 parm_pc_name = PBPOS-B755KE61E parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = C03FD5BEE56428EE181D sCDKey = 384492639814 sName = PBPOS-B755KE61E ========================2020-03-12 15:51: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 = '384492639814' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-12 15:51:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'saintkcu' ========================2020-03-12 15:51:48======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BEE56428EE181D' AND app_code = '046' ========================2020-03-12 15:51:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '146352' ========================2020-03-12 15:51:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '146352' ========================2020-03-12 15:51:48======================== UPDATE mac_detail SET pc_name = 'PBPOS-B755KE61E', os_type = '64', user_id = 'saintkcu', user_name = '농업회사법인 자연앤푸드 주식회사[김종운]', screen_w = '1024', screen_h = '768', cdkey = '384492639814' WHERE mac_idx = '146352' ========================2020-03-12 15:54:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UB3QREP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 448A5BFDCD94BA1C5686 sCDKey = 210742859361 sName = DESKTOP-UB3QREP ========================2020-03-12 15:54: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 15:54:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2020-03-12 15:54:54======================== SELECT idx FROM macs WHERE mac_addr = '448A5BFDCD94BA1C5686' AND app_code = '039' ========================2020-03-12 15:54:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312868' ========================2020-03-12 15:54:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312868' ========================2020-03-12 15:54:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '312868', '448A5BFDCD94BA1C5686', '039', 'DESKTOP-UB3QREP', '110', '1920', '1080', 'julee37', '개성자바라, 스텐나라[이순녀]', '210742859361' ) ========================2020-03-12 15:58:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UB3QREP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 448A5BFDCD94184AA725 sCDKey = 210742859361 sName = DESKTOP-UB3QREP ========================2020-03-12 15:58: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 15:58:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2020-03-12 15:58:11======================== SELECT idx FROM macs WHERE mac_addr = '448A5BFDCD94184AA725' AND app_code = '039' ========================2020-03-12 15:58:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312869' ========================2020-03-12 15:58:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312869' ========================2020-03-12 15:58:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '312869', '448A5BFDCD94184AA725', '039', 'DESKTOP-UB3QREP', '110', '1920', '1080', 'julee37', '개성자바라, 스텐나라[이순녀]', '210742859361' ) ========================2020-03-12 16:04:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UB3QREP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 448A5BFDCD94BA1C5686 sCDKey = 618539780807 sName = DESKTOP-UB3QREP ========================2020-03-12 16:04: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 = '618539780807' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 16:04:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ldi3254' ========================2020-03-12 16:04:52======================== SELECT idx FROM macs WHERE mac_addr = '448A5BFDCD94BA1C5686' AND app_code = '039' ========================2020-03-12 16:04:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312868' ========================2020-03-12 16:04:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312868' ========================2020-03-12 16:04:52======================== UPDATE mac_detail SET pc_name = 'DESKTOP-UB3QREP', os_type = '110', user_id = 'ldi3254', user_name = '한국총판[이정업]', screen_w = '1920', screen_h = '1080', cdkey = '618539780807' WHERE mac_idx = '312868' ========================2020-03-12 16:19:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UB3QREP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 448A5BFDCD94BA1C5686 sCDKey = 618539780807 sName = DESKTOP-UB3QREP ========================2020-03-12 16:19: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 = '618539780807' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 16:19:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ldi3254' ========================2020-03-12 16:19:50======================== SELECT idx FROM macs WHERE mac_addr = '448A5BFDCD94BA1C5686' AND app_code = '039' ========================2020-03-12 16:19:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312868' ========================2020-03-12 16:19:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312868' ========================2020-03-12 16:19:50======================== UPDATE mac_detail SET pc_name = 'DESKTOP-UB3QREP', os_type = '110', user_id = 'ldi3254', user_name = '한국총판[이정업]', screen_w = '1920', screen_h = '1080', cdkey = '618539780807' WHERE mac_idx = '312868' ========================2020-03-12 16:20:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UB3QREP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 448A5BFDCD94BA1C5686 sCDKey = 618539780807 sName = DESKTOP-UB3QREP ========================2020-03-12 16:20: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 = '618539780807' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 16:44:31======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 0019D18BC9C649BEFEE sCDKey = 618539780807 sName = MSDN-SPECIAL ========================2020-03-12 16:44: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 = '618539780807' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 16:46:27======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 0019D18BC9C649BEFEE sCDKey = 618539780807 sName = MSDN-SPECIAL ========================2020-03-12 16:46:27======================== 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 = '618539780807' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 16:46:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ldi3254' ========================2020-03-12 16:46:27======================== SELECT idx FROM macs WHERE mac_addr = '0019D18BC9C649BEFEE' AND app_code = '039' ========================2020-03-12 16:46:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '195245' ========================2020-03-12 16:46:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '195245' ========================2020-03-12 16:46:27======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'ldi3254', user_name = '한국총판[이정업]', screen_w = '1024', screen_h = '768', cdkey = '618539780807' WHERE mac_idx = '195245' ========================2020-03-12 16:56:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UB3QREP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 448A5BFDCD94BA1C5686 sCDKey = 618539780807 sName = DESKTOP-UB3QREP ========================2020-03-12 16:56:51======================== 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 = '618539780807' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-12 16:56:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ldi3254' ========================2020-03-12 16:56:51======================== SELECT idx FROM macs WHERE mac_addr = '448A5BFDCD94BA1C5686' AND app_code = '039' ========================2020-03-12 16:56:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312868' ========================2020-03-12 16:56:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312868' ========================2020-03-12 16:56:51======================== UPDATE mac_detail SET pc_name = 'DESKTOP-UB3QREP', os_type = '110', user_id = 'ldi3254', user_name = '한국총판[이정업]', screen_w = '1920', screen_h = '1080', cdkey = '618539780807' WHERE mac_idx = '312868' ========================2020-03-12 16:57:14======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-U7EB1I0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30BC78108EE79D3E sCDKey = 807375456416 sName = DESKTOP-U7EB1I0 ========================2020-03-12 16:57: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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2020-03-12 16:57:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gana4807' ========================2020-03-12 16:57:14======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC78108EE79D3E' AND app_code = '047' ========================2020-03-12 16:57:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312874' ========================2020-03-12 16:57:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312874' ========================2020-03-12 16:57:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '312874', 'F44D30BC78108EE79D3E', '047', 'DESKTOP-U7EB1I0', '�쐢�룄�슦 10', '0', '0', 'gana4807', '(주)가나24시동물병원[김창규]', '807375456416' )