========================2019-05-08 08:59:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VO5UABL parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 3252974770C9EA99FC33 sCDKey = 827754547202 sName = DESKTOP-VO5UABL ========================2019-05-08 08:59:39======================== 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 = '827754547202' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:03:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VO5UABL parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 3252974770C9EA99FC33 sCDKey = 827754547202 sName = DESKTOP-VO5UABL ========================2019-05-08 09:03:31======================== 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 = '827754547202' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:03:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhw600' ========================2019-05-08 09:03:32======================== SELECT idx FROM macs WHERE mac_addr = '3252974770C9EA99FC33' AND app_code = '039' ========================2019-05-08 09:03:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284923' ========================2019-05-08 09:03:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '284923' ========================2019-05-08 09:03:32======================== UPDATE mac_detail SET pc_name = 'DESKTOP-VO5UABL', os_type = '110', user_id = 'jhw600', user_name = '서진안전[장호원]', screen_w = '1366', screen_h = '768', cdkey = '827754547202' WHERE mac_idx = '284923' ========================2019-05-08 09:50:21======================== noteurl_start parm_app_code = 039 parm_pc_name = PJH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 323959872878 sName = PJH ========================2019-05-08 09:50: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 = '323959872878' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:50:32======================== noteurl_start parm_app_code = 039 parm_pc_name = PJH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 323959872878 sName = PJH ========================2019-05-08 09:50:32======================== 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 = '323959872878' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:51:27======================== noteurl_start parm_app_code = 039 parm_pc_name = PJH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 323959872878 sName = PJH ========================2019-05-08 09:51:27======================== 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 = '323959872878' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:51:34======================== noteurl_start parm_app_code = 039 parm_pc_name = PJH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 323959872878 sName = 박주현 ========================2019-05-08 09:51: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 = '323959872878' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:54:53======================== noteurl_start parm_app_code = 039 parm_pc_name = PJH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 323959872878 sName = PJH ========================2019-05-08 09:54:53======================== 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 = '323959872878' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:56:32======================== noteurl_start parm_app_code = 039 parm_pc_name = PJH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 323959872878 sName = 박주현 ========================2019-05-08 09:56:32======================== 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 = '323959872878' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:58:30======================== noteurl_start parm_app_code = 039 parm_pc_name = PJH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 698320684670 sName = PJH ========================2019-05-08 09:58: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 = '698320684670' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 09:58:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youi92' ========================2019-05-08 09:58:30======================== SELECT idx FROM macs WHERE mac_addr = '7085C2B92617DABAE9EC' AND app_code = '039' ========================2019-05-08 09:58:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282542' ========================2019-05-08 09:58:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282542' ========================2019-05-08 09:58: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 ( '282542', '7085C2B92617DABAE9EC', '039', 'PJH', '110', '1920', '1080', 'youi92', '[박주현]', '698320684670' ) ========================2019-05-08 10:11:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-97F3VO3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = F8A2D666BCB9A5440CB sCDKey = 872903449106 sName = DESKTOP-97F3VO3 ========================2019-05-08 10:11:18======================== 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 = '872903449106' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 10:11:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nmw11055' ========================2019-05-08 10:11:18======================== SELECT idx FROM macs WHERE mac_addr = 'F8A2D666BCB9A5440CB' AND app_code = '039' ========================2019-05-08 10:11:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285375' ========================2019-05-08 10:11:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285375' ========================2019-05-08 10:11:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '285375', 'F8A2D666BCB9A5440CB', '039', 'DESKTOP-97F3VO3', '110', '1366', '768', 'nmw11055', '신한텍스[남만우]', '872903449106' ) ========================2019-05-08 14:39:43======================== noteurl_start parm_app_code = 039 parm_pc_name = LG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8AA74BA4EA730804 sCDKey = 899727976979 sName = LG ========================2019-05-08 14:39: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 = '899727976979' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 14:39:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyi3525590' ========================2019-05-08 14:39:43======================== SELECT idx FROM macs WHERE mac_addr = 'D8CB8AA74BA4EA730804' AND app_code = '039' ========================2019-05-08 14:39:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285399' ========================2019-05-08 14:39:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285399' ========================2019-05-08 14:39:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '285399', 'D8CB8AA74BA4EA730804', '039', 'LG', '110', '1920', '1080', 'kyi3525590', '삼광정밀[김연임]', '899727976979' ) ========================2019-05-08 14:42:24======================== noteurl_start parm_app_code = 039 parm_pc_name = LG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8AA74BA4EA730804 sCDKey = 899727976979 sName = 삼광정밀 ========================2019-05-08 14:42:24======================== 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 = '899727976979' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-08 14:43:46======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2019-05-08 14:43: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-05-08 14:45:50======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2019-05-08 14:45: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-05-08 14:45:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-05-08 14:45:50======================== SELECT idx FROM macs WHERE mac_addr = '98838987DB4ED87CAEF4' AND app_code = '048' ========================2019-05-08 14:45:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268463' ========================2019-05-08 14:45:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268463' ========================2019-05-08 14:45:50======================== UPDATE mac_detail SET pc_name = '김수영', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '268463' ========================2019-05-08 16:36:10======================== noteurl_start parm_app_code = 045 parm_pc_name = DONGMING parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 448A5BF6FCD4945CEED5 sCDKey = 457889227889 sName = DONGMING ========================2019-05-08 16:36:10======================== 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 = '457889227889' AND r.app_code = '045' AND r.app_block = 0 ========================2019-05-08 16:36:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dongming9868' ========================2019-05-08 16:36:10======================== SELECT idx FROM macs WHERE mac_addr = '448A5BF6FCD4945CEED5' AND app_code = '045' ========================2019-05-08 16:36:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221280' ========================2019-05-08 16:36:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '221280' ========================2019-05-08 16:36:10======================== UPDATE mac_detail SET pc_name = 'DONGMING', os_type = '110', user_id = 'dongming9868', user_name = '동명마트[해매란]', screen_w = '1920', screen_h = '1200', cdkey = '457889227889' WHERE mac_idx = '221280'