I am attempting to use the BAQ listed in this post to find the Security Groups tied to Menu items. While making modifications, I found some duplication.
Upon investigating, I found where sub-menu items, such as Job Management and Setup under Job Management, had an extra item in the Ice.Menu table. One of the Job Management entries has UD listed in the Module field, so I know it was altered. If I check Menu Maintenance and look at Job Management, that is the active menu item.
Should one of the fields within the Menu table give an indication that it is active? If so, what should I look at? I’ve tried the CompanyVisibility field along with a few others, but no combination of criteria has been able to give me only active menu items.
Thanks in advance.