下面的 SQL 查询可帮助您检索端点的 MCP 重定向状态。
有关执行查询的帮助,请参阅
KB67591-如何针对 ePolicy Orchestrator 数据库运行技术支持提供的 SQL 脚本。
SQL 查询以检索已成功安装 MCP 且工作正常的系统的详细信息:
SELECT ecp.ComputerName, ecp.IPAddress, epsv.Value
FROM EPOComputerProperties ecp (nolock)
INNER JOIN EPOProductProperties epp (nolock)
ON ecp.ParentID = epp.ParentID AND epp.ProductCode LIKE 'MCPAGENT%'
INNER JOIN EPOProductSettingValuesMT epsv (nolock) ON epsv.ParentID = epp.AutoID
INNER JOIN EPOProductSettingLabels epsl (nolock) ON epsl.AutoID = epsv.LabelID
WHERE epsl.Setting IN ('szPropsCollectTime', 'szRedirectionStatus');
SQL 查询以检索未正确安装 MCP 的系统的详细信息:
SELECT ecp.ComputerName
FROM EPOComputerProperties (nolock) ecp
INNER JOIN EPOProductProperties epp (nolock)
ON ecp.ParentID = epp.ParentID AND epp.ProductCode LIKE 'MCPAGENT%'
WHERE ecp.ParentID NOT IN
(SELECT DISTINCT epp.parentID
FROM EPOProductProperties epp
INNER JOIN EPOProductSettingValuesMT epsv ON epsv.ParentID = epp.AutoID AND epp.ProductCode LIKE 'MCPAGENT%'
INNER JOIN EPOProductSettingLabels epsl ON epsl.AutoID = epsv.LabelID
WHERE epsl.Setting IN ('szPropsCollectTime', 'szRedirectionStatus'));
SQL 查询,它显示所有 MCP 端点的最新重定向状态:
select a.ComputerName, a.IPAddress , d.Value
from EPOComputerProperties a (nolock), EPOProductProperties b (nolock),
EPOProductSettingLabels c (nolock), EPOProductSettingValuesMT d (nolock)
where c.Setting like 'szRedirection%' and c.AutoId = d.labelId and d.parentID=b.AutoID and b.parentID=a.parentID;
select *
from EPOComputerProperties a (nolock), EPOProductProperties b (nolock),
EPOProductSettingLabels c (nolock), EPOProductSettingValuesMT d (nolock)
where c.Setting like 'szR%' and c.AutoId = d.labelId and d.parentID=b.AutoID and b.parentID=a.parentID;