generate report on affected and impacted ci's of a change request

[Hiren Potu2]

i want want to generate one single report which will give me all the affected and impacted Ci's of the change request.

[Mohammed_Iqbal]

Hello hiren,

If u want to target only one table and get both affected and impacted Ci's. so for that you need to create data base view of both tables ---task_cmdb_ci_service(impacted ci's) and task_ci(affected CIs).

Thanks

Mohammed Iqbal