Symantec Management Platform (Notification Server)

 View Only
  • 1.  Table Inv_Client_Task_Resources not showing correctly after upgrade to 7.5

    Posted Aug 28, 2014 10:44 AM

    Hi All,

    The table in the cmdb called Inv_Client_Task_Resources is not showing the correct status of computers online.

    It has by default set them all to online, and if the taskagent responds it start working.

    This means that all computers that aren't connected anymore have a status of online in the database.

    I'm using this table in workflow to show when a computer is online or not.

    I've also tryed to put them to 0 manually but after a while they change to 1 again even with no task agent installed on the pc, nor is the pc connected to the network

    Before in 7.1sp2 it was working like a charme.

    Has this feature been changed in 7.5? or has anyone has an other solution that i can get the online status out of the cmdb with a sqlquery



  • 2.  RE: Table Inv_Client_Task_Resources not showing correctly after upgrade to 7.5

    Broadcom Employee
    Posted Aug 28, 2014 11:16 AM


  • 3.  RE: Table Inv_Client_Task_Resources not showing correctly after upgrade to 7.5

    Posted Sep 01, 2014 03:46 AM

    Hi Igor,

    Thanks for the reply, but both links use the Inv_Client_Task_Resources table to see if a computer is online or not.

    The problem is that Inv_Client_Task_Resources table is not giving the correct data.

    It is putting computer as online(1) by default, where it should put them offline(0) by default.

    Now i'm seeing computers online that are not online,this messes up my workflow showing incorrect information to the users. that think a computer is online but its not.

    As an example i'm seeing at the moment 480 computers online with your query, while there are exactly 330 computers effectivly online( if i look at the deployment database).

    Before the update these figures where correct, now there not.



  • 4.  RE: Table Inv_Client_Task_Resources not showing correctly after upgrade to 7.5

    Broadcom Employee
    Posted Sep 02, 2014 06:52 AM

    You mean that all computers, even if they aren't active a few days, they are still shown as active in Inv_Client_Task_Resources table?

    As example, you can filter by last policy request date/time, using join in "Evt_NS_Client_Config_Request" SQL table where. If client computer hasn't performed request of new policy more than 2 days ago, then it can be set as inactive.



  • 5.  RE: Table Inv_Client_Task_Resources not showing correctly after upgrade to 7.5
    Best Answer

    Posted Sep 02, 2014 07:53 AM

    You mean that all computers, even if they aren't active a few days, they are still shown as active in Inv_Client_Task_Resources table?

    Yes this was the case, even pc's that havent been online for weeks, still appeared online in the table, but now it seems to be solved.

    I have upgraded to HF2 and then the table was giving the correct status again.

    Strange but ok its working again.

    Thank you for all your reply's Igor

    cheers