Email Notification on CMDB table

[YUVRAJS]

Hii Team

  i want to create a Email Notification on cmdb_ci_rel table.

  There's field in the form (Parent) as "Service Classification" which exists in the "Service Offering" (child) table.

  I am trying to use the condition for this "Service Classification" variable only but in the conditions through related list or child relations also i am not able to get this variable "Service Classification".

  how can i achieve this condition via notification advance script.

[Slava Savitsky · Accepted solution]

Parent and Child fields in [cmdb_rel_ci] records reference [cmdb_ci] table, which is the top of the CMDB hierarchy. However, the field you are looking for (service_classification) is not available at that level. It is defined on [cmdb_ci_service] table level and is therefore only available for that class and its subclasses, including [service_offering].

Here is how you can dot-walk to such a field from the condition builder in the notification record:

1. At the very bottom of the fields list, select "Show Related Fields"
2. Then select "Parent ==> Configuration Item fields"
3. Then select "Offering (+)"
4. Finally, select "Service Classification"