Phased rollout This version of the software is currently available only to early adopter SaaS customers as the first step in our phased rollout. Click here to view an earlier version.

Examples of creating custom reports

This topic explains the examples of creating custom reports.

Example: Create a CMDB parent child relationship report 

Follow these steps to create the parent to child relationship data by using the Base Element and the Base Relationship tables.

  1. Create a new view in Smart Reporting and add the following tables:
    BMC.Core:BMC_BaseRelationship & BMC.Core:BMC_BaseElement(2)
    For more information, see Creating-a-view-of-database-tables-and-fields.

    View.PNG
  2. Join the Base Element to the Base Relationship and the Base Relationship to the Base Element1:
    BMC.Core:BMC_BaseElement.InstanceID = BMC.Core:BMC_BaseRelationship.Source.InstanceID
    BMC.Core:BMC_BaseRelationship.Destination InstanceID = BMC.Core:BMC_BaseElement1.Instance ID
    The CI name from BMC.Core:BMC_BaseElement is the parent CI name and the CI from BMC.Core:BMC_BaseElement1 gives the child relation.
  3. Create a new report based on the view created in step 1.
    For more information, see Creating-custom-reports-and-charts.
  4. To view the parent and its associate child CI details in the report, use the name from the Base Element table to get the Parent CI. To see the related CI, use the Name from the Element1 table.