Symantec Management Platform (Notification Server)

All,

We recently upgraded to 7.5 SP1.  Prior to upgrading I had an automation policy set up to send me a report daily of the Task servers that are not registered.  Apparently in going to SP1, there was a change in the way the Task Servers were reflected in the Inv_Client_Task_Resources table.  Below is the sql code I used to identify the Task servers with the issues.  Anything that came back as "IsActive" = 0, I knew there was a problem to look into...such as the Task Server not registering with itself.  And each time the SQL report was correct.  After the upgrade, all the task servers are reporting back with "1" even if they are not registered. 

I am looking for a way to identify (proactively) which Task Servers are not registered to themselves in order to fix the issue before the calls come in.  Is there a different table that shows which machines are NOT registered and I can filter from there?

Below WAS the query I was using to identify those troubled Task Servers..

Thanks in advance!

select DISTINCT

vc.guid, vc.Name, vc.[OS Name], LastRegistered, IsActive

FROM vComputer vc

Join vSiteServices vss on vss.[ComputerGuid] = vc.[Guid]

INNER JOIN [Inv_Client_Task_Resources] ctr on ctr._ResourceGuid = vc.Guid

INNER JOIN vComputer vc2 on vc2.Guid = ctr.ClientTaskServerGuid

where IsActive = '0'

Hi jms97,

1.  About tables and views, related to Task Server:

[dbo].[Inv_Client_Task_Servers] table also contains "IsActive" column value

"vActiveTaskServiceComputers" view contains only active Task Server(s)

2. You can filter out for "Task" mention in some existings "Stored Procedures" from SQL Management Studio and check what SQL queries they are using.

3. You can simply add existing web parts on "My Portal" page in SMP Console and check health state of each Task Servers/CTA.

Thanks,

IP.

Also there is a default report which shows all your Task Servers and there is a drill-down report which shown which clients are registered with this Task Server, Active state and last date/time update: