========================2018-02-13 11:08:50======================== noteurl_start parm_app_code = 046 parm_pc_name = EO6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389833FF1DAB017AA sCDKey = 735832194513 sName = EO6 ========================2018-02-13 11:08: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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-13 11:12:08======================== noteurl_start parm_app_code = 046 parm_pc_name = EO6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389833FF1DAB017AA sCDKey = 735832194513 sName = EO6 ========================2018-02-13 11:12:08======================== 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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-13 11:12:16======================== noteurl_start parm_app_code = 046 parm_pc_name = EO6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389833FF1DAB017AA sCDKey = 735832194513 sName = ========================2018-02-13 11:12:16======================== 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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-13 11:12:30======================== noteurl_start parm_app_code = 046 parm_pc_name = EO6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389833FF1DAB017AA sCDKey = 735832194513 sName = eo1 ========================2018-02-13 11:12:30======================== 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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-13 13:09:20======================== 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 = D43D7EEA51D5F6427687 sCDKey = 114729872675 sName = MSDN-SPECIAL ========================2018-02-13 13:09: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 = '114729872675' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-13 13:09:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'miga3321' ========================2018-02-13 13:09:20======================== SELECT idx FROM macs WHERE mac_addr = 'D43D7EEA51D5F6427687' AND app_code = '039' ========================2018-02-13 13:09:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '127550' ========================2018-02-13 13:09:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '127550' ========================2018-02-13 13:09:20======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'miga3321', user_name = '미가특수[김현주]', screen_w = '1920', screen_h = '1080', cdkey = '114729872675' WHERE mac_idx = '127550' ========================2018-02-13 14:18:59======================== 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 = D43D7EEA51D5CC80C8F6 sCDKey = 114729872675 sName = USER-PC ========================2018-02-13 14:18:59======================== 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 = '114729872675' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-13 14:19:16======================== 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 = D43D7EEA51D5CC80C8F6 sCDKey = 114729872675 sName = USER-PC ========================2018-02-13 14:19:16======================== 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 = '114729872675' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-13 14:20:37======================== 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 = D43D7EEA51D5CC80C8F6 sCDKey = 114729872675 sName = USER-PC ========================2018-02-13 14:20:37======================== 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 = '114729872675' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-13 14:20:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'miga3321' ========================2018-02-13 14:20:37======================== SELECT idx FROM macs WHERE mac_addr = 'D43D7EEA51D5CC80C8F6' AND app_code = '039' ========================2018-02-13 14:20:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242092' ========================2018-02-13 14:20:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242092' ========================2018-02-13 14:20:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '242092', 'D43D7EEA51D5CC80C8F6', '039', 'USER-PC', '90', '1920', '1080', 'miga3321', '미가특수[김현주]', '114729872675' ) ========================2018-02-13 14:46:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 48D224233E24D0464AB1 sCDKey = 455850962112 sName = DONG ========================2018-02-13 14:46:26======================== 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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-13 14:46:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dh3162693' ========================2018-02-13 14:46:26======================== SELECT idx FROM macs WHERE mac_addr = '48D224233E24D0464AB1' AND app_code = '039' ========================2018-02-13 14:46:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '182140' ========================2018-02-13 14:46:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '182140' ========================2018-02-13 14:46:26======================== UPDATE mac_detail SET pc_name = 'DONG', os_type = '110', user_id = 'dh3162693', user_name = '동한상사[이광호]', screen_w = '1600', screen_h = '900', cdkey = '455850962112' WHERE mac_idx = '182140' ========================2018-02-13 15:15:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG-2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389819606683DDA55 sCDKey = 455850962112 sName = DONG-2 ========================2018-02-13 15:15:30======================== 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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-13 15:15:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dh3162693' ========================2018-02-13 15:15:30======================== SELECT idx FROM macs WHERE mac_addr = '988389819606683DDA55' AND app_code = '039' ========================2018-02-13 15:15:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242096' ========================2018-02-13 15:15:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242096' ========================2018-02-13 15:15:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '242096', '988389819606683DDA55', '039', 'DONG-2', '110', '1920', '1080', 'dh3162693', '동한상사[이광호]', '455850962112' ) ========================2018-02-13 16:27:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DFR897B parm_os_type = 110 parm_screen_w = 1344 parm_screen_h = 840 parm_user_mac = E0D55E553593C611B4B6 sCDKey = 564526433761 sName = DESKTOP-DFR897B ========================2018-02-13 16:27: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 = '564526433761' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-13 16:27:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jso2979' ========================2018-02-13 16:27:11======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E553593C611B4B6' AND app_code = '039' ========================2018-02-13 16:27:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242103' ========================2018-02-13 16:27:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242103' ========================2018-02-13 16:27: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 ( '242103', 'E0D55E553593C611B4B6', '039', 'DESKTOP-DFR897B', '110', '1344', '840', 'jso2979', '한양전기기계[조성오]', '564526433761' )