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_BaseElement is the parent CI name and the CI from BMC.Core:BMC_BaseElement1 gives 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.