========================2018-08-24 09:14:51======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 002197A4ACD5620A388D sCDKey = 570945270094 sName = USER-PC ========================2018-08-24 09:14:51======================== 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 = '570945270094' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-24 09:14:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pws09m' ========================2018-08-24 09:14:51======================== SELECT idx FROM macs WHERE mac_addr = '002197A4ACD5620A388D' AND app_code = '039' ========================2018-08-24 09:14:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258010' ========================2018-08-24 09:14:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258010' ========================2018-08-24 09:14:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '258010', '002197A4ACD5620A388D', '039', 'USER-PC', '90', '1024', '768', 'pws09m', '서울공구[박운성]', '570945270094' ) ========================2018-08-24 10:29:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BL67K4U parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 705A0F92E108A4A36B00 sCDKey = 076199019040 sName = DESKTOP-BL67K4U ========================2018-08-24 10:29:46======================== 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 = '076199019040' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-24 10:29:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kt100722' ========================2018-08-24 10:29:46======================== SELECT idx FROM macs WHERE mac_addr = '705A0F92E108A4A36B00' AND app_code = '039' ========================2018-08-24 10:29:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '183207' ========================2018-08-24 10:29:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '183207' ========================2018-08-24 10:29:46======================== UPDATE mac_detail SET pc_name = 'DESKTOP-BL67K4U', os_type = '110', user_id = 'kt100722', user_name = '금탑주차장[김형석]', screen_w = '1600', screen_h = '900', cdkey = '076199019040' WHERE mac_idx = '183207' ========================2018-08-24 11:07:42======================== noteurl_start parm_app_code = 046 parm_pc_name = WINION3 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B3415A3A4C660734 sCDKey = 154716655259 sName = ========================2018-08-24 11:07:42======================== 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 = '154716655259' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-24 11:07:51======================== noteurl_start parm_app_code = 046 parm_pc_name = WINION3 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B3415A3A4C660734 sCDKey = 154716655259 sName = WINION ========================2018-08-24 11:07:51======================== 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 = '154716655259' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-24 11:07:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'winion' ========================2018-08-24 11:07:51======================== SELECT idx FROM macs WHERE mac_addr = '902B3415A3A4C660734' AND app_code = '046' ========================2018-08-24 11:07:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '206033' ========================2018-08-24 11:07:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '206033' ========================2018-08-24 11:07:51======================== UPDATE mac_detail SET pc_name = 'WINION', os_type = '90', user_id = 'winion', user_name = '(주)위니온[이동섭]', screen_w = '1920', screen_h = '1080', cdkey = '154716655259' WHERE mac_idx = '206033' ========================2018-08-24 13:33:14======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-CTRF0S9 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3497F67DA3196837973E sCDKey = 304737735505 sName = DESKTOP-CTRF0S9 ========================2018-08-24 13:33: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 = '304737735505' AND r.app_code = '051' AND r.app_block = 0 ========================2018-08-24 13:34:40======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-CTRF0S9 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3497F67DA3196837973E sCDKey = 304737735505 sName = DESKTOP-CTRF0S9 ========================2018-08-24 13:34:40======================== 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 ========================2018-08-24 13:34:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daeho5400' ========================2018-08-24 13:34:40======================== SELECT idx FROM macs WHERE mac_addr = '3497F67DA3196837973E' AND app_code = '051' ========================2018-08-24 13:34:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258040' ========================2018-08-24 13:34:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258040' ========================2018-08-24 13:34:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '258040', '3497F67DA3196837973E', '051', 'DESKTOP-CTRF0S9', '109', '1920', '1080', 'daeho5400', '(주)대호아이앤티[배혜진]', '304737735505' )