To bring back all the sub-menus under the Reports tab:
- Open the TMCM web console.
- Go to Administration > License Management > Control Manager License Information to check whether the current Control Manager License Information type is Standard or Advanced.
The Standard license has a limitation wherein the reporting function is not fully supported, so this is not an issue. The Advanced license offers all features. If you have the Advanced license, proceed to the next step.
- Go to Administration > Account Management > User Roles > Administrators > Edit Role > Menu Access Control > Reports to see if the sub-menu items are checked or not.
- Tick the box next to the unchecked sub-menus and click Save. All the sub-menus should now appear.
If you were unable to check and/or save the sub-menus, go to Administration > Account Management > User Roles to check the roles of your login account. Once you know your user role:
- Log in to the problematic TMCM database via the SQL Server Management Studio and run the following commands:
Use tmcm_database_name
Select GUID from tb_account where ID='User Roles'
Select * from tb_AccountMenuRelation where accguid='GUID'Use actual values. For example:
Use tmcm_db
Select GUID from tb_account where ID='administrators'
Select * from tb_AccountMenuRelation where accguid='4A38561D-8DFA-4FFF-992C-D4F114F3ABCC' - Log in to a working TMCM database via the SQL Server Management Studio and run the following commands:
Use tmcm_database_name
Select GUID from tb_account where ID='User Roles'
Select * from tb_AccountMenuRelation where accguid='GUID'Like above, use actual values.
- Compare the results of the problematic and the working databases. Some items are missing in the problematic database's results.
- Insert the missing items from the working database into the problematic database using the following commands:
Insert into tb_AccountMenuRelation
values('GUID', xxxx, 255)Make sure to input the actual values.
Once done, the missing sub-menu items should now show up in the Reports tab of the TMCM web console. If the issue persists, contact Trend Micro Technical Support.