Customer reported that when trying to open the Permissions section for Security Role Manager is taking too long to load. --Steps to reproduce 1. Open Security Role Manager (under SMP Console>Settings>Security>Permissions) 2. Change the view drop down to "Resources" 3. Left pane takes over 20 seconds to load created at install for its use.
Known issue. Altiris Profiler identifies the following SQL command as almost all of the 20 seconds.
Analysis of the rows reveled that the results included not only the Items under the Resource Management folder (like filters and OU groups), but also included ALL resources which were all under the "Resources" folder. No resources can have security directly on them anyway, but the QueryItemTreebuild object was retrieving them anyway only to get discarded because the "Resources" folder is a hidden folder so the entire "Resources" branch is removed one node at a time.
This issue has been reported to Symantec Development team. A fix has been targeted for the next release (current ETA ITMS 7.5).
There is a SQL workaround for 7.1 customers. See attached "Fix for TECH201624.sql" file