CMDB Relationship table - How to get the Child.class (Windows Server etc.) ?

getknk
Kilo Contributor

hi Guys,

I was trying to query ServiceNow API to get details of a CI and link it to the IT-Service etc. So basically querying the cmdb_rel_ci table. I'm using DOT walking and fetching all data correctly, except the child.class . Rest everything comes perfectly

Below is the Query

https://xxxx.service-now.com/api/now/table/cmdb_rel_ci?sysparm_query=parent.sys_class_name=service_offering%5Echild.operational_status=1&sysparm_fields=parent.sys_id,parent.name,child.sys_id,child.name,child.class

Is the "Child.class" known by another name within ServiceNow? The above logic works correctly if I do Report within ServiceNow and it is called "child.class" in the report screen

 

 

1 ACCEPTED SOLUTION

Ahmmed Ali
Mega Sage

it is child.sys_class_name

 

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

View solution in original post

2 REPLIES 2

Ahmmed Ali
Mega Sage

it is child.sys_class_name

 

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

Thanks mate. It worked.