The SQL queries below help you retrieve the SCP redirection status of endpoints.
For help with execute queries, see
KB67591 - How to run a SQL script provided by Technical Support against the ePolicy Orchestrator database.
SQL query to retrieve details of systems where SCP is installed successfully and working:
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 query to retrieve the details of the systems where SCP isn't installed correctly:
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 query that shows the latest redirection status for all SCP endpoints:
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;
