What table is used for Application Service

[jimmillet]

When I look in the CSDM documentation for the table name for Application Service, I see this: cmdb_ci_service_auto. Even the CI Class Manager shows this.

But in the filter navigator, under Configuration > Application Services, I see csdm_app_services_list. When I go to tables module, I don't see any table with name of csdm_app_services

In the filter navigator, under Service Mapping > Application Services, I see "sa_discovered_services_list". When I go to tables module, i don't see any table with name of sa_discovered_services. In the CSDM documentation and CI Class Manager, the table name for a mapped application service is "cmdb_ci_service_discovered"

So why do the filter navigator selections go to somewhere different than the tables that are in the documentation?

Thanks,

Jim Millet

[Vivi Brasil · Accepted solution]

@jimmillet those modules in the application menus in regards to CSDM and Service Mapping use views to consolidate records from different tables. If you open Service Mapping >> Application Services list, then add the column "Class", you will see the records belong to the Mapped and Calculated tables (both tables).

Along to those views, there are some wizards, if you open a record from the list (as usual you would open the form view), you will see in the URL the following: $sa_business_service (the preffix char $ is related to the wizard).

Notice the tables are not the only source to show records, there are Database Views, Wizards, UI Pages, Scripted Relationships and so on.

Viviane Brasil

[Kalyan Madineni]

Hello @jimmillet the part of the url that you see when you navigate using Configuration>Application Services are not actual tables but few UI pages, wizards and views.

With the advent of CSDM, ServiceNow have provided a wizard based method to create Application Service which ensures all the necessary fields, relationships, references and entry points for the application service is created is a guided format.

So the name you notice "csdm_app_service" is not a table but a page that helps users to always redirect to the wizard based view of the Application Service.

The underlying tables used to store the application services are the same tables mentioned by Sandeep in his response.

Hope this helps!