search cancel

Right-click context menu is missing items in ITMS 8.5 RU2


Article ID: 174827


Updated On:


IT Management Suite Asset Management Solution


Right-click context menu is missing items

  • Unable to delete computers via right-click context popup menu in Symantec management console.

  • Unable to edit the location via right-click context popup menu in Symantec management console.


Also, editing a computer resource may be timing out.


ITMS 8.5 RU2



Users that are not part of the Symantec Administrators role are no longer able to do some actions after upgrading to ITMS 8.5 RU2.


Known Issue:

Custom Security Roles in ITMS 8.5 RU2 are missing functionality due to permissions

There is an issue with the SQL function "fnGetTrusteeScopedResources".


This issue has been reported to the Symantec Development team. A fix has been planned to be implemented in ITMS 8.5 RU3, September 2019.

In the meantime, run the attached SQL script on the Symantec_CMDB database. This will update the SQL function "fnGetTrusteeScopedResources" to a version that will resolve the issue with 8.5 RU2.



In some instances, some customers using Asset may notice slowness or even time outs while trying to open Asset views, pages or reports. Even after trying the version for "fnGetTrusteeScopedResources"  attached to this article. If that is the case, a workaround for that is to revert back to the version used in 8.5 RU1 for this function until we can provided a better version of it in our 8.5 RU3 release:

  1.  Run the following in order to remove the current version of this fuction:
    DROP FUNCTION [dbo].[fnGetTrusteeScopedResources]
  2. Then run the following to create it back using the original 8.5 RU1 version of it:
    CREATE FUNCTION [dbo].[fnGetTrusteeScopedResources]
        @Trustees   nvarchar(max)
        WITH cte_Trustee ( Guid ) as
            SELECT      DISTINCT st.TrusteeGuid
                FROM    dbo.fnListToTable( @Trustees, ',' ) tr
                JOIN    sec_Trustee st ON st.Trustee = tr.[nstr]
        cte_IsAdmin ( flSymcAdmin ) AS
            SELECT      COUNT(*) AS [Cnt]
                FROM    cte_Trustee
                WHERE   Guid = '2E1F478A-4986-4223-9D1E-B5920A63AB41'
        cte_Entity ( EntityGuid ) AS
            SELECT      se.EntityGuid
                FROM    cte_IsAdmin aa
                JOIN    sec_Entity  se ON aa.flSymcAdmin = 1
            UNION ALL
            SELECT      se.EntityGuid
                FROM    cte_IsAdmin aa
                JOIN  ( SELECT     ss.EntityGuid
                            FROM   sec_EntitySource  ss
                            JOIN   sec_EntityTrustee st ON st.EntityGuid = ss.SourceGuid
                            JOIN   cte_Trustee       tt ON tt.Guid = st.TrusteeGuid
                            WHERE  st.Permission >= 0x2000000000000000
                      ) se ON aa.flSymcAdmin = 0
        SELECT    DISTINCT sm.ResourceGuid
            FROM  ScopeMembership   sm
            WHERE sm.ScopeCollectionGuid IN ( SELECT EntityGuid FROM cte_Entity )


fnGetTrusteeScopedResources.sql get_app