Where does Service Mapping store Relationships?

[treycarroll]

We have been using traditional discovery and relying upon relationships being stored in the cmdb_rel_ci table.     At K17 I saw sabell2012's   presentation (or it may have been Sara Bowers Reinhart's with Steven doing backup)   on Service Mapping.   Steven mentioned that SM stores relationships in a different table.     I just reviewed all the table names containing "service" and nothing is jumping out at me as the obvious location for this information.   Does anybody know which table this "lives" in?     Also, any comments on the issues that you have encountered when storing information there / how to work in tandem with relationships stored in cmdb_rel_ci would be appreciated.    

Thanks,

Trey Carroll

[vNick]

Hi Trey

You might check svc_ci_assoc to see if it's what you're looking for.

[treycarroll]

Hi Nick,

Thank you so much for the reply.     That table is very interesting and could be what Steve mentioned.   I just didn't expect it to directly link each CI to the Business Service.     I am accustomed to CIs being related hierarchically up to the Business Service.     I'll keep poking around and mark this correct if it turns out to be the main relationship table for Service Mapping.

Regards,

Trey Carroll

[sabell2012]

Trey:

This one is a bit messed up as you have found.   Sarah and I found that with Istanbul ServiceNow has appeared to have changed the structure.   It USED to be in the svc_ci_assoc table.   There were also dependencies listed in svc_layer, but those have been vacated.   Sooo, digging.   We will find out and post it here.

BTW, check this out if you have not already.   I describe several patterns for SM business services here:

Pragmatic Patterns — Hybrid Business Service Management Patterns

Steven.