Report to show which Task Servers are functioning properly

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

Is it possible to find out which Task Servers are working properly?  This would include processing Registrations and also Agent 'Check for Tasks'. 

Environment

ITMS 8.x

Resolution

This report returns the Task Status for last 24 hours.  Create a new SQL report with this as the SQL Script.

SELECT
   c.[Guid] AS [_ItemGuid],
   c.[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 c
      JOIN [Inv_Client_Task_Servers] AS cts
         ON (c.[Guid] = cts.[_ResourceGuid])
      JOIN [vAllComputerInfo] AS aci
         ON (c.[Guid] = aci.[Guid])
WHERE   cts.[IsActive] = 1
   AND cts.[LastTaskCheck] > getdate() -1

It's assumed that if a Task Server exists that is not on this list, it may not be functioning properly.  To get a list of All Task Servers, comment '--' out the Where statement and the following AND statement to see All Servers with Task installed on them.

How to read the report

Task Agent Last Registered may not be current, but should be sometime in the last few months, depending on when new agents were last added.  You can test this by clicking "Reset Agent" on the task tab of an agent.  Restarting the Agent Service should also work.

Last Check for Tasks should be pretty current within the last hour or so as the agent checks for tasks every 30 minutes by default.