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

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:

Run the following in order to remove the current version of this function:
DROP FUNCTION [dbo].[fnGetTrusteeScopedResources]
Then run the following to create it back using the original 8.5 RU1 version of

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