Creating a relationship between a technical service and the CIs that form part of it

[Gideon van Zyl1]

I am currently working on Madrid at a customer and we have implemented ITOM Discovery and Event Management.

Service mapping is not implemented.

What we have been doing is to create technical services to act as collections of CIs using a query and then utilising that for ITSM modules such as Change Management. 

Everything is running well, but now getting to reporting it becomes a bit more tricky, as what we would like to do is to create a report that can report the Technical service(s) that the Server belongs to as part of a list report that includes attributes of the Server. There is however no relationship in the CMDB between the CI and the Technical Service as the list displayed in the Technical Service is not a relationship, but the result of a query. I have also not been able to run a report that reflects what CIs form a part of the Technical Service, or I could have used that as a base to create a report or a set of reports that achieves the same.

Does anybody have any suggestions how we can create a report that can include the Technical Service as an attribute of a CI without actually creating a new field and scripting (or manually)  population of an additional  Technical Service field on the CI?  

-Gideon-

[robertgeen · Accepted solution]

So there are 2 ways you can do this. The first is I believe the svc_ci_assoc table still gets populated for technical services so you could pull your information from there. Secondly you can try to use the CMDB Query Builder in service map mode as I believe it shows technical services but it's been a while since I did that. Hope that helps.

[Gideon van Zyl1]

Thanks Robert,

That addressed the issue. The svc_ci_assoc table contains the association between the services and the CIs, so I could just dotwalk both ways for the attributes and I have a perfect report.

Kind Regards

-Gideon