========================2020-11-06 09:25:37======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 825349C9D99D70900801 sCDKey = 167774888715 sName = SAMSUNG ========================2020-11-06 09:25: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 = '167774888715' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 09:25:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dntkdwlr' ========================2020-11-06 09:25:37======================== SELECT idx FROM macs WHERE mac_addr = '825349C9D99D70900801' AND app_code = '039' ========================2020-11-06 09:25:37======================== 값이 없을 경우 ========================2020-11-06 09:25:59======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 825349C9D99D70900801 sCDKey = 167774888715 sName = SAMSUNG ========================2020-11-06 09:25:59======================== 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 = '167774888715' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 09:26:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dntkdwlr' ========================2020-11-06 09:26:00======================== SELECT idx FROM macs WHERE mac_addr = '825349C9D99D70900801' AND app_code = '039' ========================2020-11-06 09:26:00======================== 값이 없을 경우 ========================2020-11-06 09:26:06======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 825349C9D99D70900801 sCDKey = 167774888715 sName = SAMSUNG ========================2020-11-06 09:26:06======================== 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 = '167774888715' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 09:26:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dntkdwlr' ========================2020-11-06 09:26:06======================== SELECT idx FROM macs WHERE mac_addr = '825349C9D99D70900801' AND app_code = '039' ========================2020-11-06 09:26:06======================== 값이 없을 경우 ========================2020-11-06 09:29:09======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 00FF89E091BF70900801 sCDKey = 167774888715 sName = SAMSUNG ========================2020-11-06 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 = '167774888715' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 09:29:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dntkdwlr' ========================2020-11-06 09:29:09======================== SELECT idx FROM macs WHERE mac_addr = '00FF89E091BF70900801' AND app_code = '039' ========================2020-11-06 09:29:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329532' ========================2020-11-06 09:29:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329532' ========================2020-11-06 09:29:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329532', '00FF89E091BF70900801', '039', 'SAMSUNG', '110', '1366', '768', 'dntkdwlr', '승리유통[우상직]', '167774888715' ) ========================2020-11-06 10:12:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LBVQDC2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D8B02CADEC5A2E7 sCDKey = 736238096238 sName = DESKTOP-LBVQDC2 ========================2020-11-06 10:12: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 = '736238096238' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 10:12:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hwain4089' ========================2020-11-06 10:12:33======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D8B02CADEC5A2E7' AND app_code = '039' ========================2020-11-06 10:12:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329546' ========================2020-11-06 10:12:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329546' ========================2020-11-06 10:12: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 ( '329546', '1C1B0D8B02CADEC5A2E7', '039', 'DESKTOP-LBVQDC2', '110', '1920', '1080', 'hwain4089', '화인정밀[김현호]', '736238096238' ) ========================2020-11-06 10:19:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-E428QTO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA146C5A395FFA0650 sCDKey = 338303565024 sName = DESKTOP-E428QTO ========================2020-11-06 10:19:12======================== 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 = '338303565024' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 10:19:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo8554' ========================2020-11-06 10:19:12======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146C5A395FFA0650' AND app_code = '039' ========================2020-11-06 10:19:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329549' ========================2020-11-06 10:19:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329549' ========================2020-11-06 10:19:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329549', 'FCAA146C5A395FFA0650', '039', 'DESKTOP-E428QTO', '110', '1920', '1080', 'sinwoo8554', '신우씨스템[김현숙]', '338303565024' ) ========================2020-11-06 10:19:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-E428QTO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA146C5A395FFA0650 sCDKey = 338303565024 sName = DESKTOP-E428QTO ========================2020-11-06 10:19:19======================== 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 = '338303565024' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 11:01:51======================== noteurl_start parm_app_code = 039 parm_pc_name = A-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04D296883E0608BC4 sCDKey = 089402731062 sName = A-PC ========================2020-11-06 11:01: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 = '089402731062' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 11:01:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'simsy6754' ========================2020-11-06 11:01:51======================== SELECT idx FROM macs WHERE mac_addr = '18C04D296883E0608BC4' AND app_code = '039' ========================2020-11-06 11:01:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329554' ========================2020-11-06 11:01:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329554' ========================2020-11-06 11:01: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 ( '329554', '18C04D296883E0608BC4', '039', 'A-PC', '110', '1920', '1080', 'simsy6754', '(주)성주아이앤비[심순영]', '089402731062' ) ========================2020-11-06 13:14:27======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1594EDFA436902760 sCDKey = 017488729041 sName = SAMSUNG ========================2020-11-06 13:14: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 = '017488729041' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 13:14:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ldscrs38' ========================2020-11-06 13:14:27======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1594EDFA436902760' AND app_code = '039' ========================2020-11-06 13:14:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329565' ========================2020-11-06 13:14:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329565' ========================2020-11-06 13:14:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329565', 'A8A1594EDFA436902760', '039', 'SAMSUNG', '110', '1920', '1080', 'ldscrs38', '유영고무[유대성]', '017488729041' ) ========================2020-11-06 13:14:39======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1594EDFA436902760 sCDKey = 017488729041 sName = SAMSUNG ========================2020-11-06 13:14: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 = '017488729041' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 13:14:50======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1594EDFA436902760 sCDKey = 017488729041 sName = SAMSUNG ========================2020-11-06 13:14: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 = '017488729041' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 13:31:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-H7RU1CH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1594EDFA4679B6DB sCDKey = 017488729041 sName = DESKTOP-H7RU1CH ========================2020-11-06 13:31: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 = '017488729041' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 13:31:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ldscrs38' ========================2020-11-06 13:31:11======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1594EDFA4679B6DB' AND app_code = '039' ========================2020-11-06 13:31:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329568' ========================2020-11-06 13:31:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329568' ========================2020-11-06 13:31: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 ( '329568', 'A8A1594EDFA4679B6DB', '039', 'DESKTOP-H7RU1CH', '110', '1920', '1080', 'ldscrs38', '유영고무[유대성]', '017488729041' ) ========================2020-11-06 14:29:47======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E811326ED3026EC0606A sCDKey = 454564121074 sName = USER-PC ========================2020-11-06 14:29: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 = '454564121074' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-06 14:29:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sts153' ========================2020-11-06 14:29:48======================== SELECT idx FROM macs WHERE mac_addr = 'E811326ED3026EC0606A' AND app_code = '039' ========================2020-11-06 14:29:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '123642' ========================2020-11-06 14:29:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '123642' ========================2020-11-06 14:29:48======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'sts153', user_name = '153스텐레스[이강수]', screen_w = '1600', screen_h = '900', cdkey = '454564121074' WHERE mac_idx = '123642' ========================2020-11-06 21:30:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VEFG2EF parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 74D4351DA14A1EC0B7CB sCDKey = 266382448056 sName = DESKTOP-VEFG2EF ========================2020-11-06 21:30:23======================== 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 = '266382448056' AND r.app_code = '039' AND r.app_block = 0