========================2020-03-19 08:41: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-19 08:41: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-19 08:41:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-03-19 08:41:28======================== SELECT idx FROM macs WHERE mac_addr = '803253F4639D6DBC9E9' AND app_code = '046' ========================2020-03-19 08:41:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312854' ========================2020-03-19 08:41:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312854' ========================2020-03-19 08:41:28======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GO8STMH', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]', screen_w = '1920', screen_h = '1080', cdkey = '342918991698' WHERE mac_idx = '312854' ========================2020-03-19 12:00:02======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAC280CDC26917D0 sCDKey = 002990426440 sName = MSDN-SPECIAL ========================2020-03-19 12:00: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 = '002990426440' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-19 12:00:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'houngsek123' ========================2020-03-19 12:00:02======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAC280CDC26917D0' AND app_code = '039' ========================2020-03-19 12:00:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313355' ========================2020-03-19 12:00:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313355' ========================2020-03-19 12:00:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313355', '24F5AAC280CDC26917D0', '039', 'MSDN-SPECIAL', '90', '1920', '1080', 'houngsek123', '신의정밀[홍성원]', '002990426440' ) ========================2020-03-19 13:20:49======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-FINIR04 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E06995C150A5C85748BF sCDKey = 304737735505 sName = DESKTOP-FINIR04 ========================2020-03-19 13:20: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 = '304737735505' AND r.app_code = '051' AND r.app_block = 0 ========================2020-03-19 13:20:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daeho5400' ========================2020-03-19 13:20:49======================== SELECT idx FROM macs WHERE mac_addr = 'E06995C150A5C85748BF' AND app_code = '051' ========================2020-03-19 13:20:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280917' ========================2020-03-19 13:20:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280917' ========================2020-03-19 13:20:49======================== UPDATE mac_detail SET pc_name = 'DESKTOP-FINIR04', os_type = '109', user_id = 'daeho5400', user_name = '(주)대호아이앤티[배혜진]', screen_w = '1920', screen_h = '1080', cdkey = '304737735505' WHERE mac_idx = '280917' ========================2020-03-19 13:29:20======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-EIQN3SK parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = AA2019032A087A5048E7 sCDKey = 304737735505 sName = DESKTOP-EIQN3SK ========================2020-03-19 13:29: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 = '304737735505' AND r.app_code = '051' AND r.app_block = 0 ========================2020-03-19 13:29:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daeho5400' ========================2020-03-19 13:29:20======================== SELECT idx FROM macs WHERE mac_addr = 'AA2019032A087A5048E7' AND app_code = '051' ========================2020-03-19 13:29:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313363' ========================2020-03-19 13:29:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313363' ========================2020-03-19 13:29:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313363', 'AA2019032A087A5048E7', '051', 'DESKTOP-EIQN3SK', '109', '1920', '1080', 'daeho5400', '(주)대호아이앤티[배혜진]', '304737735505' ) ========================2020-03-19 16:24:54======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-RJSNNEJ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F441D832736A sCDKey = 216827838320 sName = DESKTOP-RJSNNEJ ========================2020-03-19 16:24: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 = '216827838320' AND r.app_code = '050' AND r.app_block = 0 ========================2020-03-19 16:32:41======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-7CBVMGK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E995D336F9EE9D284 sCDKey = 270965864323 sName = DESKTOP-7CBVMGK ========================2020-03-19 16:32: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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-19 16:32:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2020-03-19 16:32:42======================== SELECT idx FROM macs WHERE mac_addr = 'B42E995D336F9EE9D284' AND app_code = '046' ========================2020-03-19 16:32:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313388' ========================2020-03-19 16:32:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313388' ========================2020-03-19 16:32:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313388', 'B42E995D336F9EE9D284', '046', 'DESKTOP-7CBVMGK', '110', '1920', '1080', 'kyr0909', '동양종합식품[김영록]', '270965864323' ) ========================2020-03-19 16:42:14======================== noteurl_start parm_app_code = 050 parm_pc_name = 경영지원부 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9E6B7DD263119C sCDKey = 216827838320 sName = 경영지원부 ========================2020-03-19 16:42: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 = '216827838320' AND r.app_code = '050' AND r.app_block = 0 ========================2020-03-19 16:46:15======================== noteurl_start parm_app_code = 050 parm_pc_name = 경영지원부 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB9E6B7DD263119C sCDKey = 216827838320 sName = 경영지원부 ========================2020-03-19 16:46: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 = '216827838320' AND r.app_code = '050' AND r.app_block = 0 ========================2020-03-19 16:46:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ledas8275' ========================2020-03-19 16:46:15======================== SELECT idx FROM macs WHERE mac_addr = '6045CB9E6B7DD263119C' AND app_code = '050' ========================2020-03-19 16:46:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281055' ========================2020-03-19 16:46:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281055' ========================2020-03-19 16:46:15======================== UPDATE mac_detail SET pc_name = '경영지원부', os_type = '109', user_id = 'ledas8275', user_name = '김병준레다스흉부외과[김병준]', screen_w = '1920', screen_h = '1080', cdkey = '216827838320' WHERE mac_idx = '281055' ========================2020-03-19 17:36:22======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6OEDNGF parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 982CBCC5BC55F03C717D sCDKey = 151317336230 sName = DESKTOP-6OEDNGF ========================2020-03-19 17:36: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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-19 17:37:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6OEDNGF parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 982CBCC5BC55F03C717D sCDKey = 151317336230 sName = DESKTOP-6OEDNGF ========================2020-03-19 17:37: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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-19 17:37:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yessal' ========================2020-03-19 17:37:24======================== SELECT idx FROM macs WHERE mac_addr = '982CBCC5BC55F03C717D' AND app_code = '039' ========================2020-03-19 17:37:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313393' ========================2020-03-19 17:37:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313393' ========================2020-03-19 17:37:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313393', '982CBCC5BC55F03C717D', '039', 'DESKTOP-6OEDNGF', '110', '1536', '864', 'yessal', '제이에스테크[심재섭]', '151317336230' )