Change Report help

[Gemma4]

Hi Everyone,

I need to create a basic list report to show active change requests with the impacted services. I am able to display the data either using change_request table or task_cmdb_ci_service. However, the problem is it is only displaying changes with a business service. For example, we have a total of 30 active changes, but the report is showing 20 and not displaying empty business services. I tried to even filter to display business service is not empty but had no luck. Attached are a couple examples to help explain. In the instance I'm using I don't have admin access, so I am limited on customizations.. not really sure why the data is not displaying. thanks for any feedback you can provide. 

[James Chun]

Hi @Gemma4,

Is there a reason why you would need to display CHGs that have no impacted services associated with them?

What are you trying to achieve with this report?

If you must display all the CHGs (including the ones with and without impacted services), I think you will have to join the two tables as a Database view. I believe this will require admin access, hence you may need some assistance from your system administrator.

Cheers

[Gemma4]

@James Chun Sorry for the late reply. Yes we need to report on Changes that are missing data before CAB and many are not including Business Service. I think you are right I may have to join two tables...so far the data displayed is so different. see below

Table	Business Service	Notes
cmdb_task_chg	Empty Business Services are visible	Ticket data missing
task_cmdb_ci_service	Empty Business Services are missing	Ticket data missing
change_request	Business service is not visible

[James Chun]

No worries, the OOB Database [cmdb_task_chg] looks like the closest you would get but it doesn't show you all CHG records.

Might be faster if you create a new Database view, something like below

Not sure if there is a better way to solve the issue, but I think the above can do its job.

Cheers

[Gemma4]

@James Chun unfortunately in this instance I don't have admin access so I'm trying to utilize the out of the box tables. Any other ideas or suggestions to display all the CHGs including the ones  without impacted services. The goal is to be able to capture the changes of users that are not submitting changes with impacted services and ci's to help educate them on the process. Currently it is a manual process to keep up with. 

thanks in advance for any suggestions.