How do I create a report of all impacted services and there current open change requests

[#1]

I have added the related lists of affected CI and impacted services to the change request form and also on the business services form added change request as the related list but for the life of me I cannot create a report of all impacted services and there current open change requests or other way round

[Mark Stanger]

You'll need to report off of the 'CIs Affected (task_ci)' and 'Impacted Services (task_cmdb_ci_service)' tables to get this information. Both of those tables are a many-to-many table for the CI-Task relationship.

Because they both reference the task table, if you need information specific to a particular task table (like change_request) you may have to join one of those tables to the 'change_request' table using a database view. This isn't necessary unless you've got fields specific to your change_request table that aren't shared by all tasks.

[#3]

thanks, just checked and task does not contain change request

[#4]

sorted thanks, great one

[Victor Ruiz]

Hi Mark,

How would I go about joining change_request and task_ci using database views?   thanks in advance....