Proactive monitoring of Task Servers

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

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.

Environment

ITMS 8.x

Resolution

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}
        ,{7E7FE117-6F94-42C1-8498-2A4EA8DFA441},{B760E9A9-E4DB-404C-A93F-AEA51754AA4F},{CF604A37-46C2-4ECF-99C0-2829D0F64337}'
        */
SELECT
   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]
FROM
   [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])
WHERE  
   (  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))))
    */