========================2018-04-16 09:14:43======================== noteurl_start parm_app_code = 046 parm_pc_name = USER02 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002522BC714732ECD3EF sCDKey = 752642067081 sName = USER02 ========================2018-04-16 09:14: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 = '752642067081' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-16 09:14:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanadaein' ========================2018-04-16 09:14:43======================== SELECT idx FROM macs WHERE mac_addr = '002522BC714732ECD3EF' AND app_code = '046' ========================2018-04-16 09:14:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221677' ========================2018-04-16 09:14:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '221677' ========================2018-04-16 09:14:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '221677', '002522BC714732ECD3EF', '046', 'USER02', '90', '1920', '1080', 'hanadaein', '자인미래텍[김종환]', '752642067081' ) ========================2018-04-16 09:14:48======================== noteurl_start parm_app_code = 046 parm_pc_name = USER02 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002522BC714732ECD3EF sCDKey = 752642067081 sName = USER02 ========================2018-04-16 09: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 = '752642067081' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-16 09:20:46======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-G8HAKVGK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883894690EE8663BCF2 sCDKey = 886831559904 sName = LAPTOP-G8HAKVGK ========================2018-04-16 09:20:46======================== 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 = '886831559904' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 09:20:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksh0324a' ========================2018-04-16 09:20:46======================== SELECT idx FROM macs WHERE mac_addr = '9883894690EE8663BCF2' AND app_code = '039' ========================2018-04-16 09:20:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247322' ========================2018-04-16 09:20:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247322' ========================2018-04-16 09:20:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247322', '9883894690EE8663BCF2', '039', 'LAPTOP-G8HAKVGK', '110', '1920', '1080', 'ksh0324a', '성지테크[고성훈]', '886831559904' ) ========================2018-04-16 10:54:35======================== noteurl_start parm_app_code = 039 parm_pc_name = RAN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B482FE58BF33BE1B9CC5 sCDKey = 550400830049 sName = BMTEC ========================2018-04-16 10:54: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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 10:54:51======================== noteurl_start parm_app_code = 039 parm_pc_name = RAN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B482FE58BF33BE1B9CC5 sCDKey = 550400830049 sName = BMTEC ========================2018-04-16 10:54: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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 10:56:42======================== noteurl_start parm_app_code = 039 parm_pc_name = RAN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B482FE58BF33BE1B9CC5 sCDKey = 550400830049 sName = BMTEC ========================2018-04-16 10:56: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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 10:56:49======================== noteurl_start parm_app_code = 039 parm_pc_name = RAN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B482FE58BF33BE1B9CC5 sCDKey = 550400830049 sName = JBH ========================2018-04-16 10:56: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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 10:56:55======================== noteurl_start parm_app_code = 039 parm_pc_name = RAN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B482FE58BF33BE1B9CC5 sCDKey = 550400830049 sName = BMTEC ========================2018-04-16 10:56:55======================== 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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 10:58:29======================== noteurl_start parm_app_code = 039 parm_pc_name = RAN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B482FE58BF33BE1B9CC5 sCDKey = 550400830049 sName = BMTEC ========================2018-04-16 10:58: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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 10:58:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bmtec' ========================2018-04-16 10:58:29======================== SELECT idx FROM macs WHERE mac_addr = 'B482FE58BF33BE1B9CC5' AND app_code = '039' ========================2018-04-16 10:58:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247328' ========================2018-04-16 10:58:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247328' ========================2018-04-16 10:58:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247328', 'B482FE58BF33BE1B9CC5', '039', 'BMTEC', '90', '1600', '900', 'bmtec', 'BMTEC[전보현]', '550400830049' ) ========================2018-04-16 10:58:33======================== noteurl_start parm_app_code = 039 parm_pc_name = RAN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B482FE58BF33BE1B9CC5 sCDKey = 550400830049 sName = BMTEC ========================2018-04-16 10:58: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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 16:02:13======================== noteurl_start parm_app_code = 046 parm_pc_name = AF310-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8416F9079B5A24659202 sCDKey = 343408108095 sName = AF310-PC ========================2018-04-16 16:02: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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-16 16:02:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rain1479' ========================2018-04-16 16:02:13======================== SELECT idx FROM macs WHERE mac_addr = '8416F9079B5A24659202' AND app_code = '046' ========================2018-04-16 16:02:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247384' ========================2018-04-16 16:02:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247384' ========================2018-04-16 16:02: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 ( '247384', '8416F9079B5A24659202', '046', 'AF310-PC', '90', '1920', '1080', 'rain1479', '한영사[고경태]', '343408108095' ) ========================2018-04-16 16:45:27======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-63M170D parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E2EDF8771CC29CBCBDCD sCDKey = 231409622334 sName = DESKTOP-63M170D ========================2018-04-16 16:45: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 = '231409622334' AND r.app_code = '045' AND r.app_block = 0 ========================2018-04-16 16:45:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'azell3342' ========================2018-04-16 16:45:27======================== SELECT idx FROM macs WHERE mac_addr = 'E2EDF8771CC29CBCBDCD' AND app_code = '045' ========================2018-04-16 16:45:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247389' ========================2018-04-16 16:45:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247389' ========================2018-04-16 16:45: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 ( '247389', 'E2EDF8771CC29CBCBDCD', '045', 'DESKTOP-63M170D', '110', '1536', '864', 'azell3342', '(주)아셀식품[손민희]', '231409622334' ) ========================2018-04-16 17:05:36======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 960 parm_user_mac = E0D55E57A01922D18A85 sCDKey = 068475284698 sName = USER-PC ========================2018-04-16 17:05: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 = '068475284698' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 17:05:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whaudghks71' ========================2018-04-16 17:05:36======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E57A01922D18A85' AND app_code = '039' ========================2018-04-16 17:05:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247392' ========================2018-04-16 17:05:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247392' ========================2018-04-16 17:05:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247392', 'E0D55E57A01922D18A85', '039', 'USER-PC', '90', '1280', '960', 'whaudghks71', '민영[조명환]', '068475284698' ) ========================2018-04-16 17:39:10======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PIUPI21 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCEE7B8BF6BA3AF1A65A sCDKey = 449570970624 sName = DESKTOP-PIUPI21 ========================2018-04-16 17: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 = '449570970624' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-16 17:40:51======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PIUPI21 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCEE7B8BF6BA3AF1A65A sCDKey = 449570970624 sName = DESKTOP-PIUPI21 ========================2018-04-16 17:40: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 = '449570970624' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-16 17:41:22======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PIUPI21 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCEE7B8BF6BA3AF1A65A sCDKey = 449570970624 sName = DESKTOP-PIUPI21 ========================2018-04-16 17:41: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 = '449570970624' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-16 17:41:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinsin00' ========================2018-04-16 17:41:22======================== SELECT idx FROM macs WHERE mac_addr = 'BCEE7B8BF6BA3AF1A65A' AND app_code = '046' ========================2018-04-16 17:41:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247404' ========================2018-04-16 17:41:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247404' ========================2018-04-16 17:41: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 ( '247404', 'BCEE7B8BF6BA3AF1A65A', '046', 'DESKTOP-PIUPI21', '110', '1920', '1080', 'sinsin00', '신신낚시유성점[민홍기]', '449570970624' ) ========================2018-04-16 20:12:50======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-16 20:12: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:13:43======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-16 20:13: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:14:46======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-16 20:14:46======================== 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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:15:19======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-16 20:15: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:18:58======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-16 20:18: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:24:47======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-16 20:24: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:25:51======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-16 20:25: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:31:27======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-04-16 20:31: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:31:36======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = jina ========================2018-04-16 20:31: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-16 20:34:01======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2016D8F24C2F6AE4A07A sCDKey = 049554512864 sName = jina ========================2018-04-16 20:34:01======================== 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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0