========================2024-07-08 11:36:52======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04CB1DB0D34627EBF sCDKey = 017337601557 sName = POS-PC ========================2024-07-08 11:36: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 = '017337601557' AND r.app_code = '046' AND r.app_block = 0 ========================2024-07-08 11:36:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k114' ========================2024-07-08 11:36:53======================== SELECT idx FROM macs WHERE mac_addr = '00E04CB1DB0D34627EBF' AND app_code = '046' ========================2024-07-08 11:36:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407975' ========================2024-07-08 11:36:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407975' ========================2024-07-08 11:36:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407975', '00E04CB1DB0D34627EBF', '046', 'POS-PC', '90', '1024', '768', 'k114', '강원산업안전(주)[김상옥]', '017337601557' ) ========================2024-07-08 12:12:31======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5EG4KLJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50EBF67BBBE2CA855E48 sCDKey = 278126570271 sName = DESKTOP-5EG4KLJ ========================2024-07-08 12:12: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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2024-07-08 12:12:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2024-07-08 12:12:31======================== SELECT idx FROM macs WHERE mac_addr = '50EBF67BBBE2CA855E48' AND app_code = '047' ========================2024-07-08 12:12:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '398564' ========================2024-07-08 12:12:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '398564' ========================2024-07-08 12:12:31======================== UPDATE mac_detail SET pc_name = 'DESKTOP-5EG4KLJ', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '398564' ========================2024-07-08 13:06:56======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0C81086 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BFB4B4E41EC677F9 sCDKey = 736345277617 sName = DESKTOP-0C81086 ========================2024-07-08 13:06: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 = '736345277617' AND r.app_code = '047' AND r.app_block = 0 ========================2024-07-08 13:06:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rarari29' ========================2024-07-08 13:06:56======================== SELECT idx FROM macs WHERE mac_addr = '1831BFB4B4E41EC677F9' AND app_code = '047' ========================2024-07-08 13:06:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407980' ========================2024-07-08 13:06:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407980' ========================2024-07-08 13:06: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 ( '407980', '1831BFB4B4E41EC677F9', '047', 'DESKTOP-0C81086', '�쐢�룄�슦 10', '0', '0', 'rarari29', '연암골재판넬[최성환]', '736345277617' ) ========================2024-07-08 13:06:59======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0C81086 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BFB4B4E41EC677F9 sCDKey = 736345277617 sName = DESKTOP-0C81086 ========================2024-07-08 13:06: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 = '736345277617' AND r.app_code = '047' AND r.app_block = 0 ========================2024-07-08 13:08:00======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-0C81086 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BFB4B4E41EC677F9 sCDKey = 736345277617 sName = DESKTOP-0C81086 ========================2024-07-08 13:08: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 = '736345277617' AND r.app_code = '047' AND r.app_block = 0 ========================2024-07-08 13:08:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rarari29' ========================2024-07-08 13:08:01======================== SELECT idx FROM macs WHERE mac_addr = '1831BFB4B4E41EC677F9' AND app_code = '047' ========================2024-07-08 13:08:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407980' ========================2024-07-08 13:08:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407980' ========================2024-07-08 13:08:01======================== UPDATE mac_detail SET pc_name = 'DESKTOP-0C81086', os_type = '�쐢�룄�슦 10', user_id = 'rarari29', user_name = '연암골재판넬[최성환]', screen_w = '0', screen_h = '0', cdkey = '736345277617' WHERE mac_idx = '407980' ========================2024-07-08 17:11:29======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = DESKTOP-EIDVLC1 ========================2024-07-08 17:11: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:11:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:11:29======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:11:29======================== 값이 없을 경우 ========================2024-07-08 17:11:43======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = DESKTOP-EIDVLC1 ========================2024-07-08 17:11: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:11:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:11:43======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:11:43======================== 값이 없을 경우 ========================2024-07-08 17:11:55======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = DESKTOP-EIDVLC1 ========================2024-07-08 17:11: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:11:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:11:55======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:11:55======================== 값이 없을 경우 ========================2024-07-08 17:12:14======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = DESKTOP-EIDVLC1 ========================2024-07-08 17:12:14======================== 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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:12:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:12:14======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:12:14======================== 값이 없을 경우 ========================2024-07-08 17:12:52======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = sk31101151 ========================2024-07-08 17:12: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:12:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:12:52======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:12:52======================== 값이 없을 경우 ========================2024-07-08 17:12:55======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = sk31101151 ========================2024-07-08 17:12: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:12:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:12:55======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:12:55======================== 값이 없을 경우 ========================2024-07-08 17:13:00======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = sk31101151 ========================2024-07-08 17:13: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:13:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:13:00======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:13:00======================== 값이 없을 경우 ========================2024-07-08 17:13:11======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = DESKTOP-EIDVLC1 ========================2024-07-08 17:13: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:13:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:13:11======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:13:11======================== 값이 없을 경우 ========================2024-07-08 17:18:13======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = DESKTOP-EIDVLC1 ========================2024-07-08 17:18:13======================== 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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:18:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:18:13======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:18:13======================== 값이 없을 경우 ========================2024-07-08 17:18:20======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497AAA0960E1968DE sCDKey = 702921131601 sName = DESKTOP-EIDVLC1 ========================2024-07-08 17:18: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:18:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:18:20======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497AAA0960E1968DE' AND app_code = '050' ========================2024-07-08 17:18:20======================== 값이 없을 경우 ========================2024-07-08 17:19:47======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-EIDVLC1 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8A2D6520F8B0E1968DE sCDKey = 702921131601 sName = DESKTOP-EIDVLC1 ========================2024-07-08 17:19: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 = '702921131601' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-08 17:19:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sk31101151' ========================2024-07-08 17:19:47======================== SELECT idx FROM macs WHERE mac_addr = 'F8A2D6520F8B0E1968DE' AND app_code = '050' ========================2024-07-08 17:19:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407139' ========================2024-07-08 17:19:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407139' ========================2024-07-08 17:19:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407139', 'F8A2D6520F8B0E1968DE', '050', 'DESKTOP-EIDVLC1', '109', '1536', '864', 'sk31101151', '경기도의료원 이천병원[이희천]', '702921131601' )