Report on Affected CI table & Change Request

[Naveen87]

Hello Developers,

On a CHG record, We have a related list call Affected CI.

I'm creating a report on task_ci table to show the CHG record where these Affected CI are mentioned.

I have 1000's of CI for which report needs to be fetched. I don't want to add 1000's OR conditions.

Is there a way/condition which is written on Parent of CI & all downstream CI's are shown?

Ex:- 

SW_License_Key_PRD is a Parent CI(cmdb_ci_appl). It has 22 downstream CI.

Weblogic instance_SW_License_Key_PRD_fieslgp02_wl-clics-clics-2 is 1 of them.

On CHG0325591, Weblogic instance_SW_License_Key_PRD_fieslgp02_wl-clics-clics-2 is affected CI. 

I don't wish to add rest 21 CI in the report condition to fetch it.

I wish to add the Parent "SW_License_Key_PRD is a Parent CI(cmdb_ci_appl)" which will show all CHG's where 22 downstream/child CI's are used

Please suggest a way out.

[Mark Manders]

What is the information you are actually looking for? What requirement/business case are you trying to resolve? 1000's of CI's can have many more changes, so you get a report with a lot of changes. Who is going to look at this and what is it they want to see?

[Naveen87]

@Mark Manders ,

Service Owners have their CI's.

When their CI's are used under Change Request as affected CI.

They must be aware & this report is scheduled to provide this information to them.

[Mark Manders]

Then I would create it like:

task.task_type = change_request

ci_item.owned_by  is dynamic me

Put it on a dashboard and every one will see the changes related to their CI's.

[Naveen87]

There is no field called Owner on the CI form.

I tried to write a report on task table. 

Condition 1 = task.task_type=change_request

Condition 2 = I want to show ci.parent = SW_License_Key_PRD.

So this shows 22 downstream under (SW_License_Key_PRD) & CHG records where any of these 22 CI are used.

I don't find ci.parent.