========================2021-07-26 09:02:33======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-AP5UQRE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 00CFE059CB20640E833F sCDKey = 990376709320 sName = DESKTOP-AP5UQRE ========================2021-07-26 09:02: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 = '990376709320' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 09:02:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hotdog_hm' ========================2021-07-26 09:02:33======================== SELECT idx FROM macs WHERE mac_addr = '00CFE059CB20640E833F' AND app_code = '046' ========================2021-07-26 09:02:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348073' ========================2021-07-26 09:02:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348073' ========================2021-07-26 09:02: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 ( '348073', '00CFE059CB20640E833F', '046', 'DESKTOP-AP5UQRE', '110', '1366', '768', 'hotdog_hm', '핫독애견용품 화명점[최수빈]', '990376709320' ) ========================2021-07-26 10:13:51======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-81GPO85 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5CAF0FC840E05CC8 sCDKey = 616636429020 sName = DESKTOP-81GPO85 ========================2021-07-26 10:13: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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 10:13:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qkdxo200' ========================2021-07-26 10:13:52======================== SELECT idx FROM macs WHERE mac_addr = '408D5CAF0FC840E05CC8' AND app_code = '046' ========================2021-07-26 10:13:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348115' ========================2021-07-26 10:13:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348115' ========================2021-07-26 10:13:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '348115', '408D5CAF0FC840E05CC8', '046', 'DESKTOP-81GPO85', '110', '1280', '1024', 'qkdxo200', '성도유통[방휘대]', '616636429020' ) ========================2021-07-26 10:48:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HL2B3AE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E917DAA3B0DBD7EA sCDKey = 638082599901 sName = DESKTOP-HL2B3AE ========================2021-07-26 10:48: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 = '638082599901' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-26 10:48:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunnyrivers' ========================2021-07-26 10:48:29======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E917DAA3B0DBD7EA' AND app_code = '039' ========================2021-07-26 10:48:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348116' ========================2021-07-26 10:48:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348116' ========================2021-07-26 10:48:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '348116', '8CB0E917DAA3B0DBD7EA', '039', 'DESKTOP-HL2B3AE', '110', '1920', '1080', 'sunnyrivers', '주식회사 디온[이경선]', '638082599901' ) ========================2021-07-26 11:17:36======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = SKIN330001356 ========================2021-07-26 11:17: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:17:50======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = SKIN330001356 ========================2021-07-26 11:17: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:18:53======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = SKIN330001356 ========================2021-07-26 11:18: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:20:53======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = SKIN330001356 ========================2021-07-26 11:20: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:20:55======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = SKIN330001356 ========================2021-07-26 11:20: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:21:07======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = ADMIN ========================2021-07-26 11:21: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:22:40======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = SKIN330001356 ========================2021-07-26 11:22: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:22:51======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = ADMIN ========================2021-07-26 11:22: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:23:00======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = mj ========================2021-07-26 11:23: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:31:54======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = SKIN330001356 ========================2021-07-26 11:31: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:32:08======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = mj ========================2021-07-26 11:32: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:32:19======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = ADMIN ========================2021-07-26 11:32: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:32:29======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = 박남신 ========================2021-07-26 11:32: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 = '003401679376' AND r.app_code = '050' AND r.app_block = 0 ========================2021-07-26 11:32:52======================== noteurl_start parm_app_code = 050 parm_pc_name = SKIN330001356 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892757B4F6CF61DE sCDKey = 003401679376 sName = SKIN330001356 ========================2021-07-26 11:32:52======================== 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 = '050' AND r.app_block = 0 ========================2021-07-26 13:25:43======================== noteurl_start parm_app_code = 039 parm_pc_name = 이석-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF44948303283CC2 sCDKey = 638082599901 sName = 이석-PC ========================2021-07-26 13:25: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 = '638082599901' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-26 13:25:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunnyrivers' ========================2021-07-26 13:25:43======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF44948303283CC2' AND app_code = '039' ========================2021-07-26 13:25:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285681' ========================2021-07-26 13:25:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285681' ========================2021-07-26 13:25: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 ( '285681', 'BC5FF44948303283CC2', '039', '이석-PC', '90', '1920', '1080', 'sunnyrivers', '주식회사 디온[이경선]', '638082599901' ) ========================2021-07-26 13:41:34======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9RV3UE3 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5CAF0FC8B2CEFDCD sCDKey = 616636429020 sName = DESKTOP-9RV3UE3 ========================2021-07-26 13:41:34======================== 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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 13:41:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qkdxo200' ========================2021-07-26 13:41:35======================== SELECT idx FROM macs WHERE mac_addr = '408D5CAF0FC8B2CEFDCD' AND app_code = '046' ========================2021-07-26 13:41:35======================== 값이 없을 경우 ========================2021-07-26 13:41:38======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9RV3UE3 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5CAF0FC8B2CEFDCD sCDKey = 616636429020 sName = DESKTOP-9RV3UE3 ========================2021-07-26 13:41: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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 13:41:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qkdxo200' ========================2021-07-26 13:41:38======================== SELECT idx FROM macs WHERE mac_addr = '408D5CAF0FC8B2CEFDCD' AND app_code = '046' ========================2021-07-26 13:41:38======================== 값이 없을 경우 ========================2021-07-26 13:42:09======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9RV3UE3 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5CAF0FC8B2CEFDCD sCDKey = 616636429020 sName = DESKTOP-9RV3UE3 ========================2021-07-26 13:42: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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 13:42:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qkdxo200' ========================2021-07-26 13:42:10======================== SELECT idx FROM macs WHERE mac_addr = '408D5CAF0FC8B2CEFDCD' AND app_code = '046' ========================2021-07-26 13:42:10======================== 값이 없을 경우 ========================2021-07-26 13:42:41======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9RV3UE3 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5CAF0FC8B2CEFDCD sCDKey = 616636429020 sName = DESKTOP-9RV3UE3 ========================2021-07-26 13:42: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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 13:42:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qkdxo200' ========================2021-07-26 13:42:41======================== SELECT idx FROM macs WHERE mac_addr = '408D5CAF0FC8B2CEFDCD' AND app_code = '046' ========================2021-07-26 13:42:41======================== 값이 없을 경우 ========================2021-07-26 13:45:54======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9RV3UE3 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5CAF0FC8B2CEFDCD sCDKey = 616636429020 sName = DESKTOP-9RV3UE3 ========================2021-07-26 13:45: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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 13:45:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qkdxo200' ========================2021-07-26 13:45:54======================== SELECT idx FROM macs WHERE mac_addr = '408D5CAF0FC8B2CEFDCD' AND app_code = '046' ========================2021-07-26 13:45:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348136' ========================2021-07-26 13:45:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348136' ========================2021-07-26 13:45:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '348136', '408D5CAF0FC8B2CEFDCD', '046', 'DESKTOP-9RV3UE3', '110', '1280', '1024', 'qkdxo200', '성도유통[방휘대]', '616636429020' ) ========================2021-07-26 13:45:58======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9RV3UE3 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5CAF0FC8B2CEFDCD sCDKey = 616636429020 sName = DESKTOP-9RV3UE3 ========================2021-07-26 13:45:58======================== 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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 14:00:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-VSJLFRD parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = F80DAC10358C162AF0F6 sCDKey = 212845321133 sName = DESKTOP-VSJLFRD ========================2021-07-26 14: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 = '212845321133' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-26 14:00:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeil0989' ========================2021-07-26 14:00:55======================== SELECT idx FROM macs WHERE mac_addr = 'F80DAC10358C162AF0F6' AND app_code = '046' ========================2021-07-26 14:00:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343649' ========================2021-07-26 14:00:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343649' ========================2021-07-26 14:00:55======================== UPDATE mac_detail SET pc_name = 'DESKTOP-VSJLFRD', os_type = '110', user_id = 'jeil0989', user_name = '제일기계공구[오대환]', screen_w = '3440', screen_h = '1440', cdkey = '212845321133' WHERE mac_idx = '343649' ========================2021-07-26 14:20:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0A0BNF6 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 18C04D558A9432BAECBA sCDKey = 440810636226 sName = DESKTOP-0A0BNF6 ========================2021-07-26 14:20: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 = '440810636226' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-26 14:20:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sss8211' ========================2021-07-26 14:20:23======================== SELECT idx FROM macs WHERE mac_addr = '18C04D558A9432BAECBA' AND app_code = '039' ========================2021-07-26 14:20:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348139' ========================2021-07-26 14:20:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348139' ========================2021-07-26 14:20:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '348139', '18C04D558A9432BAECBA', '039', 'DESKTOP-0A0BNF6', '110', '1680', '1050', 'sss8211', '두원산업[서상선]', '440810636226' )