What is the main difference between CMDB SQL Server/SQL Database & SQL Instance Tables

suvetha3 · ‎11-04-2020

What is the main difference between below CMDB Tables.

How can we make the end user understand the basic difference between the below CMDB Table?

MS SQL Server - cmdb_ci_db_mssql_server

MS SQL Database - cmdb_ci_db_mssql_database

MSFT SQL Instance - cmdb_ci_db_mssql_instance

Rahul Priyadars · ‎11-04-2020

MS SQL Server - cmdb_ci_db_mssql_server --> MS Sql Server may be deprecated class

(2) MS SQL Database - cmdb_ci_db_mssql_database -- Databases created on given Sql Instance.

(3)MSFT SQL Instance - cmdb_ci_db_mssql_instance -- Actual Running Process of SQL Server on a given Host.

It Captures Running Instance.

But i see discovery populates data in last 2 Classes .

https://docs.servicenow.com/bundle/paris-it-operations-management/page/product/discovery/reference/mssql-data-collected-pattern.html

Regards

RP

View solution in original post

ChristianE · ‎02-27-2024

Hello! A better terminology would have been to keep the MS SQL Server term instead of MSFT SQL Instance. The running instance is the SQL Server. This instance terminology is tiresome and I just consider instance to mean object instance. If you have a list of SQL Servers you don't need to point out that they are all realisations (instances) of SQL Servers. That's implicit.

I hope the old class MS Sql Server didn't refer to computer systems, like Windows, Unix or Linux, that hosts a running SQL Server. I would like to have a class MS SQL Server hosts that refers to those objects.

rgds Christian