Our configuration manager wants to have multiple drill down on the CMDB View Dashboard. The ones that he is looking for are drill down on portfolio, technical service & offering. I had a look at the data collected in cmdb_health_result table and I couldn't find any field that is capturing the technical service or offering. My initial thought was,
- Create custom list fields called Related Services and Related Service Offerings on cmdb_health_result table.
- Write a script(which will run after the OOB daily job) to populate the custom fields by looking up on the svc_service_assoc table for the related application services and then find the related technical service and offering using the application service.
The custom fields should be of list type because a CI can be related to multiple application services and to multiple offerings. Then I realised that I won't be able to use the list type fields in breakdowns. Is there anyway I can achieve this functionality?
#CMDB #CSDM #CMDB_View_Dashboard #Performance_Analytics
