When the Sym Agents with a blacklisted GUID are requesting a policy and attempting to save a messaging resource an error similar to the following is seen:
GUID ... has been blocked by the Host Resource Blacklist.
ITMS 8.x
Remove the GUID from the AgentBlacklist table if the process was unable to get the new GUID sent out to the Sym Agent.
The following SQL query will delete the machines from the AgentBlacklist tables that are actively trying to communicate with the Notification Server:
delete from AgentBlacklist
where Guid in
(
select c.Guid
from AgentBlacklist ab
join Evt_NS_Client_Config_Request ccr on ccr.ResourceGuid = ab.Guid
join vRM_Computer_Item c on c.Guid = ccr.ResourceGuid
where ccr.StartTime > GETDATE () - 7
group by c.Guid
having COUNT (ccr.ResourceGuid) > 5
)
If errors regarding the ResourceMerge table begin to appear in the logs after the above query is run then the following SQL query may need to be run as well:
delete from ResourceMerge
where OldResourceGuid in
(
select vc.Guid
from ResourceMerge rm
join vRM_Computer_Item vc on vc.Guid = rm.OldResourceGuid
)