========================2022-01-21 09:26:38======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:26: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:26:41======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:26: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:30:21======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:30: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:31:08======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:31: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:34:36======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:34: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:34:40======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:34: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:34:44======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:34:44======================== 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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:35:45======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:35: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:35:55======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:35: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:36:00======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:36: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:36:04======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:36: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:36:19======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:36: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:36:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dcnet727812' ========================2022-01-21 09:36:19======================== SELECT idx FROM macs WHERE mac_addr = '00D8610CEF74427FD930' AND app_code = '047' ========================2022-01-21 09:36:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359642' ========================2022-01-21 09:36:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359642' ========================2022-01-21 09:36:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359642', '00D8610CEF74427FD930', '047', 'DESKTOP-IJ4S4IU', '�쐢�룄�슦 10', '0', '0', 'dcnet727812', '주식회사 디씨넷[강선정]', '712713428201' ) ========================2022-01-21 09:36:23======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IJ4S4IU parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8610CEF74427FD930 sCDKey = 712713428201 sName = DESKTOP-IJ4S4IU ========================2022-01-21 09:36: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 = '712713428201' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:56:57======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8586FBA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 진짜 콜센터1 ========================2022-01-21 09:56:57======================== 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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:56:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 09:56:57======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 09:56:57======================== 값이 없을 경우 ========================2022-01-21 09:58:23======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8586FBA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 진짜 콜센터1 ========================2022-01-21 09:58: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 09:58:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 09:58:23======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 09:58:23======================== 값이 없을 경우 ========================2022-01-21 10:00:41======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8586FBA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스1 ========================2022-01-21 10:00: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:00:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:00:41======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:00:41======================== 값이 없을 경우 ========================2022-01-21 10:01:20======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8586FBA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스1번 ========================2022-01-21 10:01: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:01:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:01:20======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:01:20======================== 값이 없을 경우 ========================2022-01-21 10:02:07======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8586FBA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스1번 ========================2022-01-21 10:02: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:02:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:02:07======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:02:07======================== 값이 없을 경우 ========================2022-01-21 10:04:22======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8586FBA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스01 ========================2022-01-21 10:04: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:04:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:04:22======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:04:22======================== 값이 없을 경우 ========================2022-01-21 10:04:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8586FBA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스01 ========================2022-01-21 10:04:35======================== 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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:04:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:04:35======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:04:35======================== 값이 없을 경우 ========================2022-01-21 10:04:40======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8586FBA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스 ========================2022-01-21 10:04: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:04:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:04:40======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:04:40======================== 값이 없을 경우 ========================2022-01-21 10:07:15======================== noteurl_start parm_app_code = 047 parm_pc_name = 포스1번 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스1번 ========================2022-01-21 10:07: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:07:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:07:15======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:07:15======================== 값이 없을 경우 ========================2022-01-21 10:09:38======================== noteurl_start parm_app_code = 047 parm_pc_name = 포스1번 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스1번 ========================2022-01-21 10:09: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:09:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:09:38======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:09:38======================== 값이 없을 경우 ========================2022-01-21 10:14:38======================== noteurl_start parm_app_code = 047 parm_pc_name = 포스1번 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스1번 ========================2022-01-21 10:14: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:14:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:14:38======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:14:38======================== 값이 없을 경우 ========================2022-01-21 10:22:38======================== noteurl_start parm_app_code = 047 parm_pc_name = 콜센터4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5E9C92760354 sCDKey = 278126570271 sName = 포스04 ========================2022-01-21 10:22: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:22:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:22:38======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5E9C92760354' AND app_code = '047' ========================2022-01-21 10:22:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359626' ========================2022-01-21 10:22:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359626' ========================2022-01-21 10:22:38======================== UPDATE mac_detail SET pc_name = '포스04', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '359626' ========================2022-01-21 10:40:12======================== noteurl_start parm_app_code = 039 parm_pc_name = 신명 parm_os_type = 110 parm_screen_w = 1707 parm_screen_h = 1067 parm_user_mac = 60F262DF421AB65207E2 sCDKey = 447533552334 sName = 신명 ========================2022-01-21 10:40: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 = '447533552334' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-21 10:40:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cinmyung' ========================2022-01-21 10:40:12======================== SELECT idx FROM macs WHERE mac_addr = '60F262DF421AB65207E2' AND app_code = '039' ========================2022-01-21 10:40:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359761' ========================2022-01-21 10:40:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359761' ========================2022-01-21 10:40: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 ( '359761', '60F262DF421AB65207E2', '039', '신명', '110', '1707', '1067', 'cinmyung', '신명[김용철]', '447533552334' ) ========================2022-01-21 10:42:17======================== noteurl_start parm_app_code = 047 parm_pc_name = 포스1번 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 242FFA1D5C5B00E6513B sCDKey = 278126570271 sName = 포스1번 ========================2022-01-21 10:42:17======================== 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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 10:42:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 10:42:17======================== SELECT idx FROM macs WHERE mac_addr = '242FFA1D5C5B00E6513B' AND app_code = '047' ========================2022-01-21 10:42:17======================== 값이 없을 경우 ========================2022-01-21 11:44:35======================== noteurl_start parm_app_code = 047 parm_pc_name = 포스1번 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF733A1E090EEF09AE sCDKey = 278126570271 sName = 포스1번 ========================2022-01-21 11:44:35======================== 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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 11:44:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 11:44:35======================== SELECT idx FROM macs WHERE mac_addr = '50AF733A1E090EEF09AE' AND app_code = '047' ========================2022-01-21 11:44:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '357890' ========================2022-01-21 11:44:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '357890' ========================2022-01-21 11:44:35======================== UPDATE mac_detail SET pc_name = '포스1번', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '357890' ========================2022-01-21 12:59:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UF2RAHR parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00D861DB2F51E01B9D75 sCDKey = 563097943389 sName = DESKTOP-UF2RAHR ========================2022-01-21 12:59: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 = '563097943389' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-21 12:59:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhfutkdghl' ========================2022-01-21 12:59:04======================== SELECT idx FROM macs WHERE mac_addr = '00D861DB2F51E01B9D75' AND app_code = '039' ========================2022-01-21 12:59:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359778' ========================2022-01-21 12:59:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359778' ========================2022-01-21 12:59:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359778', '00D861DB2F51E01B9D75', '039', 'DESKTOP-UF2RAHR', '110', '1920', '1080', 'rhfutkdghl', '고려상회[류승철]', '563097943389' ) ========================2022-01-21 13:16:02======================== noteurl_start parm_app_code = 047 parm_pc_name = 포스2번 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732B0878EE2B1141 sCDKey = 278126570271 sName = 진짜 포스4번 ========================2022-01-21 13:16:02======================== 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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 13:16:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 13:16:02======================== SELECT idx FROM macs WHERE mac_addr = '50AF732B0878EE2B1141' AND app_code = '047' ========================2022-01-21 13:16:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '358994' ========================2022-01-21 13:16:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '358994' ========================2022-01-21 13:16:02======================== UPDATE mac_detail SET pc_name = '진짜 포스4번', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '358994' ========================2022-01-21 13:32:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RBO1M78 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = F0038C8CFA3B18B9DE61 sCDKey = 210742859361 sName = DESKTOP-RBO1M78 ========================2022-01-21 13:32: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-21 13:32:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2022-01-21 13:32:54======================== SELECT idx FROM macs WHERE mac_addr = 'F0038C8CFA3B18B9DE61' AND app_code = '039' ========================2022-01-21 13:32:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359511' ========================2022-01-21 13:32:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359511' ========================2022-01-21 13:32:54======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RBO1M78', os_type = '110', user_id = 'julee37', user_name = '개성자바라, 스텐나라[이순녀]', screen_w = '1280', screen_h = '800', cdkey = '210742859361' WHERE mac_idx = '359511' ========================2022-01-21 14:50:32======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HMR4LAK parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8BBC19249694E83AB82 sCDKey = 378938316959 sName = DESKTOP-HMR4LAK ========================2022-01-21 14:50: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 = '378938316959' AND r.app_code = '046' AND r.app_block = 0 ========================2022-01-21 14:50:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'colormobile' ========================2022-01-21 14:50:32======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC19249694E83AB82' AND app_code = '046' ========================2022-01-21 14:50:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359790' ========================2022-01-21 14:50:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359790' ========================2022-01-21 14:50:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '359790', 'D8BBC19249694E83AB82', '046', 'DESKTOP-HMR4LAK', '110', '1536', '864', 'colormobile', '컬러모바일[김태웅]', '378938316959' ) ========================2022-01-21 16:06:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QCGTG9O parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04DC28D6550E3FB34 sCDKey = 550549105676 sName = DESKTOP-QCGTG9O ========================2022-01-21 16:06: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 = '550549105676' AND r.app_code = '039' AND r.app_block = 0 ========================2022-01-21 16:06:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhdmf214' ========================2022-01-21 16:06:48======================== SELECT idx FROM macs WHERE mac_addr = '18C04DC28D6550E3FB34' AND app_code = '039' ========================2022-01-21 16:06:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359803' ========================2022-01-21 16:06:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359803' ========================2022-01-21 16:06: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 ( '359803', '18C04DC28D6550E3FB34', '039', 'DESKTOP-QCGTG9O', '110', '1920', '1080', 'rhdmf214', '주)주은실업[김상호]', '550549105676' ) ========================2022-01-21 17:01:38======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-562HC2U parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FC3497C71B3E12F94F63 sCDKey = 278126570271 sName = 한민희 ========================2022-01-21 17:01: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-01-21 17:01:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-01-21 17:01:38======================== SELECT idx FROM macs WHERE mac_addr = 'FC3497C71B3E12F94F63' AND app_code = '047' ========================2022-01-21 17:01:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '357212' ========================2022-01-21 17:01:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '357212' ========================2022-01-21 17:01:38======================== UPDATE mac_detail SET pc_name = '한민희', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '357212' ========================2022-01-21 17:42:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BP9MQ92 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E070EAB1175ADE8F3FD6 sCDKey = 034321302191 sName = DESKTOP-BP9MQ92 ========================2022-01-21 17:42: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 = '034321302191' AND r.app_code = '046' AND r.app_block = 0 ========================2022-01-21 17:42:49======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BP9MQ92 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E070EAB1175ADE8F3FD6 sCDKey = 034322302191 sName = DESKTOP-BP9MQ92 ========================2022-01-21 17:42: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 = '034322302191' AND r.app_code = '046' AND r.app_block = 0 ========================2022-01-21 17:42:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yujung6852' ========================2022-01-21 17:42:49======================== SELECT idx FROM macs WHERE mac_addr = 'E070EAB1175ADE8F3FD6' AND app_code = '046' ========================2022-01-21 17:42:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359825' ========================2022-01-21 17:42:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359825' ========================2022-01-21 17:42: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 ( '359825', 'E070EAB1175ADE8F3FD6', '046', 'DESKTOP-BP9MQ92', '110', '1920', '1080', 'yujung6852', '(주)유정배관[윤경환]', '034322302191' )