========================2018-03-19 09:28:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10604B89FF26E84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-03-19 09:28:47======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-19 09:28:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xtn9m7' ========================2018-03-19 09:28:47======================== SELECT idx FROM macs WHERE mac_addr = '10604B89FF26E84D1B13' AND app_code = '039' ========================2018-03-19 09:28:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244725' ========================2018-03-19 09:28:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244725' ========================2018-03-19 09:28:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244725', '10604B89FF26E84D1B13', '039', 'DONGYANG', '110', '1920', '1080', 'xtn9m7', '동양철물공구[최철호]', '874062384374' ) ========================2018-03-19 09:29:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DONGYANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10604B89FF26E84D1B13 sCDKey = 874062384374 sName = DONGYANG ========================2018-03-19 09:29:03======================== 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 = '874062384374' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-19 14:21:59======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 1200 parm_user_mac = 485B3935D0BC86ED57A5 sCDKey = 945303690342 sName = USER-PC ========================2018-03-19 14:21: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 = '945303690342' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-19 14:21:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dhhwang71' ========================2018-03-19 14:21:59======================== SELECT idx FROM macs WHERE mac_addr = '485B3935D0BC86ED57A5' AND app_code = '039' ========================2018-03-19 14:21:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '159134' ========================2018-03-19 14:21:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '159134' ========================2018-03-19 14:21:59======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'dhhwang71', user_name = '내쇼날플라스틱 엔피씨[황대홍]', screen_w = '1600', screen_h = '1200', cdkey = '945303690342' WHERE mac_idx = '159134' ========================2018-03-19 14:22:22======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = B886876AD027C6F39819 sCDKey = 945303690342 sName = USER ========================2018-03-19 14:22: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 = '945303690342' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-19 14:22:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dhhwang71' ========================2018-03-19 14:22:22======================== SELECT idx FROM macs WHERE mac_addr = 'B886876AD027C6F39819' AND app_code = '039' ========================2018-03-19 14:22:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244878' ========================2018-03-19 14:22:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244878' ========================2018-03-19 14:22: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 ( '244878', 'B886876AD027C6F39819', '039', 'USER', '110', '1366', '768', 'dhhwang71', '내쇼날플라스틱 엔피씨[황대홍]', '945303690342' ) ========================2018-03-19 14:22:28======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = B886876AD027C6F39819 sCDKey = 945303690342 sName = USER ========================2018-03-19 14:22: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 = '945303690342' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-19 16:35:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L3RU2QK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C69130673E3CB096DF sCDKey = 338265970166 sName = DESKTOP-L3RU2QK ========================2018-03-19 16:35:45======================== 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 = '338265970166' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-19 16:35:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bonjovi8970' ========================2018-03-19 16:35:45======================== SELECT idx FROM macs WHERE mac_addr = '94C69130673E3CB096DF' AND app_code = '039' ========================2018-03-19 16:35:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244898' ========================2018-03-19 16:35:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244898' ========================2018-03-19 16:35:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244898', '94C69130673E3CB096DF', '039', 'DESKTOP-L3RU2QK', '110', '1920', '1080', 'bonjovi8970', '(주)천지테크[손창희]', '338265970166' ) ========================2018-03-19 16:35:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L3RU2QK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C69130673E3CB096DF sCDKey = 338265970166 sName = DESKTOP-L3RU2QK ========================2018-03-19 16:35:52======================== 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 = '338265970166' AND r.app_code = '039' AND r.app_block = 0