Right-click context menu is missing items in ITMS 8.5 RU2
Last Updated July 12, 2019
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.
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:
Run the following in order to remove the current version of this fuction: DROPFUNCTION [dbo].[fnGetTrusteeScopedResources]
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