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