========================2020-02-19 08:08:18======================== noteurl_start parm_app_code = 039 parm_pc_name = MASTER-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C7EA822AE5190BF sCDKey = 133446984566 sName = MASTER-PC ========================2020-02-19 08:08: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 = '133446984566' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 10:23:51======================== noteurl_start parm_app_code = 050 parm_pc_name = MIS-S parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C8D9D20D5076AC8AAFD1 sCDKey = 761527002848 sName = MIS-S ========================2020-02-19 10:23: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 = '761527002848' AND r.app_code = '050' AND r.app_block = 0 ========================2020-02-19 10:23:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2008' ========================2020-02-19 10:23:51======================== SELECT idx FROM macs WHERE mac_addr = 'C8D9D20D5076AC8AAFD1' AND app_code = '050' ========================2020-02-19 10:23:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311049' ========================2020-02-19 10:23:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311049' ========================2020-02-19 10:23: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 ( '311049', 'C8D9D20D5076AC8AAFD1', '050', 'MIS-S', '109', '1920', '1080', 'blc2008', '(주)S-Tech[(주)S-Tech]', '761527002848' ) ========================2020-02-19 10:40:43======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CC889D4606A1360 sCDKey = 106222712797 sName = 채해식 ========================2020-02-19 10:40: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 = '106222712797' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 10:40:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dsun8923' ========================2020-02-19 10:40:43======================== SELECT idx FROM macs WHERE mac_addr = '408D5CC889D4606A1360' AND app_code = '039' ========================2020-02-19 10:40:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311051' ========================2020-02-19 10:40:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311051' ========================2020-02-19 10:40: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 ( '311051', '408D5CC889D4606A1360', '039', '채해식', '110', '1920', '1080', 'dsun8923', '(자)대선환경[채해식]', '106222712797' ) ========================2020-02-19 10:59:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740829 sName = DESKTOP-A35H22C ========================2020-02-19 10:59: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 = '658491740829' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 10:59:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740829 sName = DESKTOP-A35H22C ========================2020-02-19 10:59: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 = '658491740829' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 11:00:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740829 sName = DESKTOP-A35H22C ========================2020-02-19 11:00: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 = '658491740829' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 11:00:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740829 sName = DESKTOP-A35H22C ========================2020-02-19 11:00: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 = '658491740829' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 11:00:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740829 sName = DESKTOP-A35H22C ========================2020-02-19 11:00: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 = '658491740829' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 11:01:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740829 sName = DESKTOP-A35H22C ========================2020-02-19 11:01:08======================== 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 = '658491740829' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 11:07:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740829 sName = DESKTOP-A35H22C ========================2020-02-19 11:07: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 = '658491740829' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 11:08:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740829 sName = DESKTOP-A35H22C ========================2020-02-19 11:08:04======================== 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 = '658491740829' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 11:08:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740825 sName = DESKTOP-A35H22C ========================2020-02-19 11:08:49======================== 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 = '658491740825' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 11:08:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'this0528' ========================2020-02-19 11:08:49======================== SELECT idx FROM macs WHERE mac_addr = '6C299540D3874084EA1E' AND app_code = '039' ========================2020-02-19 11:08:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '309607' ========================2020-02-19 11:08:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '309607' ========================2020-02-19 11:08:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '309607', '6C299540D3874084EA1E', '039', 'DESKTOP-A35H22C', '110', '1366', '768', 'this0528', '거성비앤씨[김정섭]', '658491740825' ) ========================2020-02-19 11:09:10======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A35H22C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 6C299540D3874084EA1E sCDKey = 658491740825 sName = DESKTOP-A35H22C ========================2020-02-19 11:09: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 = '658491740825' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-19 13:03:54======================== noteurl_start parm_app_code = 046 parm_pc_name = HJNAIL2-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D05099683A2DCE1B30D4 sCDKey = 547491127013 sName = HJNAIL2-PC ========================2020-02-19 13:03: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 = '547491127013' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-19 13:03:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjnailmall' ========================2020-02-19 13:03:54======================== SELECT idx FROM macs WHERE mac_addr = 'D05099683A2DCE1B30D4' AND app_code = '046' ========================2020-02-19 13:03:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '148996' ========================2020-02-19 13:03:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '148996' ========================2020-02-19 13:03:56======================== UPDATE mac_detail SET pc_name = 'HJNAIL2-PC', os_type = '90', user_id = 'hjnailmall', user_name = '화정네일몰[이영미]', screen_w = '1600', screen_h = '900', cdkey = '547491127013' WHERE mac_idx = '148996' ========================2020-02-19 13:49:40======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-IQECF2Q parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C6915B6F53C6A52B70 sCDKey = 678061938278 sName = DESKTOP-IQECF2Q ========================2020-02-19 13:49: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 = '678061938278' AND r.app_code = '050' AND r.app_block = 0 ========================2020-02-19 13:49:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gpmc31101151' ========================2020-02-19 13:49:40======================== SELECT idx FROM macs WHERE mac_addr = '94C6915B6F53C6A52B70' AND app_code = '050' ========================2020-02-19 13:49:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311075' ========================2020-02-19 13:49:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311075' ========================2020-02-19 13:49: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 ( '311075', '94C6915B6F53C6A52B70', '050', 'DESKTOP-IQECF2Q', '109', '1920', '1080', 'gpmc31101151', '경기도의료원 이천병원[이희천]', '678061938278' ) ========================2020-02-19 17:58:03======================== noteurl_start parm_app_code = 051 parm_pc_name = SKIN17NB00406 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 54EE75DF4004AA34F788 sCDKey = 003401679376 sName = 자산(운영) ========================2020-02-19 17:58: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2020-02-19 17:58:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2020-02-19 17:58:03======================== SELECT idx FROM macs WHERE mac_addr = '54EE75DF4004AA34F788' AND app_code = '051' ========================2020-02-19 17:58:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311103' ========================2020-02-19 17:58:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311103' ========================2020-02-19 17:58: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 ( '311103', '54EE75DF4004AA34F788', '051', '자산(운영)', '109', '1920', '1080', 'skinfosec', '인포섹[이대윤]', '003401679376' )