How to fetch change task details associated with a change request ?

[learner12]

Hi All,

I am trying to get the details of a change request usign the JSON service.

Url : https://<instance name>.service-now.com/change_request.do?XML&sysparm_query=number=CHG000abc&display...

In the response , I am not able to find any change task details. Kindly let me know how to get the change task details assiciated with a change request.

Thanks!

[learner12]

ctomasi

We will try the rest api option. We don't have access to rest api as of now.

Also, we are able to get the change details and ctask details if we have the numbers separately as stated above. Is there any way to get ctask associated with a change ?

In the ctask, I can see the change number but from change number can we get the associated ctask numbers ?

[Chuck Tomasi]

As noted before, you need to get the change (parent) before you can get the change tasks (children). That's the way the relationship in the database is set up.

[learner12]

ctomasi

Hi Chuck,

When we get the change details based on change number we cant see the ctask number in it that are associated with that change.

We are using the below mentioned URL :

https://<instance-name>.service-now.com/change_request.do?JSONv2&sysparm_query=number=CHG00012345&di...

[Chuck Tomasi]

That is correct, Neetu. You are doing a query for a specific record on the change_request table. By default, it does not return all related records in the system. For that you either need to a) keep the sys_id of the change_request record retrieved and make a second query against the change_task table, or b) create a scripted REST API to do this all in one request for you - as noted before.

[aj99999]

Hi Chuck - my end goal is something like this...

for CIs x,y and z

with associated Tasks scheduled to start or end in between 2 dates

return...

Change 100 (parent)
Task (child)
Task (child)
Task (child)
Change 193 (parent)
Task (child)
Task (child)
Task (child)
etc, etc....

What is the best way to do that via REST? I would think lots of people would have this requirement to see a list of upcoming Changes and all the Tasks under each - so if this requires a scripted REST API then could ServiceNow provide one for everybody? Rather than us all reinventing the wheel.

Thanks!