========================2023-11-07 09:06:29======================== noteurl_start parm_app_code = 039 parm_pc_name = KYUNGLEE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A159FED776F85F0F2D sCDKey = 264472231851 sName = KYUNGLEE ========================2023-11-07 09:06: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 = '264472231851' AND r.app_code = '039' AND r.app_block = 0 ========================2023-11-07 09:06:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs456' ========================2023-11-07 09:06:29======================== SELECT idx FROM macs WHERE mac_addr = 'A8A159FED776F85F0F2D' AND app_code = '039' ========================2023-11-07 09:06:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '395850' ========================2023-11-07 09:06:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '395850' ========================2023-11-07 09:06: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 ( '395850', 'A8A159FED776F85F0F2D', '039', 'KYUNGLEE', '110', '1920', '1080', 'bs456', '주식회사엔텍[부산지사]', '264472231851' ) ========================2023-11-07 09:18:33======================== noteurl_start parm_app_code = 039 parm_pc_name = 1004-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74563CA00730BC847A9E sCDKey = 697806173553 sName = 1004-PC ========================2023-11-07 09:18: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 = '697806173553' AND r.app_code = '039' AND r.app_block = 0 ========================2023-11-07 09:18:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'starhst1' ========================2023-11-07 09:18:33======================== SELECT idx FROM macs WHERE mac_addr = '74563CA00730BC847A9E' AND app_code = '039' ========================2023-11-07 09:18:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '395851' ========================2023-11-07 09:18:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '395851' ========================2023-11-07 09:18: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 ( '395851', '74563CA00730BC847A9E', '039', '1004-PC', '110', '1920', '1080', 'starhst1', '(유)상관철망[홍선태]', '697806173553' ) ========================2023-11-07 11:08:12======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GV2IQPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C860005A4592F8BA6890 sCDKey = 851009780429 sName = DESKTOP-GV2IQPN ========================2023-11-07 11:08: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 = '851009780429' AND r.app_code = '047' AND r.app_block = 0 ========================2023-11-07 11:08:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'm_corea21' ========================2023-11-07 11:08:12======================== SELECT idx FROM macs WHERE mac_addr = 'C860005A4592F8BA6890' AND app_code = '047' ========================2023-11-07 11:08:12======================== 값이 없을 경우 ========================2023-11-07 11:08:16======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GV2IQPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C860005A4592F8BA6890 sCDKey = 851009780429 sName = DESKTOP-GV2IQPN ========================2023-11-07 11:08:16======================== 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 = '851009780429' AND r.app_code = '047' AND r.app_block = 0 ========================2023-11-07 11:08:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'm_corea21' ========================2023-11-07 11:08:16======================== SELECT idx FROM macs WHERE mac_addr = 'C860005A4592F8BA6890' AND app_code = '047' ========================2023-11-07 11:08:16======================== 값이 없을 경우 ========================2023-11-07 11:09:51======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GV2IQPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C860005A4592F8BA6890 sCDKey = 851009780429 sName = DESKTOP-GV2IQPN ========================2023-11-07 11:09: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 = '851009780429' AND r.app_code = '047' AND r.app_block = 0 ========================2023-11-07 11:09:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'm_corea21' ========================2023-11-07 11:09:51======================== SELECT idx FROM macs WHERE mac_addr = 'C860005A4592F8BA6890' AND app_code = '047' ========================2023-11-07 11:09:51======================== 값이 없을 경우 ========================2023-11-07 11:19:25======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GV2IQPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C860005A4592F8BA6890 sCDKey = 851009780429 sName = DESKTOP-GV2IQPN ========================2023-11-07 11:19: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 = '851009780429' AND r.app_code = '047' AND r.app_block = 0 ========================2023-11-07 11:19:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'm_corea21' ========================2023-11-07 11:19:25======================== SELECT idx FROM macs WHERE mac_addr = 'C860005A4592F8BA6890' AND app_code = '047' ========================2023-11-07 11:19:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '395861' ========================2023-11-07 11:19:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '395861' ========================2023-11-07 11:19: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 ( '395861', 'C860005A4592F8BA6890', '047', 'DESKTOP-GV2IQPN', '�쐢�룄�슦 10', '0', '0', 'm_corea21', '모빌리티코리아[모빌리티코리아]', '851009780429' ) ========================2023-11-07 12:52:58======================== noteurl_start parm_app_code = 050 parm_pc_name = PC00072563 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389DCDCC1E256280E sCDKey = 358297282020 sName = PC00072563 ========================2023-11-07 12:52: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 = '358297282020' AND r.app_code = '050' AND r.app_block = 0 ========================2023-11-07 12:52:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'j8311park' ========================2023-11-07 12:52:59======================== SELECT idx FROM macs WHERE mac_addr = '988389DCDCC1E256280E' AND app_code = '050' ========================2023-11-07 12:52:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '395788' ========================2023-11-07 12:52:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '395788' ========================2023-11-07 12:52:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '395788', '988389DCDCC1E256280E', '050', 'PC00072563', '109', '1920', '1080', 'j8311park', '삼성화재[박진홍]', '358297282020' ) ========================2023-11-07 12:53:23======================== noteurl_start parm_app_code = 050 parm_pc_name = PC00072563 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389DCDCC1E256280E sCDKey = 358297282020 sName = PC00072563 ========================2023-11-07 12:53: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 = '358297282020' AND r.app_code = '050' AND r.app_block = 0 ========================2023-11-07 12:53:31======================== noteurl_start parm_app_code = 050 parm_pc_name = PC00072563 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389DCDCC1E256280E sCDKey = 358297282020 sName = PC00072563 ========================2023-11-07 12:53: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 = '358297282020' AND r.app_code = '050' AND r.app_block = 0