========================2020-04-14 09:17:40======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-M745LCR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C3AA3E929ABCE94D sCDKey = 637819384413 sName = DESKTOP-M745LCR ========================2020-04-14 09:17: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 = '637819384413' AND r.app_code = '047' AND r.app_block = 0 ========================2020-04-14 09:17:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdsa00' ========================2020-04-14 09:17:41======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AA3E929ABCE94D' AND app_code = '047' ========================2020-04-14 09:17:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315384' ========================2020-04-14 09:17:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315384' ========================2020-04-14 09:17: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 ( '315384', '50B7C3AA3E929ABCE94D', '047', 'DESKTOP-M745LCR', '�쐢�룄�슦 10', '0', '0', 'kdsa00', '정현 공구철물[김정현]', '637819384413' ) ========================2020-04-14 14:19:14======================== noteurl_start parm_app_code = 045 parm_pc_name = OWNER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2C4D54D20F0CFABF05EC sCDKey = 081146859024 sName = OWNER-PC ========================2020-04-14 14:19: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 = '081146859024' AND r.app_code = '045' AND r.app_block = 0 ========================2020-04-14 14:19:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lsshan' ========================2020-04-14 14:19:14======================== SELECT idx FROM macs WHERE mac_addr = '2C4D54D20F0CFABF05EC' AND app_code = '045' ========================2020-04-14 14:19:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313291' ========================2020-04-14 14:19:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313291' ========================2020-04-14 14:19: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 ( '313291', '2C4D54D20F0CFABF05EC', '045', 'OWNER-PC', '90', '1920', '1080', 'lsshan', '으뜸농산(주)[홍필성]', '081146859024' ) ========================2020-04-14 15:08:49======================== noteurl_start parm_app_code = 048 parm_pc_name = SJMRO-01 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA1405C0DAACD42D93 sCDKey = 774081000216 sName = SJMRO-01 ========================2020-04-14 15:08: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 = '774081000216' AND r.app_code = '048' AND r.app_block = 0 ========================2020-04-14 15:08:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjmro' ========================2020-04-14 15:08:49======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA1405C0DAACD42D93' AND app_code = '048' ========================2020-04-14 15:08:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315329' ========================2020-04-14 15:08:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315329' ========================2020-04-14 15:08:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315329', 'FCAA1405C0DAACD42D93', '048', 'SJMRO-01', '�쐢�룄�슦 10', '0', '0', 'sjmro', '서준산업안전[윤현희]', '774081000216' ) ========================2020-04-14 15:08:55======================== noteurl_start parm_app_code = 048 parm_pc_name = SJMRO-01 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA1405C0DAACD42D93 sCDKey = 774081000216 sName = SJMRO-01 ========================2020-04-14 15:08: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 = '774081000216' AND r.app_code = '048' AND r.app_block = 0 ========================2020-04-14 15:09:02======================== noteurl_start parm_app_code = 048 parm_pc_name = SJMRO-01 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA1405C0DAACD42D93 sCDKey = 774081000216 sName = SJMRO-01 ========================2020-04-14 15:09: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 = '774081000216' AND r.app_code = '048' AND r.app_block = 0 ========================2020-04-14 15:20:11======================== noteurl_start parm_app_code = 039 parm_pc_name = KKCOM-200314 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F46D0479D3E9BC66DB04 sCDKey = 893762180601 sName = KKCOM-200314 ========================2020-04-14 15:20: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 = '893762180601' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-14 15:20:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kang3861' ========================2020-04-14 15:20:11======================== SELECT idx FROM macs WHERE mac_addr = 'F46D0479D3E9BC66DB04' AND app_code = '039' ========================2020-04-14 15:20:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313017' ========================2020-04-14 15:20:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313017' ========================2020-04-14 15:20: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 ( '313017', 'F46D0479D3E9BC66DB04', '039', 'KKCOM-200314', '110', '1920', '1080', 'kang3861', '금강방전조각[손현규]', '893762180601' ) ========================2020-04-14 15:50:10======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TSIO1U3 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A4C3F0759B94C43CB1DC sCDKey = 230362309828 sName = 임시포스 ========================2020-04-14 15:50: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 = '230362309828' AND r.app_code = '047' AND r.app_block = 0 ========================2020-04-14 15:50:23======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TSIO1U3 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A4C3F0759B94C43CB1DC sCDKey = 230362309828 sName = 임시포스 ========================2020-04-14 15:50: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 = '230362309828' AND r.app_code = '047' AND r.app_block = 0 ========================2020-04-14 15:50:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jclocal' ========================2020-04-14 15:50:23======================== SELECT idx FROM macs WHERE mac_addr = 'A4C3F0759B94C43CB1DC' AND app_code = '047' ========================2020-04-14 15:50:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307171' ========================2020-04-14 15:50:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '307171' ========================2020-04-14 15:50:23======================== UPDATE mac_detail SET pc_name = '임시포스', os_type = '�쐢�룄�슦 10', user_id = 'jclocal', user_name = '제천로컬푸드협동조합[김현주]', screen_w = '0', screen_h = '0', cdkey = '230362309828' WHERE mac_idx = '307171' ========================2020-04-14 16:35:38======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-LPIT1TKRFGR parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA14D4B4ECFC979DCE sCDKey = 982834938334 sName = WIN-LPIT1TKRFGR ========================2020-04-14 16:35:38======================== 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 = '982834938334' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-14 16:35:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jurapower11' ========================2020-04-14 16:35:38======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14D4B4ECFC979DCE' AND app_code = '039' ========================2020-04-14 16:35:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283495' ========================2020-04-14 16:35:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283495' ========================2020-04-14 16:35:38======================== UPDATE mac_detail SET pc_name = 'WIN-LPIT1TKRFGR', os_type = '110', user_id = 'jurapower11', user_name = '멋지다오피스텔[장승목]', screen_w = '1920', screen_h = '1080', cdkey = '982834938334' WHERE mac_idx = '283495'