I'm not able to remotely control agents via the 'Kaseya Live Connect' application. Every time I try to connect to an agent, it gets stuck on Connecting...
I was previously using 'Kaseya Remote Control' and I didn't have any issues. Remote control via VNC viewer still works. It's also worth noting that this issue isn't affecting all of our admins.
I haven't been able to connect to any of our workstations, which are mostly running on Win 7 SP1 and Win Server 2008 R2. All Agents are v220.127.116.11.
Any help would be much appreciated.
Try running each one of these quires, then try and connect to a machine again.
• Update incorrect reference counts:
UPDATE t SET t.ReferenceCount = c.ReferenceCount FROM dbo.DenormalizedScopeToMach t INNER JOIN dbo.vComputedDenormalizedScopeToMach c ON c.PartitionId = t.PartitionId AND c.AdminScopeId = t.AdminScopeId AND c.AgentGuid = t.AgentGuid WHERE c.ReferenceCount <> t.ReferenceCount
• Delete rows not found in computed view:
FROM dbo.DenormalizedScopeToMach t
LEFT OUTER JOIN dbo.vComputedDenormalizedScopeToMach c ON c.PartitionId = t.PartitionId AND c.AdminScopeId = t.AdminScopeId AND c.AgentGuid = t.AgentGuid AND c.ReferenceCount = t.ReferenceCount
WHERE c.PartitionId IS NULL
• Insert rows not found in actual table:
INSERT INTO dbo.DenormalizedScopeToMach(PartitionId, AdminScopeId, AgentGuid, ReferenceCount)
SELECT c.PartitionId, c.AdminScopeId, c.AgentGuid, c.ReferenceCount
FROM dbo.vComputedDenormalizedScopeToMach c
LEFT OUTER JOIN dbo.DenormalizedScopeToMach t ON t.PartitionId = c.PartitionId AND t.AdminScopeId = c.AdminScopeId AND t.AgentGuid = c.AgentGuid
WHERE t.PartitionId IS NULL