Proactive monitoring of Task Servers
search cancel

Proactive monitoring of Task Servers


Article ID: 272316


Updated On:


IT Management Suite Client Management Suite


It is helpful to know if a Task Server is not performing properly.  Is there a report that can show me which package servers are operating properly?   We would like to know if Task Servers are not performing properly.


ITMS 8.x


The SQL Report below will show which Task Servers may not be functioning properly.  This can be added to a Notification Policy and emailed to Symantec Admins when a server is in the report.

/*     -- Only used for Scoping results, if desired
DECLARE @v1_TrusteeScope nvarchar(233)
   SET @v1_TrusteeScope = N'{03D52442-35BA-4504-9EED-DE327DDD2A22},{2E1F478A-4986-4223-9D1E-B5920A63AB41},{582029E2-FC5B-4717-8808-B80D6EF0FD67}
   ci.[Guid] AS [_ItemGuid], ci.[Name], cts.[ClientTaskServerGuid] AS [Task Server GUID],
   aci.[OS Name], cts.[LastRegistered] AS [Task Agent Last Registered],
   cts.[LastTaskCheck] AS [Last Check for Tasks], cts.[IsActive]
   [vRM_Computer_Item] AS ci
      Right JOIN [Inv_Client_Task_Servers] AS cts
         ON (ci.[Guid] = cts.[_ResourceGuid])
      Right JOIN [vAllComputerInfo] AS aci
         ON (ci.[Guid] = aci.[Guid])
   (  cts.[IsActive] = 1)
      AND  ( cts.LastTaskCheck < getdate()-1 )  -- not working in last 24 hours
-- Below is a commented out line for adding site servers that need to be excluded
     AND (ci.[Name] NOT IN ('server1', 'server2'))

-- If scoping is desired, uncomment the section below
/* --   AND (ci.[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] 
    --    WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] 
    --        FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))