Creating connection to specified database on MS SQL Server (not to instance)

[Renata7]

Hi SMEs

I am creating Service Map and want to create connection to MS SQL database.
I do not want to see all 121 databases on the map, but only one that the application connects to:

This is what I have defined in discovery pattern in connection section - parameter database is given there:

Could you please advise how to do to it to have only one database shown on the map (at the moment I can see 121 DB which resides on the instance)?

In advance thank you for your support
Renata Sieczka-Parcej

 

[Saiganeshraja]

You need to establish the relationship between

1.Application and DB instance ( cmdb_ci_db_instance)

2. DB instance and Database 

then only the specific database would be shown the tree graph.

Mark correct and if it helps.

[Renata7]

Hi

Thank you for replying.
Sorry for late answer, I was on vacations.
The CI relationship between DB instance and DB was already there (cmdb_ci_db_mssql_instance and cmdb_ci_db_mssql_database) so I do not need to add this relations.
Anyway all DBs on this instance appear in the Service Map.

Kind regards

Renata Sieczka-Parcej

[stephane_P]

Very interested if anyone found a solution here as I have the same problem as with MS SQL, connecting to an instance leads to the discovery of all databases on that instance, which for most have nothing to do with the application. I can add a "boundary" on the connection but then it hides the instance ( as  the connection is to the instance and databases are inclusions). Not sure how to go from there.