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

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

book

Article ID: 174827

calendar_today

Updated On:

Products

IT Management Suite Asset Management Solution

Issue/Introduction

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.

Environment

ITMS 8.5 RU2

 

Cause

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".

Resolution

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.

 

Note:

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)
    )
    RETURNS TABLE
    AS
    RETURN
        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 )
    GO

Attachments

fnGetTrusteeScopedResources.sql get_app