how to create change requests list for impacted services for specific configuration item?

[has]

I am looking for some help.  

I need to create a report from change request for a selected configuration item and list all impacted business services for chosen date range.I tried to create a brand new report for change request and type = list, group by configuration item = selected one.  

I can not find the Impacted business services as an option for the reporting and not sure if that is my security access issue with my role or something else.

[has]

Correct answer! Great help!

[has]

Thanks a million for all your help and quick response on my question.   I am getting what I need...   Since I am new to service now, was wondering if you can guide me to a document or video where I can learn about table structure and fields so would make it easier for me to create reports in service now.

Thanks again for awesome help!

Regards,

Hema Shah, PMP

[Alikutty A]

Hi Hemangini,

Request you to mark one of my answer response as correct and helpful as this would help me in the community, sort of motivation.

For this post, the answer should basically be the report screenshot I had given you, so can you please mark it as correct answer?

Let me try to get some documents that you can refer on tables & reports

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[has]

I did it once before and I did it again. I hope I am doing it right. can

you please let me know?

Regards,

Hema Shah, PMP

Operational Effectiveness/Performance Excellence

ITS - University of Michigan

*2019 ASB 1009 Greene St *

Ann Arbor, MI 48109-1432

Office: 734.647-1573 <http://734.647-1573/>

email: hemashah@umich.edu <hemashah@umich.edu>

On Tue, Mar 14, 2017 at 9:54 AM, alikuttyka <

[Alikutty A]

It did not work correctly   You can click on the correct answer and helpful on my first response to this post.

Hi,

Are you reporting on Impacted Services table?

Please select the table as Impacted Services, Group By as Task.Configuration Item and add your date field filter on Task.fields. Let me know if this works.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response