Get the Application Service of a CI

[ServNowDev]

I am trying to auto populate the Application Service field when a Configuration item is selected, Im not seeing how to use that relationship, is there a way to query the cmdb_ci_service field and get the service of a given CIs Sys id

[Dr Atul G- LNG]

Hi @ServNowDev 

OOTB there is not dependency between CI and Service field , so you need to build the logic, and it is you need to get from cmdb Rel table and also,  in this case, if a CI related with more than 1 A S, then you need to bring that in field and user need to select the required one. 

Looks easy but actually not 🙂 . we did this for our customer.

[ServNowDev]

Any insight on how you built this logic like using database view or specific queries in really banging my head on this one 

[Dr Atul G- LNG]

Sorry mate, I am not developer so dont have much insights but for this

Query on cmdb rel table

if if the CI has more than 1 parent and then filter with AS as parent

and if more than 1 AS then put in array

This is what I know..