- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2023 03:03 AM
Hi all,
We noticed that during the discovery and creation of our MS SQL Databases the instance_name (link to MS SQL Instance) is not always set.
I tried to figure out where setting this value was done, so I could investigate why it is not always working and being set, but wherever I look (Pre/Post Pattern scripts, Business Rules, Script Includes) nowhere it seems this is set.
Checking the results in the ECC Queue, the instance_name is also not set during pattern executing on the MID-server.
Does anyone have a clue where the cmdb_ci_db_mssql_database.instance_name is set during discovery so I can investigate why for some discovered DBs this is not set?!?
Solved! Go to Solution.
- Labels:
-
Discovery

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2023 08:29 PM
Hi Patrick
Please have a look at this App Pattern- MS Sql DB On Windows
did u tried running in debug mode.
Regards
RP

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2023 08:29 PM
Hi Patrick
Please have a look at this App Pattern- MS Sql DB On Windows
did u tried running in debug mode.
Regards
RP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2023 11:49 PM
Hi Rahul,
Thanks, I thought I had checked it all, but in the library 'MSSQL populate database table ' used by the MS Sql DB On Windows pattern in its last step it created the relationship indeed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 12:30 AM
+1 ..Good to see you found that.
Regards
RP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tuesday
where can this be found?