Is there a way to have Discovery build relationships between database catalogs and instances?

[sterrell24]

We have discovery setup to discovery MS SQL servers in our environment. When it runs, it automatically build the relationship between the SQL instance, and the server it runs on (MSSQLSERVER@server01 RUNS ON server01). Is there way for discovery to also build the relationship between the database (MSFT SQL Catalogs table) and the instance. It appears that discovery doesn't build any relationships on the records in the MSFT SQL Catalogs table. We would like those relationships automatically built so that if we select a DB name in our CI relationships, it would show that the DB RUNS ON->Instance name. We can currently do this manually, but it would save a ton of time if discovery did it automatically.

[daniel_badyan]

Yes, there is 🙂

when you run discovery on a host that has MS SQL server installed on it, notice in the discovery log the pattern that executes to discover that MS SQL server. you can open the log for that, select the identification and press debug, then just edit the pattern: add a "create relationshop/reference" step and link these two together. it's relatively easy to customize.

if you're running probes and not patterns, i would personally not recommend trying to customize it yourself as new content is not being released via probes, only patterns. it's only much more complicated.

in this case i would suggest switching from probes to patterns and then trying to customize.

[Guilherme10]

Hi Daniel,

I´m facing the same issue. is there any manual with step by step that you can share with us?

For me is not clear where I need to "create relationshop/reference" in order to have the Server/instance/DB relationhip.

[Peter Luther]

Did you find a way of handling this? I'm also struggeling getting the mssql databases related to the instances