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:
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.