========================2019-09-27 06:39:07======================== noteurl_start parm_app_code = 048 parm_pc_name = 1F1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883898745E7D87CAEF4 sCDKey = 434133617514 sName = 1F1 ========================2019-09-27 06:39:07======================== 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-09-27 06:39:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-09-27 06:39:07======================== SELECT idx FROM macs WHERE mac_addr = '9883898745E7D87CAEF4' AND app_code = '048' ========================2019-09-27 06:39:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266763' ========================2019-09-27 06:39:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266763' ========================2019-09-27 06:39:07======================== UPDATE mac_detail SET pc_name = '1F1', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '266763' ========================2019-09-27 09:11:55======================== noteurl_start parm_app_code = 039 parm_pc_name = O-PC parm_os_type = 90 parm_screen_w = 1080 parm_screen_h = 1920 parm_user_mac = 7085C23AE2631E171EB2 sCDKey = 606997096553 sName = O-PC ========================2019-09-27 09:11:55======================== 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 = '606997096553' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-27 09:11:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pl7204' ========================2019-09-27 09:11:55======================== SELECT idx FROM macs WHERE mac_addr = '7085C23AE2631E171EB2' AND app_code = '039' ========================2019-09-27 09:11:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298542' ========================2019-09-27 09:11:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298542' ========================2019-09-27 09:11:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298542', '7085C23AE2631E171EB2', '039', 'O-PC', '90', '1080', '1920', 'pl7204', '주식회사피엘[정필]', '606997096553' ) ========================2019-09-27 09:58:33======================== noteurl_start parm_app_code = 045 parm_pc_name = AWN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1078D23DC69826322BE9 sCDKey = 081146859024 sName = AWN-PC ========================2019-09-27 09:58:33======================== 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 = '081146859024' AND r.app_code = '045' AND r.app_block = 0 ========================2019-09-27 09:58:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lsshan' ========================2019-09-27 09:58:33======================== SELECT idx FROM macs WHERE mac_addr = '1078D23DC69826322BE9' AND app_code = '045' ========================2019-09-27 09:58:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298549' ========================2019-09-27 09:58:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298549' ========================2019-09-27 09:58:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298549', '1078D23DC69826322BE9', '045', 'AWN-PC', '90', '1920', '1080', 'lsshan', '으뜸농산(주)[홍필성]', '081146859024' ) ========================2019-09-27 10:57:54======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-PI2TB7MN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 4E49205241534A31507D sCDKey = 115259231493 sName = LAPTOP-PI2TB7MN ========================2019-09-27 10:57:54======================== 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 = '115259231493' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-27 10:57:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'esmed' ========================2019-09-27 10:57:54======================== SELECT idx FROM macs WHERE mac_addr = '4E49205241534A31507D' AND app_code = '039' ========================2019-09-27 10:57:54======================== 값이 없을 경우 ========================2019-09-27 10:59:26======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-PI2TB7MN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 4E49205241534A31507D sCDKey = 115259231493 sName = LAPTOP-PI2TB7MN ========================2019-09-27 10:59: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 = '115259231493' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-27 10:59:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'esmed' ========================2019-09-27 10:59:26======================== SELECT idx FROM macs WHERE mac_addr = '4E49205241534A31507D' AND app_code = '039' ========================2019-09-27 10:59:26======================== 값이 없을 경우 ========================2019-09-27 11:06:11======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-PI2TB7MN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 988389484F1D4A31507D sCDKey = 115259231493 sName = LAPTOP-PI2TB7MN ========================2019-09-27 11:06: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 = '115259231493' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-27 11:06:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'esmed' ========================2019-09-27 11:06:11======================== SELECT idx FROM macs WHERE mac_addr = '988389484F1D4A31507D' AND app_code = '039' ========================2019-09-27 11:06:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '295748' ========================2019-09-27 11:06:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '295748' ========================2019-09-27 11:06: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 ( '295748', '988389484F1D4A31507D', '039', 'LAPTOP-PI2TB7MN', '110', '1536', '864', 'esmed', '은성메디케어[임상훈]', '115259231493' ) ========================2019-09-27 11:43:03======================== noteurl_start parm_app_code = 048 parm_pc_name = 2F4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DD975AFC12F463 sCDKey = 434133617514 sName = 2F4 ========================2019-09-27 11:43: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-09-27 11:43:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-09-27 11:43:03======================== SELECT idx FROM macs WHERE mac_addr = '988389DD975AFC12F463' AND app_code = '048' ========================2019-09-27 11:43:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298571' ========================2019-09-27 11:43:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298571' ========================2019-09-27 11:43:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298571', '988389DD975AFC12F463', '048', '2F4', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2019-09-27 13:28:42======================== noteurl_start parm_app_code = 039 parm_pc_name = TAE parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 74D4352B0E7C16FDCF61 sCDKey = 320550890604 sName = TAE ========================2019-09-27 13:28: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 = '320550890604' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-27 13:28:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jwon' ========================2019-09-27 13:28:42======================== SELECT idx FROM macs WHERE mac_addr = '74D4352B0E7C16FDCF61' AND app_code = '039' ========================2019-09-27 13:28:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298575' ========================2019-09-27 13:28:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298575' ========================2019-09-27 13:28:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298575', '74D4352B0E7C16FDCF61', '039', 'TAE', '90', '1600', '900', 'jwon', '제이원[태재원]', '320550890604' ) ========================2019-09-27 13:35:45======================== noteurl_start parm_app_code = 039 parm_pc_name = OH parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E991F689EB07FAFCF sCDKey = 363567601870 sName = OH ========================2019-09-27 13: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 = '363567601870' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-27 13:35:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jscover' ========================2019-09-27 13:35:45======================== SELECT idx FROM macs WHERE mac_addr = 'B42E991F689EB07FAFCF' AND app_code = '039' ========================2019-09-27 13:35:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273641' ========================2019-09-27 13:35:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273641' ========================2019-09-27 13:35:45======================== UPDATE mac_detail SET pc_name = 'OH', os_type = '90', user_id = 'jscover', user_name = '제이에스[오윤정]', screen_w = '1920', screen_h = '1080', cdkey = '363567601870' WHERE mac_idx = '273641' ========================2019-09-27 15:23:25======================== noteurl_start parm_app_code = 039 parm_pc_name = KD84 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C7BEFACE19890882BC1 sCDKey = 708322585128 sName = KD84 ========================2019-09-27 15:23:25======================== 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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-27 15:23:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2019-09-27 15:23:25======================== SELECT idx FROM macs WHERE mac_addr = '9C7BEFACE19890882BC1' AND app_code = '039' ========================2019-09-27 15:23:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298597' ========================2019-09-27 15:23:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298597' ========================2019-09-27 15:23:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298597', '9C7BEFACE19890882BC1', '039', 'KD84', '110', '1920', '1080', 'ramades77', '(주)비엠아이[이동훈]', '708322585128' ) ========================2019-09-27 15:57:10======================== noteurl_start parm_app_code = 039 parm_pc_name = MOT6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 705A0F3B415DFE5C1FBB sCDKey = 146845660413 sName = MOT6 ========================2019-09-27 15:57: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 = '146845660413' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-27 15:57:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kd4052' ========================2019-09-27 15:57:10======================== SELECT idx FROM macs WHERE mac_addr = '705A0F3B415DFE5C1FBB' AND app_code = '039' ========================2019-09-27 15:57:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298611' ========================2019-09-27 15:57:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298611' ========================2019-09-27 15:57:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298611', '705A0F3B415DFE5C1FBB', '039', 'MOT6', '110', '1920', '1080', 'kd4052', '극동타이어[정막래]', '146845660413' ) ========================2019-09-27 17:45:28======================== noteurl_start parm_app_code = 047 parm_pc_name = MYOFFICE003-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 0025225F98B574A283F0 sCDKey = 659998283192 sName = MYOFFICE003-PC ========================2019-09-27 17:45: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 = '659998283192' AND r.app_code = '047' AND r.app_block = 0 ========================2019-09-27 17:45:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sus5200' ========================2019-09-27 17:45:28======================== SELECT idx FROM macs WHERE mac_addr = '0025225F98B574A283F0' AND app_code = '047' ========================2019-09-27 17:45:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294228' ========================2019-09-27 17:45:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294228' ========================2019-09-27 17:45:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '294228', '0025225F98B574A283F0', '047', 'MYOFFICE003-PC', '�쐢�룄�슦 7', '0', '0', 'sus5200', '서울산철물건축자재[노현영]', '659998283192' ) ========================2019-09-27 18:02:44======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-서나리 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BFB8868CCCF82CC8 sCDKey = 659998283192 sName = DESKTOP-서나리 ========================2019-09-27 18:02:44======================== 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 = '659998283192' AND r.app_code = '047' AND r.app_block = 0 ========================2019-09-27 18:02:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sus5200' ========================2019-09-27 18:02:44======================== SELECT idx FROM macs WHERE mac_addr = '1831BFB8868CCCF82CC8' AND app_code = '047' ========================2019-09-27 18:02:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298636' ========================2019-09-27 18:02:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298636' ========================2019-09-27 18:02:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298636', '1831BFB8868CCCF82CC8', '047', 'DESKTOP-서나리', '�쐢�룄�슦 10', '0', '0', 'sus5200', '서울산철물건축자재[노현영]', '659998283192' )