ServiceNow reports to pull data related to changes -


how create report give me list of changes , it's associated "affected cis". e.g. have change ticket created in servicenow chg00001 following values configuration item , affected cis:

  • change number: chg00001
  • configuration item: server1
  • affected ci:
      1. apache
      1. jboss

so when create report need these information including affected cis, don't see way pull information.

you want use cis affected [task_ci] table. table contains links between change requests , configuration item.

the task field in table contains reference change request.

in report, try this

  • data: table => cis affected [task_ci]
  • type: list
  • group by: task

selected columns

  • task
  • configuration item

filter

  • task.task type is change request

you can expand task reference in selected columns more details on change request if needed, or filter them deeper.

if you've filtered task type change request, can select extended table change request , filter way

filter

  • task.task type is change request
  • task.change request.planned start date at or after last month

Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -