Resolution
fact
NetIQ Vulnerability Manager 5.5
NetiQ Secure Configuration Manager 5.6
fact
NetIQ Vulnerability Manager Agent for Windows 5.5
symptom
Policy template reports have no data and do not return an error.
symptom
Policy template reports are empty, but they should have information in them.
cause
More than one agent is monitoring the same endpoint.
fix
Run the following SQL query to find endpoints being monitored by more than one agent:
SELECT a.DisplayName as AgentName, s.Name as EndpointName, x.NumAgentsMonitoringEndpoint
FROM AgentsToServers ats
INNER JOIN Agents a ON a.AgentID = ats.AgentID
INNER JOIN Servers s ON s.ServerID = ats.ServerID
INNER JOIN
(
SELECT count(*) as NumAgentsMonitoringEndpoint, ats1.ServerID
FROM AgentsToServers ats1
GROUP BY ats1.ServerID
HAVING count(*) > 1
)
x ON x.ServerID = ats.ServerID
The query returns a list of endpoints. Determine which agent should be monitoring each endpoint, and remove the endpoint from the other agent.