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

[suvetha3]

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 · Accepted solution]

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

[suvetha3]

Thanks for the info. Can you please explain why discovery is not populating in MSSQL Server table?

[Rahul Priyadars]

My Only Guess is its Deprecated Class and not used by PATTERN Based Discovery.

Regards

RP

[suvetha3]

Ok Thanks Rahul