========================2019-05-24 09:37:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FC3O7PH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897A4EE812A3E273 sCDKey = 428662420564 sName = DESKTOP-FC3O7PH ========================2019-05-24 09:37: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 = '428662420564' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-24 09:37:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ys9270' ========================2019-05-24 09:37:41======================== SELECT idx FROM macs WHERE mac_addr = '9883897A4EE812A3E273' AND app_code = '039' ========================2019-05-24 09:37:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '197355' ========================2019-05-24 09:37:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '197355' ========================2019-05-24 09:37:41======================== UPDATE mac_detail SET pc_name = 'DESKTOP-FC3O7PH', os_type = '110', user_id = 'ys9270', user_name = '영상케미칼[김영상]', screen_w = '1920', screen_h = '1080', cdkey = '428662420564' WHERE mac_idx = '197355' ========================2019-05-24 09:37:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FC3O7PH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897A4EE812A3E273 sCDKey = 428662420564 sName = DESKTOP-FC3O7PH ========================2019-05-24 09:37:44======================== 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 = '428662420564' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-24 10:06:02======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = F44D30B9B79B345CC662 sCDKey = 210742859361 sName = ========================2019-05-24 10:06: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-24 10:06:07======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = F44D30B9B79B345CC662 sCDKey = 210742859361 sName = 11 ========================2019-05-24 10:06: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 ========================2019-05-24 10:09:15======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL1 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D02788078402984E2974 sCDKey = 210742859361 sName = MSDN-SPECIAL1 ========================2019-05-24 10:09: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-24 10:09:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2019-05-24 10:09:15======================== SELECT idx FROM macs WHERE mac_addr = 'D02788078402984E2974' AND app_code = '039' ========================2019-05-24 10:09:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198515' ========================2019-05-24 10:09:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198515' ========================2019-05-24 10:09:15======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL1', os_type = '90', user_id = 'julee37', user_name = '개성자바라, 스텐나라[이순녀]', screen_w = '1680', screen_h = '1050', cdkey = '210742859361' WHERE mac_idx = '198515' ========================2019-05-24 10:09:21======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL1 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D02788078402984E2974 sCDKey = 210742859361 sName = MSDN-SPECIAL1 ========================2019-05-24 10:09:21======================== 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 ========================2019-05-24 10:14:44======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245496E1ABA8BABE9E sCDKey = 300997963610 sName = USER-PC ========================2019-05-24 10:14:44======================== 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 = '300997963610' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-24 10:14:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'leekg6318' ========================2019-05-24 10:14:44======================== SELECT idx FROM macs WHERE mac_addr = '00245496E1ABA8BABE9E' AND app_code = '039' ========================2019-05-24 10:14:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '219542' ========================2019-05-24 10:14:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '219542' ========================2019-05-24 10:14:44======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'leekg6318', user_name = '금강카센타[이종운]', screen_w = '1920', screen_h = '1080', cdkey = '300997963610' WHERE mac_idx = '219542' ========================2019-05-24 17:08:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2U5R1F0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 606C666FBE86B43943DF sCDKey = mjsof2019052 sName = DESKTOP-2U5R1F0 ========================2019-05-24 17:08: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 = 'MJSOF2019052' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-24 17:15:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2U5R1F0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 606C666FBE86B43943DF sCDKey = 872049568283 sName = DESKTOP-2U5R1F0 ========================2019-05-24 17: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 = '872049568283' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-24 17:15:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dabot' ========================2019-05-24 17:15:19======================== SELECT idx FROM macs WHERE mac_addr = '606C666FBE86B43943DF' AND app_code = '039' ========================2019-05-24 17:15:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284640' ========================2019-05-24 17:15:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '284640' ========================2019-05-24 17:15:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '284640', '606C666FBE86B43943DF', '039', 'DESKTOP-2U5R1F0', '110', '1536', '864', 'dabot', 'DABOT 다봇[송인표]', '872049568283' ) ========================2019-05-24 19:19:22======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN7-01 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C790D5A626CE3E9 sCDKey = 222859365472 sName = WIN7-01 ========================2019-05-24 19:19: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 = '222859365472' AND r.app_code = '046' AND r.app_block = 0