IT Management Suite

 View Only
Back to discussions
Expand all | Collapse all

Table Inv_Client_Task_Resources not showing correctly in ITMS 7.5

  • 1.  Table Inv_Client_Task_Resources not showing correctly in ITMS 7.5

    Posted Oct 17, 2014 06:29 AM

    Hello all

    My table shows all clients as IsActive=1. Still the same after HF2 and HF3 (on SP1). Originally fresh install 7.5 without SP1.

    Franks solution is not mine (updating to HF2):
    https://www-secure.symantec.com/connect/forums/table-invclienttaskresources-not-showing-correctly-after-upgrade-75

    SELECT     dbo.Inv_AeX_AC_Identification.Name, dbo.Inv_AeX_AC_Identification.[OS Name], dbo.Inv_Client_Task_Resources.IsActive, 
                          dbo.Inv_Client_Task_Resources.LastRegistered
    FROM         dbo.Inv_Client_Task_Resources INNER JOIN
                          dbo.Inv_AeX_AC_Identification ON dbo.Inv_Client_Task_Resources._ResourceGuid = dbo.Inv_AeX_AC_Identification._ResourceGuid

    Example:
    2 clients LastRegistered date is yesterday, clients are off but Task Portal and SQL query show all clients as active.

    Anyone else?

    Is there any documentation how this table "Inv_Client_Task_Resources" is populated? E.g. Intervals etc.?