Reporting CIs added manually to Service Maps (Service Mapping)

[Marek Meres]

Hello Guys,

I have added CI(s) manually to some Service Maps produced by Service Mapping (as per Manually add CIs to an application service (servicenow.com)) and now I need to quickly know what CIs I have added. How can I get/create a report or is there any other way ootb to give me that?

It looks like all manually added CIs cause creating a CI of the "Manual Endpoint" class and that CI is related to the actual manually added CI and the "parent" CI it was added to. So "adding CI manually" actually adds two relationships in "cmdb_rel_ci" table + one CI in the "cmdb_ci_endpoint_manual" table. In addition, a record is created in the "svc_ci_assoc" table showing the "Manual endpoint" in the "Configuration Item" reference and the Application Service in the "Service Id" reference field.

So I thought that creating a DB view (or maybe CMDB Query but I failed with that for now) concatenating as follows:

Application Service <- (Service Id) svc_ci_assoc (Configuration Item) -> Manual Endpoint -> cmdb_rel_ci -> <actual manually added CI>

will give me what I need to report. In addition I would only include Application Services of the "Mapped Application Service" [cmdb_ci_service_discovered] type so Manual Endpoints auto-created for "Calculated Application Services" will be excluded.

Did I get it correctly? Did I miss anything? Is there some official documentation on this?

Many thanks for all answers!

Best regards,

Marek