========================2019-08-05 10:03:56======================== noteurl_start parm_app_code = 046 parm_pc_name = A02-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 1024 parm_user_mac = D8CB8A3ADF283AF6C411 sCDKey = 369853832250 sName = A02-PC ========================2019-08-05 10:03:56======================== 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 = '369853832250' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-05 10:03:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gijang09' ========================2019-08-05 10:03:56======================== SELECT idx FROM macs WHERE mac_addr = 'D8CB8A3ADF283AF6C411' AND app_code = '046' ========================2019-08-05 10:03:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '246644' ========================2019-08-05 10:03:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '246644' ========================2019-08-05 10:03:56======================== UPDATE mac_detail SET pc_name = 'A02-PC', os_type = '90', user_id = 'gijang09', user_name = '기장종합공구[신성진]', screen_w = '1024', screen_h = '1024', cdkey = '369853832250' WHERE mac_idx = '246644' ========================2019-08-05 13:46:22======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E549B3C26A5E486CD2 sCDKey = 466597956979 sName = 비스텔 ========================2019-08-05 13:46: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 = '466597956979' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-05 13:46:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksl22' ========================2019-08-05 13:46:22======================== SELECT idx FROM macs WHERE mac_addr = '50E549B3C26A5E486CD2' AND app_code = '050' ========================2019-08-05 13:46:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292424' ========================2019-08-05 13:46:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292424' ========================2019-08-05 13:46: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 ( '292424', '50E549B3C26A5E486CD2', '050', '비스텔', '109', '1920', '1080', 'ksl22', '비스텔[이권수]', '466597956979' ) ========================2019-08-05 14:42:00======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 8C89A57E8E90D04A1424 sCDKey = 658677376048 sName = WIN-PC ========================2019-08-05 14:42:00======================== 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 = '658677376048' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-05 14:42:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hana4067' ========================2019-08-05 14:42:00======================== SELECT idx FROM macs WHERE mac_addr = '8C89A57E8E90D04A1424' AND app_code = '039' ========================2019-08-05 14:42:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292436' ========================2019-08-05 14:42:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292436' ========================2019-08-05 14:42:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292436', '8C89A57E8E90D04A1424', '039', 'WIN-PC', '90', '1680', '1050', 'hana4067', '하나조명[김근영]', '658677376048' ) ========================2019-08-05 15:12:37======================== noteurl_start parm_app_code = 039 parm_pc_name = 박승호-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F832E4BD2519520180EA sCDKey = 264340964291 sName = 박승호-PC ========================2019-08-05 15:12: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 = '264340964291' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-05 15:12:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lengxin' ========================2019-08-05 15:12:37======================== SELECT idx FROM macs WHERE mac_addr = 'F832E4BD2519520180EA' AND app_code = '039' ========================2019-08-05 15:12:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292441' ========================2019-08-05 15:12:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292441' ========================2019-08-05 15:12: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 ( '292441', 'F832E4BD2519520180EA', '039', '박승호-PC', '90', '1920', '1080', 'lengxin', '천장지구[최성호]', '264340964291' ) ========================2019-08-05 15:39:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-543HB16 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E840F2574214167F19E2 sCDKey = 700099590579 sName = DESKTOP-543HB16 ========================2019-08-05 15:39: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 = '700099590579' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-05 15:39:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhss0011' ========================2019-08-05 15:39:16======================== SELECT idx FROM macs WHERE mac_addr = 'E840F2574214167F19E2' AND app_code = '039' ========================2019-08-05 15:39:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292444' ========================2019-08-05 15:39:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292444' ========================2019-08-05 15:39:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292444', 'E840F2574214167F19E2', '039', 'DESKTOP-543HB16', '110', '1920', '1080', 'jhss0011', '영진타일[지희섭]', '700099590579' ) ========================2019-08-05 17:37:34======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4DE4F438632F18F sCDKey = 375489053204 sName = USER-PC ========================2019-08-05 17:37:34======================== 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 = '375489053204' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-05 17:37:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'myungsin2841' ========================2019-08-05 17:37:34======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DE4F438632F18F' AND app_code = '046' ========================2019-08-05 17:37:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292467' ========================2019-08-05 17:37:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292467' ========================2019-08-05 17:37:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292467', 'BC5FF4DE4F438632F18F', '046', 'USER-PC', '90', '1024', '768', 'myungsin2841', '명신종합상사[한순옥]', '375489053204' )