{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":47069,"path":"servicenow-platform/configuration-management-database-cmdb/t_CreateACIRelationRollup.md","title":"Create a CI relation rollup","bundle":null,"doc_type":null,"release":"australia","body":"\n# Create a CI relation rollup\n\nA CI relation rollup allows you to sum, count, max, min, or mean a relationship type. You can create CI relation rollups.\n\n## Before you begin\n\nRole required: ecmdb\\_admin\n\n## About this task\n\nCI relation rollup can be useful for tracking and for receiving notifications. For example:\n\n-   In a sum roll up, add up fields from multiple CIs and display the result on another CI to which they are related. So, if you have four configuration items in a rack that are all consuming power, create a CI relation rollup to add all the power usage together and display the result in one field on the rack CI form.\n-   If a certain level of power consumption in a rack is exceeded, send a notification.\n-   With a rack that has 10 slots, send a notification when 9 slots are filled.\n\nCI relation rollups use the **cmdb synch event** business rule on the \\[cmdb\\_ci\\] table. Although this business rule is active by default, you must modify the rule slightly before it will run.\n\n## Procedure\n\n1.  Navigate to **All** > **Configuration** > **Relationships** > **CI Relation Rollups**.\n\n2.  Click **New**.\n\n3.  Complete the form.\n\n    |Field|Description|\n    |-----|-----------|\n    |CI Relationship Type|Select a relationship type from the list to use with the rollup. For example, **Members::Member** of contains the parent descriptor **Members** and the child descriptor **Member of**.|\n    |Type|Select the type of rollup from the drop-down list: COUNT, MAX, MEAN, MIN, or SUM.|\n    |Parent field|The target field on which the operation will be done.|\n    |Child field|The input to the equation type. The Parent field is affected by the selections in the child field.|\n    |Rollup class|The classes that can use the relationship. For example, you can specify that the relationship only applies to racks.|\n\n4.  To run the **cmdb synch event** business rule, navigate to **Business Rules**.\n\n5.  Use the search box to find the \\[cmdb synch event\\] table.\n\n6.  Click the **cmdb synch event** business rule to go to the **Business Rule** page.\n\n7.  Select the **Update**, **Delete**, and **Query** check boxes.\n\n    Additionally, if you wish CI relation rollups to recalculate when there is a change to a relationship, use a similar procedure to select the **Active** check box on the **cmdb\\_rel\\_ci synch event** business rule.\n\n\n**Parent Topic:**[CI relationships in the CMDB](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/servicenow-platform/configuration-management-database-cmdb/c_CIRelationships.md)\n\n**Related topics**  \n\n\n[Suggested class relationships]()\n\n[Add a suggested relationship]()\n\n[Relationship governance rules]()\n\n[CI relations formatter]()\n\n[CI relationship editor]()\n\n[Relation qualifier]()\n\n[CI relationship security]()\n\n[CI relationships in the CMDB](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/servicenow-platform/configuration-management-database-cmdb/c_CIRelationships.md)\n\n"}}