========================2018-02-08 09:58:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F615627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-02-08 09:58: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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 09:59:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F615627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-02-08 09:59: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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 09:59:22======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F615627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-02-08 09:59:22======================== 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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 10:00:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F615627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-02-08 10:00:05======================== 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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 10:01:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C91311F615627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-02-08 10:01: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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 10:01:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'y1776073' ========================2018-02-08 10:01:21======================== SELECT idx FROM macs WHERE mac_addr = '14C91311F615627461D4' AND app_code = '039' ========================2018-02-08 10:01:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '224427' ========================2018-02-08 10:01:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '224427' ========================2018-02-08 10:01:21======================== UPDATE mac_detail SET pc_name = 'DESKTOP-7CR0VE9', os_type = '110', user_id = 'y1776073', user_name = '광자동화[황순영]', screen_w = '1920', screen_h = '1080', cdkey = '826605316014' WHERE mac_idx = '224427' ========================2018-02-08 11:39:31======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 40618679972194079F66 sCDKey = 812834265902 sName = MSDN-SPECIAL ========================2018-02-08 11:39: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 = '812834265902' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 11:39:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vnfmsshdtks' ========================2018-02-08 11:39:31======================== SELECT idx FROM macs WHERE mac_addr = '40618679972194079F66' AND app_code = '039' ========================2018-02-08 11:39:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241713' ========================2018-02-08 11:39:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241713' ========================2018-02-08 11:39: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 ( '241713', '40618679972194079F66', '039', 'MSDN-SPECIAL', '90', '1280', '1024', 'vnfmsshdtks', '푸른농산[이재훈]', '812834265902' ) ========================2018-02-08 11:39:36======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 40618679972194079F66 sCDKey = 812834265902 sName = MSDN-SPECIAL ========================2018-02-08 11:39:36======================== 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 = '812834265902' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 13:14:31======================== noteurl_start parm_app_code = 050 parm_pc_name = SEO-W12-001 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4AE52C00D6B55458620 sCDKey = 473735708251 sName = SEO-W12-001 ========================2018-02-08 13:14: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 = '473735708251' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-08 13:14:41======================== noteurl_start parm_app_code = 050 parm_pc_name = SEO-W12-001 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4AE52C00D6B55458620 sCDKey = 473735708251 sName = SEO-W12-001 ========================2018-02-08 13:14:41======================== 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 = '473735708251' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-08 13:18:29======================== noteurl_start parm_app_code = 050 parm_pc_name = SEO-W12-001 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4AE52C00D6B55458620 sCDKey = 473735708251 sName = SEO-W12-001 ========================2018-02-08 13:18:29======================== 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 = '473735708251' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-08 13:18:31======================== noteurl_start parm_app_code = 050 parm_pc_name = SEO-W12-001 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4AE52C00D6B55458620 sCDKey = 473735708251 sName = SEO-W12-001 ========================2018-02-08 13:18: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 = '473735708251' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-08 13:36:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NC2SF3S parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 6045CB64D253EC537E9F sCDKey = 291729054564 sName = DESKTOP-NC2SF3S ========================2018-02-08 13:36: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 = '291729054564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 13:36:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cwpmc' ========================2018-02-08 13:36:33======================== SELECT idx FROM macs WHERE mac_addr = '6045CB64D253EC537E9F' AND app_code = '039' ========================2018-02-08 13:36:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241735' ========================2018-02-08 13:36:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241735' ========================2018-02-08 13:36: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 ( '241735', '6045CB64D253EC537E9F', '039', 'DESKTOP-NC2SF3S', '110', '1600', '900', 'cwpmc', '청원피엠씨(주)[청원피엠씨]', '291729054564' ) ========================2018-02-08 13:42:39======================== noteurl_start parm_app_code = 039 parm_pc_name = 옥소리사원 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAEAFBACCEFC891 sCDKey = 291729054564 sName = 옥소리사원 ========================2018-02-08 13:42: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 = '291729054564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 13:42:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cwpmc' ========================2018-02-08 13:42:39======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEAFBACCEFC891' AND app_code = '039' ========================2018-02-08 13:42:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241737' ========================2018-02-08 13:42:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241737' ========================2018-02-08 13:42:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241737', '24F5AAEAFBACCEFC891', '039', '옥소리사원', '110', '1920', '1080', 'cwpmc', '청원피엠씨(주)[청원피엠씨]', '291729054564' ) ========================2018-02-08 13:59:09======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C233916284AB6D26 sCDKey = 291729054564 sName = ========================2018-02-08 13:59: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 = '291729054564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 13:59:20======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C233916284AB6D26 sCDKey = 291729054564 sName = 이종환 ========================2018-02-08 13:59:20======================== 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 = '291729054564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 13:59:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cwpmc' ========================2018-02-08 13:59:20======================== SELECT idx FROM macs WHERE mac_addr = '7085C233916284AB6D26' AND app_code = '039' ========================2018-02-08 13:59:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241110' ========================2018-02-08 13:59:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241110' ========================2018-02-08 13:59:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241110', '7085C233916284AB6D26', '039', '이종환', '110', '1920', '1080', 'cwpmc', '청원피엠씨(주)[청원피엠씨]', '291729054564' ) ========================2018-02-08 14:00:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QMHA23N parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAEB79CA6874067C sCDKey = 291729054564 sName = DESKTOP-QMHA23N ========================2018-02-08 14:00:48======================== 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 = '291729054564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 14:00:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cwpmc' ========================2018-02-08 14:00:48======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEB79CA6874067C' AND app_code = '039' ========================2018-02-08 14:00:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241739' ========================2018-02-08 14:00:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241739' ========================2018-02-08 14:00:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241739', '24F5AAEB79CA6874067C', '039', 'DESKTOP-QMHA23N', '110', '1920', '1080', 'cwpmc', '청원피엠씨(주)[청원피엠씨]', '291729054564' ) ========================2018-02-08 14:02:40======================== noteurl_start parm_app_code = 045 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509992DCDB8CEFD568 sCDKey = 963976041453 sName = 이옥미 ========================2018-02-08 14:02: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 = '963976041453' AND r.app_code = '045' AND r.app_block = 0 ========================2018-02-08 14:02:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'azsystem' ========================2018-02-08 14:02:40======================== SELECT idx FROM macs WHERE mac_addr = 'D0509992DCDB8CEFD568' AND app_code = '045' ========================2018-02-08 14:02:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241741' ========================2018-02-08 14:02:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241741' ========================2018-02-08 14:02: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 ( '241741', 'D0509992DCDB8CEFD568', '045', '이옥미', '90', '1920', '1080', 'azsystem', '에이젯시스템[노종섭]', '963976041453' ) ========================2018-02-08 14:02:43======================== noteurl_start parm_app_code = 045 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509992DCDB8CEFD568 sCDKey = 963976041453 sName = 이옥미 ========================2018-02-08 14:02: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 = '963976041453' AND r.app_code = '045' AND r.app_block = 0 ========================2018-02-08 14:02:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'azsystem' ========================2018-02-08 14:02:43======================== SELECT idx FROM macs WHERE mac_addr = 'D0509992DCDB8CEFD568' AND app_code = '045' ========================2018-02-08 14:02:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241741' ========================2018-02-08 14:02:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241741' ========================2018-02-08 14:02:43======================== UPDATE mac_detail SET pc_name = '이옥미', os_type = '90', user_id = 'azsystem', user_name = '에이젯시스템[노종섭]', screen_w = '1920', screen_h = '1080', cdkey = '963976041453' WHERE mac_idx = '241741' ========================2018-02-08 14:09:56======================== noteurl_start parm_app_code = 045 parm_pc_name = OWNER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8C89A56B1CE712BC091D sCDKey = 963976041453 sName = 박진화 ========================2018-02-08 14:09:56======================== 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 = '963976041453' AND r.app_code = '045' AND r.app_block = 0 ========================2018-02-08 14:09:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'azsystem' ========================2018-02-08 14:09:56======================== SELECT idx FROM macs WHERE mac_addr = '8C89A56B1CE712BC091D' AND app_code = '045' ========================2018-02-08 14:09:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241743' ========================2018-02-08 14:09:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241743' ========================2018-02-08 14:09:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241743', '8C89A56B1CE712BC091D', '045', '박진화', '90', '1920', '1080', 'azsystem', '에이젯시스템[노종섭]', '963976041453' ) ========================2018-02-08 14:16:30======================== noteurl_start parm_app_code = 045 parm_pc_name = 김태선-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2325E55DC675E69 sCDKey = 963976041453 sName = 김태선-PC ========================2018-02-08 14:16: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 = '963976041453' AND r.app_code = '045' AND r.app_block = 0 ========================2018-02-08 14:16:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'azsystem' ========================2018-02-08 14:16:30======================== SELECT idx FROM macs WHERE mac_addr = '7085C2325E55DC675E69' AND app_code = '045' ========================2018-02-08 14:16:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241745' ========================2018-02-08 14:16:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241745' ========================2018-02-08 14:16: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 ( '241745', '7085C2325E55DC675E69', '045', '김태선-PC', '90', '1920', '1080', 'azsystem', '에이젯시스템[노종섭]', '963976041453' ) ========================2018-02-08 15:23:01======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56D5083E664D2E0 sCDKey = 584682333082 sName = 조대연 ========================2018-02-08 15:23:01======================== 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 = '584682333082' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 15:23:42======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56D5083E664D2E0 sCDKey = 584082333082 sName = 조대연 ========================2018-02-08 15:23: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 = '584082333082' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 15:23:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dyc913' ========================2018-02-08 15:23:42======================== SELECT idx FROM macs WHERE mac_addr = 'BCAEC56D5083E664D2E0' AND app_code = '039' ========================2018-02-08 15:23:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '100790' ========================2018-02-08 15:23:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '100790' ========================2018-02-08 15:23:42======================== UPDATE mac_detail SET pc_name = '조대연', os_type = '110', user_id = 'dyc913', user_name = '상동기업[조대연]', screen_w = '1920', screen_h = '1080', cdkey = '584082333082' WHERE mac_idx = '100790' ========================2018-02-08 15:24:11======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56D5083E664D2E0 sCDKey = 584082333082 sName = 조대연 ========================2018-02-08 15:24: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 = '584082333082' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 15:24:22======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56D5083E664D2E0 sCDKey = 584082333082 sName = 조남준 ========================2018-02-08 15:24:22======================== 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 = '584082333082' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-08 16:33:03======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = gaonpaint ========================2018-02-08 16:33: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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-08 16:33:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-08 16:33:03======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-08 16:33:03======================== 값이 없을 경우 ========================2018-02-08 16:56:26======================== noteurl_start parm_app_code = 046 parm_pc_name = EO1 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 98838982C43BDAB017AA sCDKey = 735832194513 sName = EO1 ========================2018-02-08 16:56: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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-08 16:56:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jdcid' ========================2018-02-08 16:56:26======================== SELECT idx FROM macs WHERE mac_addr = '98838982C43BDAB017AA' AND app_code = '046' ========================2018-02-08 16:56:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241770' ========================2018-02-08 16:56:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241770' ========================2018-02-08 16:56:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241770', '98838982C43BDAB017AA', '046', 'EO1', '110', '1600', '900', 'jdcid', '이오산전(EO산전)[정동춘]', '735832194513' ) ========================2018-02-08 16:57:53======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = gaonpaint ========================2018-02-08 16:57: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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-08 16:57:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-08 16:57:53======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-08 16:57:53======================== 값이 없을 경우 ========================2018-02-08 16:57:56======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = gaonpaint ========================2018-02-08 16:57:56======================== 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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-08 16:57:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-08 16:57:56======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-08 16:57:56======================== 값이 없을 경우 ========================2018-02-08 16:58:30======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = gaonpaint ========================2018-02-08 16: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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-08 16:58:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-08 16:58:30======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-08 16:58:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241772' ========================2018-02-08 16:58:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241772' ========================2018-02-08 16: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 ( '241772', '309C238018CB46208190', '046', 'gaonpaint', '110', '1920', '1080', 'gaonpaint', '가온페인트[오은경]', '826623775319' ) ========================2018-02-08 17:00:45======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BH0OHN0 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 10C37B4E1DA06A81DF67 sCDKey = 735832194513 sName = DESKTOP-BH0OHN0 ========================2018-02-08 17:00: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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-08 17:00:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jdcid' ========================2018-02-08 17:00:45======================== SELECT idx FROM macs WHERE mac_addr = '10C37B4E1DA06A81DF67' AND app_code = '046' ========================2018-02-08 17:00:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241578' ========================2018-02-08 17:00:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241578' ========================2018-02-08 17:00:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241578', '10C37B4E1DA06A81DF67', '046', 'DESKTOP-BH0OHN0', '110', '1280', '1024', 'jdcid', '이오산전(EO산전)[정동춘]', '735832194513' ) ========================2018-02-08 17:12:25======================== noteurl_start parm_app_code = 046 parm_pc_name = EO3 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D43D7E0D9F723C4113BE sCDKey = 735832194513 sName = EO3 ========================2018-02-08 17:12: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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-08 17:12:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jdcid' ========================2018-02-08 17:12:25======================== SELECT idx FROM macs WHERE mac_addr = 'D43D7E0D9F723C4113BE' AND app_code = '046' ========================2018-02-08 17:12:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241774' ========================2018-02-08 17:12:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241774' ========================2018-02-08 17:12: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 ( '241774', 'D43D7E0D9F723C4113BE', '046', 'EO3', '110', '1600', '900', 'jdcid', '이오산전(EO산전)[정동춘]', '735832194513' )