Manual Service mapping

Aradhika Ramesh
Tera Contributor

‎09-20-2022 04:49 AM

Hi,

I know that I can map the service using manual endpoint but in this case I'll be able to do it one at a time. I wanted to like upload excel sheet and do the same manual map for multiple services. What I tried was I checked in what all tables entry is getting created cmdb_ci, cmdb_ci_service, cmdb_ci_service_auto, cmdb_ci_service_discovered, cmdb_ci_endpoint_manual, cmdb_rel_ci. So I created the excel and uploaded in all these table but in cmdb_rel_ci it's not getting uploaded properly. It shows error like multiple parent exist, but when you look at that table parent column does have duplicate name meaning its not unique. Can anyone please tell if its possible to do it via excel sheet upload or if anything wrong with my approach. 

Labels:
0 Helpfuls
  • 827 Views
1 REPLY 1

EricDohr
ServiceNow Employee
ServiceNow Employee

‎09-20-2022 07:03 AM

Try this out

  • Create a test record via the Application Service Wizard with population method "Dynamic Service" 
    • Review the xml of the test record to see what are the appropriate fields are 
  • Start with loading your App Service information into the cmdb_ci_service_calculated table with the appropriate fields populated.  
    • Validate your App Services have been populated correctly and are usable
  • Import your CI Relationships via the cmdb_rel_ci

My assumption is that by you doing these steps and utilizing the Dynamic Service population method, the system will dynamically create and manage the endpoints and populate the svc_ci_assoc table.  You may want to start with one app service as a test method

You need to make sure that the Application Service record name has a unique value, btw

 

0 Helpfuls