Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to find hosts on which SQL DBs are running?

maheshvishw
Tera Contributor

3 weeks ago

Hello,

I have list of MS SQL database names, i need to find the associated hosts on which these DBs are running.

There is not related host attribute in SQL DB table under gear icon.

 

Please suggest.

 

Thank you,

 

Labels:
0 Helpfuls
  • 301 Views
1 REPLY 1

lpruit2
Kilo Sage

3 weeks ago

Greetings @maheshvishw . Have you tried searching the Relationships table [cmdb_rel_ci]? That table stores the parent record, parent class, child record, child class, and the relationship type. If ServiceNow recognizes any relationship between the MS SQL database and another device, it would show up in this table. 

You could also try viewing the records from the CMDB Workspace if you have permissions. If no relationship is found, then it could be an issue with how the devices are being Discovered.