Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Working with views using Open schema

Open schema gives you access to the reporting data generated from BMC Server Automation. You can integrate the data with any database warehouse solution already in use in your organization (for example, Tableau, Business Objects, SAP, Informatica, and so on) to generate customized reports. 

The BMC Decision Support for Server Automation schema is available for the following domains of BMC Server Automation:



Important
  • BMC recommends that you do not make changes in the existing schema/view. If you need to modify the view, you should use a copy of the original view for the modifications.
  • BMC recommends that you apply appropriate filters (such as date duration or bl_site_id) while querying the views. You can also apply other filters based on your requirements. Filtering the data improves performance by decreasing the amount of data being fetched, thereby minimizing the time required to process the views.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*