Return list of application related to server

[Kingstan M]

Hello SNC,

I have an requirement where - I need to get the list of application (*FROM : cmdb_ci_service_discovered) from *its table for any server (FROM: cmdb_ci_server).

When I pass thro., script include function of server sys_id, I must get those all application related to that server.

Any road-map, Please?

Many thanks.

[Mateus Oliveira]

Hi,

It seems a requirement that can be achieved by using CMDB Query Builder. Have you tried this option already? Some info about it: https://docs.servicenow.com/bundle/sandiego-servicenow-platform/page/product/configuration-managemen...

I hope this helps you. Please, mark my reply as helpful in case it was. 🙂

[EricDohr]

Second the CMDB Query Builder! You can quickly grab the nodes and adjust filters to each tables.  From there you can actually create a schedule and then a report that will establish a data source for you to leverage dot walk.

[Henrik Jutterst]

This simple screen shot solved what I was looking for myself.

Thanks for sharing your knowledge!

And thank you @Kingstan M for bringing up the question!

[suvro]

You can check out table svc_ci_assoc table where all applications related to a service is listed. You can fetch applications and servers associated with a service from there.

Then you can query the cmdb_rel_ci table to check for all the relationships of that particular servers.

Scripting on these two tables can help you achieving your goal

Below article will help you if you need help in GlideAjax

https://community.servicenow.com/community?id=community_article&sys_id=c77ff0dddbbb8190847d5ac2ca96198a