========================2018-02-05 09:21:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OH9I3SM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E17E58ECC89DBA sCDKey = 998656789380 sName = DESKTOP-OH9I3SM ========================2018-02-05 09:21: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 = '998656789380' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-05 09:21:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyunduk85' ========================2018-02-05 09:21:31======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E17E58ECC89DBA' AND app_code = '039' ========================2018-02-05 09:21:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '234321' ========================2018-02-05 09:21:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '234321' ========================2018-02-05 09:21:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '234321', 'E0D55E17E58ECC89DBA', '039', 'DESKTOP-OH9I3SM', '110', '1920', '1080', 'hyunduk85', '오곡농산[유현덕]', '998656789380' ) ========================2018-02-05 09:29:09======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 003400982708 sName = DESKTOP-RIU7E7C ========================2018-02-05 09:29:09======================== 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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-05 09:29:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chojaeseong' ========================2018-02-05 09:29:10======================== SELECT idx FROM macs WHERE mac_addr = '9883892E09ACAA233C88' AND app_code = '046' ========================2018-02-05 09:29:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198520' ========================2018-02-05 09:29:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198520' ========================2018-02-05 09:29:10======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RIU7E7C', os_type = '110', user_id = 'chojaeseong', user_name = '미소매점[조재성]', screen_w = '1366', screen_h = '768', cdkey = '003400982708' WHERE mac_idx = '198520' ========================2018-02-05 09:32:15======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 003400982708 sName = DESKTOP-RIU7E7C ========================2018-02-05 09:32:15======================== 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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-05 09:32:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chojaeseong' ========================2018-02-05 09:32:15======================== SELECT idx FROM macs WHERE mac_addr = '9883892E09ACAA233C88' AND app_code = '046' ========================2018-02-05 09:32:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198520' ========================2018-02-05 09:32:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198520' ========================2018-02-05 09:32:15======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RIU7E7C', os_type = '110', user_id = 'chojaeseong', user_name = '미소매점[조재성]', screen_w = '1366', screen_h = '768', cdkey = '003400982708' WHERE mac_idx = '198520' ========================2018-02-05 11:00:37======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D74A78D2455570 sCDKey = 081283225905 sName = USER-PC ========================2018-02-05 11:00: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 = '081283225905' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-05 11:00:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dy8259' ========================2018-02-05 11:00:37======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D74A78D2455570' AND app_code = '039' ========================2018-02-05 11:00:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238998' ========================2018-02-05 11:00:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238998' ========================2018-02-05 11:00: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 ( '238998', '1C1B0D74A78D2455570', '039', 'USER-PC', '90', '1920', '1080', 'dy8259', '대연다이스[정성욱]', '081283225905' ) ========================2018-02-05 11:38:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KDP7PBL parm_os_type = 110 parm_screen_w = 1080 parm_screen_h = 1080 parm_user_mac = BCAEC58EEC87FC711C60 sCDKey = 460983226381 sName = DESKTOP-KDP7PBL ========================2018-02-05 11:38:13======================== 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 = '460983226381' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-05 11:38:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'son1130' ========================2018-02-05 11:38:13======================== SELECT idx FROM macs WHERE mac_addr = 'BCAEC58EEC87FC711C60' AND app_code = '039' ========================2018-02-05 11:38:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241283' ========================2018-02-05 11:38:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241283' ========================2018-02-05 11:38:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241283', 'BCAEC58EEC87FC711C60', '039', 'DESKTOP-KDP7PBL', '110', '1080', '1080', 'son1130', '스타정보통신[손현숙]', '460983226381' ) ========================2018-02-05 15:56:38======================== noteurl_start parm_app_code = 048 parm_pc_name = TS2 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C24A68B2FAE08971 sCDKey = 601678917481 sName = TS2 ========================2018-02-05 15:56:38======================== 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 = '601678917481' AND r.app_code = '048' AND r.app_block = 0 ========================2018-02-05 15:56:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ts5ttogi' ========================2018-02-05 15:56:38======================== SELECT idx FROM macs WHERE mac_addr = '7085C24A68B2FAE08971' AND app_code = '048' ========================2018-02-05 15:56:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241403' ========================2018-02-05 15:56:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241403' ========================2018-02-05 15:56:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241403', '7085C24A68B2FAE08971', '048', 'TS2', '�쐢�룄�슦 7', '0', '0', 'ts5ttogi', '(주)태신오뚜기[김건우]', '601678917481' ) ========================2018-02-05 16:15:00======================== noteurl_start parm_app_code = 048 parm_pc_name = TS1 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2523FA3C2B90D66 sCDKey = 601678917481 sName = TS1 ========================2018-02-05 16:15: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 = '601678917481' AND r.app_code = '048' AND r.app_block = 0 ========================2018-02-05 16:15:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ts5ttogi' ========================2018-02-05 16:15:00======================== SELECT idx FROM macs WHERE mac_addr = '7085C2523FA3C2B90D66' AND app_code = '048' ========================2018-02-05 16:15:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241407' ========================2018-02-05 16:15:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241407' ========================2018-02-05 16:15: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 ( '241407', '7085C2523FA3C2B90D66', '048', 'TS1', '�쐢�룄�슦 7', '0', '0', 'ts5ttogi', '(주)태신오뚜기[김건우]', '601678917481' ) ========================2018-02-05 17:51:32======================== noteurl_start parm_app_code = 046 parm_pc_name = PB-VCHJ7HQ0MQTV parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 2025644DE286C0A59A4B sCDKey = 187009624545 sName = PB-VCHJ7HQ0MQTV ========================2018-02-05 17:51: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 = '187009624545' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-05 17:51:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'luckype53' ========================2018-02-05 17:51:32======================== SELECT idx FROM macs WHERE mac_addr = '2025644DE286C0A59A4B' AND app_code = '046' ========================2018-02-05 17:51:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '115306' ========================2018-02-05 17:51:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '115306' ========================2018-02-05 17:51:32======================== UPDATE mac_detail SET pc_name = 'PB-VCHJ7HQ0MQTV', os_type = '64', user_id = 'luckype53', user_name = '(주)럭키펫유통[박영원]', screen_w = '1024', screen_h = '768', cdkey = '187009624545' WHERE mac_idx = '115306'