How to get only L1 relationships from Service Association CI table

[MaheshArcot]

I am working on a dashboard to show Business Application to Application Service relationships and need to filter only L1 (direct) relationships from the Service Association CI table.

In the Relationships UI, setting the max level to 1 shows only L1 relationships, but I am not sure how to achieve the same at the table level for reporting purposes.

Could you please advise:

• Is there any field in the Service Association CI table that identifies L1 relationships?
• If not, what is the recommended approach to get only direct (L1) associations for this dashboard?

Any guidance or best practice would be helpful.

[MaheshArcot]

Hi Anders,

Yes, I worked with the CMDB Query builder. Could you advise on how to apply a filter L1 relationships alone within the Service Association CI table?

[CasperJT]

Hi Mahesh,

To my knowledge this is not possible through Service Associations, however the CI relations table is exactly that. Parent and Child relations.

So if you go to cmdb_ci_rel and filter "parent.class IS business application" and child.class IS mapped application service" you will get Business Applications and their first level relationship with mapped application services.

https://YOURINSTANCE.service-now.com/cmdb_rel_ci_list.do?sysparm_query=parent.sys_class_name%3Dcmdb_...

Hope this helps.

//Casper

[AndersBGS]

Hi @MaheshArcot ,

You need to change the relation between "mapped application service" and "service configuration service" as far as I can see from your screenshot. Or do you mean Li directly between "business application" and "service configuration service"?

[MaheshArcot]

Hi @AndersBGS ,

I want to keep only L1 relationship directly between "business application" and "service configuration service" 

[AndersBGS]

Hi @MaheshArcot ,

But is there a direct L1 relationship between business application and service configuration service in your instance?