How to turn off suppressed Views for everyone at once

Document ID : KB000013525
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How do I turn off suppressed views for all users in CAPC?

Environment:
Any version of CAPM
Answer:

You can run the following query against the netqosportal on CAPC:

  • update user_definitions set SuppressViews='N'; 

This will turn off suppressed views for all users

The full steps would be

  1. Open a linux shell to CAPC
  2. mysql netqosportal
  3. update user_definitions set SuppressViews='N'; 
  4. Log out of the CAPC UI, then back in again.  All views should now be exposed  in the UI for everyone
Additional Information:

When view suppression is enabled it should hide views that do not apply for the datasources you have added.  The downside of this procedure is it may result in views being exposed that do not necessarily have data