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.
- 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.
- 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_BaseElementis the parent CI name and the CI from
BMC.Core:BMC_BaseElement1gives the child relation.
- Create a new report based on the view created in step 1.
For more information, see Creating custom reports and charts.
- 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.